diff options
author | unknown <aelkin/elkin@dsl-hkigw8-feb1fb00-100.dhcp.inet.fi> | 2006-07-09 00:29:33 +0300 |
---|---|---|
committer | unknown <aelkin/elkin@dsl-hkigw8-feb1fb00-100.dhcp.inet.fi> | 2006-07-09 00:29:33 +0300 |
commit | c701e23b80bed124efe9ca1f2a806c19c9944e7e (patch) | |
tree | 718f0820a2fc38a1623ba4dbb61a3f9ab83a11f5 /mysql-test/t/rpl_temporary.test | |
parent | 56e472deddb9d6fa98bd49c5ed28c238d34f8e27 (diff) | |
download | mariadb-git-c701e23b80bed124efe9ca1f2a806c19c9944e7e.tar.gz |
BUG#19188 incorrect temporary table name of DROP query in replication
manual merge of 5.0 patch and fixing an issue with closing temp tables when no binlog or RBR.
Note, that despite temporary_tables is indeed double-linked list in 5.1 (patch for bug #19881) it is still enough to use only 'next' reference, as it was done for 5.0, when the list is sorted and
destoyed after.
mysql-test/r/rpl_temporary.result:
results changed
mysql-test/t/rpl_temporary.test:
fixing kill stmt for a thread with temp tables. Restoring check of temp table with accent char.
sql/sql_base.cc:
manual merge part 2. Leaving only extensively refactored close_temporary_tables from local rep.
Diffstat (limited to 'mysql-test/t/rpl_temporary.test')
-rw-r--r-- | mysql-test/t/rpl_temporary.test | 21 |
1 files changed, 15 insertions, 6 deletions
diff --git a/mysql-test/t/rpl_temporary.test b/mysql-test/t/rpl_temporary.test index 800491d13e3..fc336db1a3a 100644 --- a/mysql-test/t/rpl_temporary.test +++ b/mysql-test/t/rpl_temporary.test @@ -142,11 +142,8 @@ create temporary table t4 (f int); create table t5 (f int); sync_with_master; # find dumper's $id -source include/get_binlog_dump_thread_id.inc; -insert into t4 values (1); -# a hint how to do that in 5.1 ---replace_result $id "`select id from information_schema.processlist where command='Binlog Dump'`" -eval kill $id; # to stimulate reconnection by slave w/o timeout +select id from information_schema.processlist where command='Binlog Dump' into @id; +kill @id; # to stimulate reconnection by slave w/o timeout insert into t5 select * from t4; save_master_pos; @@ -190,5 +187,17 @@ select * from t1 /* must be 1 */; connection master; drop table t1; ---echo End of 5.1 tests +# +#14157: utf8 encoding in binlog without set character_set_client +# +--exec $MYSQL --character-sets-dir=../sql/share/charsets/ --default-character-set=latin1 test -e 'create table t1 (a int); set names latin1; create temporary table `äöüÄÖÜ` (a int); insert into `äöüÄÖÜ` values (1); insert into t1 select * from `äöüÄÖÜ`' + +sync_slave_with_master; +#connection slave; +select * from t1; + +connection master; +drop table t1; + +# End of 5.1 tests |