diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_insert_id_pk.result')
| -rw-r--r-- | mysql-test/suite/rpl/r/rpl_insert_id_pk.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_insert_id_pk.result b/mysql-test/suite/rpl/r/rpl_insert_id_pk.result index 467b8c1e5cc..50abd9799d6 100644 --- a/mysql-test/suite/rpl/r/rpl_insert_id_pk.result +++ b/mysql-test/suite/rpl/r/rpl_insert_id_pk.result @@ -6,6 +6,7 @@ create table t2(b int auto_increment, c int, primary key(b)); insert into t1 values (1),(2),(3); insert into t1 values (null); insert into t2 values (null,last_insert_id()); +connection slave; select * from t1 ORDER BY a; a 1 @@ -15,6 +16,7 @@ a select * from t2 ORDER BY b; b c 1 4 +connection master; drop table t1; drop table t2; create table t1(a int auto_increment, key(a)) engine=innodb; @@ -25,6 +27,7 @@ insert into t1 values (null),(null),(null); insert into t2 values (5,0); insert into t2 values (null,last_insert_id()); SET FOREIGN_KEY_CHECKS=1; +connection slave; select * from t1; a 10 @@ -35,6 +38,7 @@ select * from t2; b c 5 0 6 11 +connection master; drop table t2; drop table t1; create table t1(a int auto_increment, primary key(a)); @@ -50,6 +54,7 @@ b c 7 11 8 12 9 13 +connection slave; select * from t1 ORDER BY a; a 10 @@ -63,12 +68,17 @@ b c 7 11 8 12 9 13 +connection master; drop table t1; drop table t2; +connection slave; +connection master; SET TIMESTAMP=1000000000; CREATE TABLE t1 ( a INT UNIQUE ); SET FOREIGN_KEY_CHECKS=0; INSERT INTO t1 VALUES (1),(1); Got one of the listed errors +connection slave; +connection master; drop table t1; include/rpl_end.inc |