diff options
author | unknown <monty@mashka.mysql.fi> | 2003-01-28 09:17:10 +0200 |
---|---|---|
committer | unknown <monty@mashka.mysql.fi> | 2003-01-28 09:17:10 +0200 |
commit | 2d9a417d56f03f1af44649a0c3f5d757f717fffc (patch) | |
tree | 2416deee30b449b4d09de78184e301e23e95e786 /mysql-test | |
parent | c97ddd06f4c9eceac9b698f07eb5cc168b1006b6 (diff) | |
download | mariadb-git-2d9a417d56f03f1af44649a0c3f5d757f717fffc.tar.gz |
Updated results for 4.0
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/rpl_insert_id.result | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/r/rpl_insert_id.result b/mysql-test/r/rpl_insert_id.result index 0298cca5da5..d524818985e 100644 --- a/mysql-test/r/rpl_insert_id.result +++ b/mysql-test/r/rpl_insert_id.result @@ -1,15 +1,41 @@ +slave stop; +drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; +reset master; +reset slave; +drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; +slave start; +drop table if exists t1; +create table t1(a int auto_increment, key(a)); +create table t2(b int auto_increment, c int, key(b)); +insert into t1 values (1),(2),(3); +insert into t1 values (null); +insert into t2 values (null,last_insert_id()); +select * from t1; a 1 2 3 4 +select * from t2; b c 1 4 +drop table t1; +drop table t2; +create table t1(a int auto_increment, key(a)); +create table t2(b int auto_increment, c int, key(b)); +insert into t1 values (10); +insert into t1 values (null),(null),(null); +insert into t2 values (5,0); +insert into t2 values (null,last_insert_id()); +select * from t1; a 10 11 12 13 +select * from t2; b c 5 0 6 11 +drop table t1; +drop table t2; |