Gecko [ 122.154.134.11 ]

Name	Size	Permission
binlog_base64_flag.test	5.38 KB	-rw-r--r--
binlog_bug23533.test	1.45 KB	-rw-r--r--
binlog_bug36391-master.opt	32 B	-rw-r--r--
binlog_bug36391.test	1023 B	-rw-r--r--
binlog_database.test	369 B	-rw-r--r--
binlog_delete_and_flush_index....	3.49 KB	-rw-r--r--
binlog_drop_if_exists.test	3.47 KB	-rw-r--r--
binlog_grant.test	1.82 KB	-rw-r--r--
binlog_incident-master.opt	52 B	-rw-r--r--
binlog_incident.test	939 B	-rw-r--r--
binlog_index-master.opt	16 B	-rw-r--r--
binlog_index.test	7.34 KB	-rw-r--r--
binlog_innodb.test	3.97 KB	-rw-r--r--
binlog_innodb_row.test	2.19 KB	-rw-r--r--
binlog_killed.test	8.21 KB	-rw-r--r--
binlog_killed_simulate-master....	39 B	-rw-r--r--
binlog_killed_simulate.test	2.54 KB	-rw-r--r--
binlog_mix_innodb_stat.test	230 B	-rw-r--r--
binlog_mixed_failure_mixing_en...	143 B	-rw-r--r--
binlog_mixed_load_data.test	501 B	-rw-r--r--
binlog_multi_engine.test	2.78 KB	-rw-r--r--
binlog_mysqlbinlog-cp932-maste...	23 B	-rw-r--r--
binlog_mysqlbinlog-cp932.test	975 B	-rw-r--r--
binlog_mysqlbinlog2.test	7.07 KB	-rw-r--r--
binlog_mysqlbinlog_base64.test	2.45 KB	-rw-r--r--
binlog_mysqlbinlog_row.test	10.67 KB	-rw-r--r--
binlog_mysqlbinlog_row_innodb....	638 B	-rw-r--r--
binlog_mysqlbinlog_row_myisam....	631 B	-rw-r--r--
binlog_mysqlbinlog_row_trans.t...	3.71 KB	-rw-r--r--
binlog_old_versions.test	4.99 KB	-rw-r--r--
binlog_query_filter_rules-mast...	40 B	-rw-r--r--
binlog_query_filter_rules.test	808 B	-rw-r--r--
binlog_reset_master.test	998 B	-rw-r--r--
binlog_row_binlog-master.opt	24 B	-rw-r--r--
binlog_row_binlog.test	223 B	-rw-r--r--
binlog_row_ctype_cp932.test	228 B	-rw-r--r--
binlog_row_ctype_ucs.test	234 B	-rw-r--r--
binlog_row_drop_tmp_tbl.test	232 B	-rw-r--r--
binlog_row_failure_mixing_engi...	141 B	-rw-r--r--
binlog_row_innodb_stat-master....	26 B	-rw-r--r--
binlog_row_innodb_stat.test	228 B	-rw-r--r--
binlog_row_insert_select.test	471 B	-rw-r--r--
binlog_row_mix_innodb_myisam-m...	29 B	-rw-r--r--
binlog_row_mix_innodb_myisam.t...	545 B	-rw-r--r--
binlog_row_mysqlbinlog_db_filt...	4.12 KB	-rw-r--r--
binlog_row_mysqlbinlog_verbose...	3.76 KB	-rw-r--r--
binlog_server_id.test	663 B	-rw-r--r--
binlog_sf.test	2.67 KB	-rw-r--r--
binlog_sql_mode.test	4.58 KB	-rw-r--r--
binlog_start_comment.test	900 B	-rw-r--r--
binlog_statement_insert_delaye...	336 B	-rw-r--r--
binlog_stm_binlog-master.opt	40 B	-rw-r--r--
binlog_stm_binlog.test	483 B	-rw-r--r--
binlog_stm_blackhole.test	267 B	-rw-r--r--
binlog_stm_ctype_cp932.test	278 B	-rw-r--r--
binlog_stm_ctype_ucs.test	249 B	-rw-r--r--
binlog_stm_do_db-master.opt	38 B	-rw-r--r--
binlog_stm_do_db.test	2.78 KB	-rw-r--r--
binlog_stm_drop_tmp_tbl.test	247 B	-rw-r--r--
binlog_stm_innodb_stat-master....	26 B	-rw-r--r--
binlog_stm_innodb_stat.test	234 B	-rw-r--r--
binlog_stm_insert_select.test	252 B	-rw-r--r--
binlog_stm_mix_innodb_myisam-m...	29 B	-rw-r--r--
binlog_stm_mix_innodb_myisam.t...	512 B	-rw-r--r--
binlog_stm_ps.test	701 B	-rw-r--r--
binlog_stm_row.test	3.06 KB	-rw-r--r--
binlog_stm_unsafe_warning-mast...	38 B	-rw-r--r--
binlog_stm_unsafe_warning.test	3.7 KB	-rw-r--r--
binlog_tmp_table.test	3.94 KB	-rw-r--r--
binlog_truncate_innodb-master....	14 B	-rw-r--r--
binlog_truncate_innodb.test	1.07 KB	-rw-r--r--
binlog_truncate_myisam.test	352 B	-rw-r--r--
binlog_unsafe.test	13.34 KB	-rw-r--r--
binlog_write_error.test	2.31 KB	-rw-r--r--
disabled.def	634 B	-rw-r--r--

Code Editor : binlog_tmp_table.test

# ==== Purpose ====
#
# Test if statements used temporary tables are binlogged correctly
#
# ==== Method ====
#
# Use two connections, use temporary tables on both of them, and by
# switching connections between statements, the test can check if the
# statements are logged with the correct thread id.
# 
# The statements current tested include:
#   CREATE TEMPORARY TABLE
#   CREATE TEMPORARY TABLE LIKE
#   INSERT
#   REPLACE
#   UPDATE
#   INSERT SELECT
#   TRUNCATE
#
# Note: When adding new query statements, please add them between the
# two 'flush logs'. And aslo please make sure the connection is
# switched between each statement.
#
# ==== Related bugs ====
#
# BUG#35583 mysqlbinlog replay fails with ERROR 1146 when temp tables are used
#
source include/have_log_bin.inc;
source include/have_binlog_format_mixed_or_statement.inc;

connect (master,127.0.0.1,root,,test,$MASTER_MYPORT,);
connect (master1,127.0.0.1,root,,test,$MASTER_MYPORT,);
RESET MASTER;

create table foo (a int);

flush logs;

connection master;
create temporary table tmp1_foo like foo;
connection master1;
create temporary table tmp2_foo (a int);

connection master;
insert into tmp1_foo values (1), (2), (3), (4);
connection master1;
replace into tmp2_foo values (1), (2), (3), (4);

connection master;
update tmp1_foo set a=2*a-1;
connection master1;
update tmp2_foo set a=2*a;

connection master;
delete from tmp1_foo where a < 5;
connection master1;
delete from tmp2_foo where a < 5;

connection master;
insert into foo select * from tmp1_foo;
connection master1;
insert into foo select * from tmp2_foo;

connection master;
truncate table tmp1_foo;
connection master1;
truncate table tmp2_foo;

flush logs;

connection default;
select * from foo;

# prepare for the replay
drop table foo;
create table foo (a int);

# replay from binary log
let $MYSQLD_DATADIR= `select @@datadir`;
exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000002 | $MYSQL;
select * from foo;

# clean up
drop table foo;

#################################################################
# BUG#51226
#################################################################

RESET MASTER;

-- let $dbname=b51226

connect (con1,localhost,root,,test,$MASTER_MYPORT,$MASTER_MYSOCK);
connect (con2,localhost,root,,test,$MASTER_MYPORT,$MASTER_MYSOCK);

#
# action: on con1 create the database and the tmp table
# 
-- connection con1
-- eval create database $dbname
-- eval use $dbname
create temporary table t1(i int);

#
# action: on con1 create the tmp table
# 
-- connection con2
-- eval use $dbname
create temporary table t1(i int);

# action: at this point, the last event binlogged contains the
#         pseudo_thread_id from con2. So now we switch to con1, issue
#         a statement that fails and close the connection (which logs
#         implicitely a DROP TEMPORARY TABLE).  
#
#         Before the patch this would not log con1's pseudo_thread_id
#         because the failing statement would reset THD context
#         (unsetting the thread_specific_used flag, and consequently,
#         causing the DROP event to be logged without pseudo_thread_id
#         in its header).

-- connection con1
-- error 1050
create temporary table t1(i int);
-- disconnect con1

-- connection default
-- let $wait_binlog_event= DROP
-- source include/wait_for_binlog_event.inc

# action: insert in the t1. This would cause the the test to fail,
#         because when replaying the binlog the previous implicit drop
#         temp table would have been executed under the wrong
#         pseudo_thread_id, dropping the tmp table on con2.
-- connection con2
insert into t1 values(1);
-- disconnect con2

-- connection default
-- let $wait_binlog_event= DROP
-- source include/wait_for_binlog_event.inc

-- eval DROP DATABASE $dbname
FLUSH LOGS;

# assertion: assert that when replaying the binary log will succeed,
#            instead of failing with "Table 'XXX.YYY' doesn't exist"
-- let $MYSQLD_DATADIR= `select @@datadir`
-- exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 | $MYSQL

${this.title}

Code Editor : binlog_tmp_table.test