summaryrefslogtreecommitdiff
path: root/mysql-test/extra
diff options
context:
space:
mode:
authorunknown <mats@mats-laptop.(none)>2008-05-16 16:08:24 +0200
committerunknown <mats@mats-laptop.(none)>2008-05-16 16:08:24 +0200
commit65677ea535e20d6d0e86c3405506c68f57dedc64 (patch)
tree2e54a1abee9b353ee9033d90cd9315971af4c13b /mysql-test/extra
parent3d0ca97cadc84600d20c739ef61eb4e6f3d16826 (diff)
downloadmariadb-git-65677ea535e20d6d0e86c3405506c68f57dedc64.tar.gz
Fixes to make rpl_insert_id pass in 5.1-bugteam.
mysql-test/extra/rpl_tests/rpl_insert_id.test: Moving save and restore of @@global.concurrent_insert into the same session thread. mysql-test/suite/rpl/r/rpl_insert_id.result: Result file change. mysql-test/suite/rpl/t/rpl_insert_id.test: ***MISSING TEXT***
Diffstat (limited to 'mysql-test/extra')
-rw-r--r--mysql-test/extra/rpl_tests/rpl_insert_id.test15
1 files changed, 8 insertions, 7 deletions
diff --git a/mysql-test/extra/rpl_tests/rpl_insert_id.test b/mysql-test/extra/rpl_tests/rpl_insert_id.test
index 0cc0a343304..d8ea267d62b 100644
--- a/mysql-test/extra/rpl_tests/rpl_insert_id.test
+++ b/mysql-test/extra/rpl_tests/rpl_insert_id.test
@@ -18,13 +18,6 @@ use test;
drop table if exists t1, t2, t3;
--enable_warnings
-# If concurrent inserts are on, it is not guaranteed that the rows
-# inserted by INSERT are immediately accessible by SELECT in another
-# thread. This would cause problems near the line 'connection master1'
-# below. So we turn off concurrent inserts.
-SET @old_concurrent_insert= @@global.concurrent_insert;
-SET @@global.concurrent_insert= 0;
-
--echo #
--echo # See if queries that use both auto_increment and LAST_INSERT_ID()
--echo # are replicated well
@@ -35,6 +28,14 @@ SET @@global.concurrent_insert= 0;
-- source include/master-slave.inc
#should work for both SBR and RBR
+# If concurrent inserts are on, it is not guaranteed that the rows
+# inserted by INSERT are immediately accessible by SELECT in another
+# thread. This would cause problems near the line 'connection master1'
+# below. So we turn off concurrent inserts.
+connection master;
+SET @old_concurrent_insert= @@global.concurrent_insert;
+SET @@global.concurrent_insert= 0;
+
connection master;
eval create table t1(a int auto_increment, key(a)) engine=$engine_type;
eval create table t2(b int auto_increment, c int, key(b)) engine=$engine_type;