diff options
author | unknown <mats@mats-laptop.(none)> | 2008-05-16 16:08:24 +0200 |
---|---|---|
committer | unknown <mats@mats-laptop.(none)> | 2008-05-16 16:08:24 +0200 |
commit | 65677ea535e20d6d0e86c3405506c68f57dedc64 (patch) | |
tree | 2e54a1abee9b353ee9033d90cd9315971af4c13b /mysql-test/extra | |
parent | 3d0ca97cadc84600d20c739ef61eb4e6f3d16826 (diff) | |
download | mariadb-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.test | 15 |
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; |