[ Avaa Bypassed ]




Upload:

Command:

hmhc3928@18.217.27.209: ~ $
DROP TABLE IF EXISTS t1 ;
# READ_ONLY does nothing to SUPER users
# so we use a non-SUPER one:
GRANT CREATE, SELECT, DROP ON *.* TO test@localhost;
connect  con1,localhost,test,,test;
connection default;
SET GLOBAL READ_ONLY=1;
connection con1;
CREATE TEMPORARY TABLE t1 (a INT) ENGINE=INNODB;
# Test INSERTS with autocommit being off and on.
BEGIN;
INSERT INTO t1 VALUES (10);
COMMIT;
INSERT INTO t1 VALUES (20);
# Test UPDATES with autocommit being off and on.
BEGIN;
UPDATE t1 SET a=30 WHERE a=10;
COMMIT;
UPDATE t1 SET a=40 WHERE a=20;
connection default;
SET GLOBAL READ_ONLY=0;
# Test scenario where global read_only is enabled in the middle of transaction.
# Test INSERT operations on temporary tables, INSERTs should be successful even
# when global read_only is enabled.
connection con1;
BEGIN;
INSERT INTO t1 VALUES(50);
connection default;
SET GLOBAL READ_ONLY=1;
connection con1;
SELECT @@GLOBAL.READ_ONLY;
@@GLOBAL.READ_ONLY
1
COMMIT;
connection default;
SET GLOBAL READ_ONLY=0;
# Test UPDATE operations on temporary tables, UPDATEs should be successful even
# when global read_only is enabled.
connection con1;
BEGIN;
UPDATE t1 SET a=60 WHERE a=50;
connection default;
SET GLOBAL READ_ONLY=1;
connection con1;
SELECT @@GLOBAL.READ_ONLY;
@@GLOBAL.READ_ONLY
1
COMMIT;
SELECT * FROM t1;
a
30
40
60
# Clean up
connection default;
SET GLOBAL READ_ONLY=0;
disconnect con1;
DROP USER test@localhost;

Filemanager

Name Type Size Permission Actions
binlog_base64_flag.result File 3.81 KB 0644
binlog_bug23533.result File 486 B 0644
binlog_bug36391.result File 143 B 0644
binlog_cache_write_failure.result File 2.39 KB 0644
binlog_checksum.result File 698 B 0644
binlog_crash_safe_master_checksum.result File 1.15 KB 0644
binlog_database.result File 9.67 KB 0644
binlog_delete_and_flush_index.result File 1.73 KB 0644
binlog_dmls_on_tmp_tables_readonly.result File 1.37 KB 0644
binlog_drop_if_exists.result File 5.35 KB 0644
binlog_enforce_gtid_consistency.result File 5.09 KB 0644
binlog_error_action.result File 7.55 KB 0644
binlog_format_switch_in_tmp_table.result File 2.65 KB 0644
binlog_grant.result File 1 KB 0644
binlog_gtid_cache.result File 5 B 0644
binlog_gtid_errors.result File 8.71 KB 0644
binlog_gtid_exhausted.result File 1.1 KB 0644
binlog_gtid_implicit_commit.result File 12.4 KB 0644
binlog_gtid_innodb.result File 6.31 KB 0644
binlog_gtid_mysqlbinlog_row.result File 217.54 KB 0644
binlog_gtid_mysqlbinlog_row_innodb.result File 244.09 KB 0644
binlog_gtid_mysqlbinlog_row_myisam.result File 245.4 KB 0644
binlog_gtid_mysqlbinlog_start_stop.result File 53.15 KB 0644
binlog_gtid_row_ctype_ucs.result File 1.47 KB 0644
binlog_gtid_simple_recovery.result File 1.82 KB 0644
binlog_gtid_stm_ctype_ucs.result File 1.64 KB 0644
binlog_gtid_utils.result File 11.43 KB 0644
binlog_hexdump.result File 6.52 KB 0644
binlog_implicit_commit.result File 11.05 KB 0644
binlog_incident.result File 181 B 0644
binlog_incident_ignore.result File 181 B 0644
binlog_index.result File 11.43 KB 0644
binlog_innodb.result File 6.21 KB 0644
binlog_innodb_row.result File 3 KB 0644
binlog_killed.result File 3.74 KB 0644
binlog_killed_simulate.result File 1.19 KB 0644
binlog_max_extension.result File 378 B 0644
binlog_mixed_cache_stat.result File 3.2 KB 0644
binlog_mixed_load_data.result File 420 B 0644
binlog_multi_engine.result File 5.16 KB 0644
binlog_mysqlbinlog-cp932.result File 358 B 0644
binlog_mysqlbinlog_base64.result File 1.71 KB 0644
binlog_mysqlbinlog_concat.result File 488 B 0644
binlog_mysqlbinlog_filter.result File 1.48 KB 0644
binlog_mysqlbinlog_raw.result File 832 B 0644
binlog_mysqlbinlog_row.result File 178.43 KB 0644
binlog_mysqlbinlog_row_innodb.result File 240.22 KB 0644
binlog_mysqlbinlog_row_myisam.result File 241.53 KB 0644
binlog_mysqlbinlog_row_trans.result File 15.47 KB 0644
binlog_mysqlbinlog_start_stop.result File 45.55 KB 0644
binlog_mysqlbinlog_start_stop_slave_server_id.result File 3.94 KB 0644
binlog_old_versions.result File 1.59 KB 0644
binlog_query_filter_rules.result File 187 B 0644
binlog_reset_master.result File 14 B 0644
binlog_rewrite.result File 6.65 KB 0644
binlog_rotate_bgc_sync.result File 1.82 KB 0644
binlog_row_binlog.result File 42.98 KB 0644
binlog_row_cache_stat.result File 3.2 KB 0644
binlog_row_ctype_cp932.result File 87.42 KB 0644
binlog_row_ctype_ucs.result File 1.36 KB 0644
binlog_row_drop_tbl.result File 567 B 0644
binlog_row_drop_tmp_tbl.result File 3.44 KB 0644
binlog_row_insert_select.result File 758 B 0644
binlog_row_mix_innodb_myisam.result File 30.4 KB 0644
binlog_row_mysqlbinlog_db_filter.result File 1.5 KB 0644
binlog_row_mysqlbinlog_verbose.result File 2.84 KB 0644
binlog_row_query_log_events.result File 442 B 0644
binlog_server_id.result File 459 B 0644
binlog_server_start_options.result File 52 B 0644
binlog_sf.result File 1.67 KB 0644
binlog_spurious_ddl_errors.result File 2.97 KB 0644
binlog_sql_mode.result File 3.46 KB 0644
binlog_start_comment.result File 371 B 0644
binlog_statement_insert_delayed.result File 2.78 KB 0644
binlog_stm_binlog.result File 41.24 KB 0644
binlog_stm_blackhole.result File 7.89 KB 0644
binlog_stm_cache_stat.result File 3.2 KB 0644
binlog_stm_ctype_cp932.result File 87.42 KB 0644
binlog_stm_ctype_ucs.result File 1.53 KB 0644
binlog_stm_do_db.result File 2.41 KB 0644
binlog_stm_drop_tbl.result File 513 B 0644
binlog_stm_drop_tmp_tbl.result File 4.16 KB 0644
binlog_stm_insert_select.result File 711 B 0644
binlog_stm_mix_innodb_myisam.result File 35.93 KB 0644
binlog_stm_ps.result File 1.16 KB 0644
binlog_stm_row.result File 3.07 KB 0644
binlog_stm_unsafe_warning.result File 4.76 KB 0644
binlog_stm_user_variables.result File 5.31 KB 0644
binlog_switch_inside_trans.result File 7.97 KB 0644
binlog_tmp_table.result File 905 B 0644
binlog_truncate_kill.result File 1.23 KB 0644
binlog_truncate_myisam.result File 2.97 KB 0644
binlog_trx_empty_assertions.result File 884 B 0644
binlog_unsafe.result File 194.55 KB 0644
binlog_unsafe_stmt_capable_engine.result File 186.33 KB 0644
binlog_use_gtid_skip.result File 311 B 0644
binlog_variables_log_bin.result File 319 B 0644
binlog_variables_log_bin_index.result File 313 B 0644
binlog_variables_relay_log.result File 475 B 0644
binlog_variables_relay_log_index.result File 469 B 0644
binlog_write_error.result File 2.47 KB 0644
binlog_xa_handling.result File 280 B 0644
show_binlog_events_no_lock.result File 324 B 0644