summaryrefslogtreecommitdiff
path: root/mysql-test/t/rpl_temporary.test
diff options
context:
space:
mode:
authorunknown <aelkin/elkin@dsl-hkigw8-feb1fb00-100.dhcp.inet.fi>2006-07-09 00:29:33 +0300
committerunknown <aelkin/elkin@dsl-hkigw8-feb1fb00-100.dhcp.inet.fi>2006-07-09 00:29:33 +0300
commitc701e23b80bed124efe9ca1f2a806c19c9944e7e (patch)
tree718f0820a2fc38a1623ba4dbb61a3f9ab83a11f5 /mysql-test/t/rpl_temporary.test
parent56e472deddb9d6fa98bd49c5ed28c238d34f8e27 (diff)
downloadmariadb-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.test21
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