summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <monty@mashka.mysql.fi>2003-01-28 09:17:10 +0200
committerunknown <monty@mashka.mysql.fi>2003-01-28 09:17:10 +0200
commit2d9a417d56f03f1af44649a0c3f5d757f717fffc (patch)
tree2416deee30b449b4d09de78184e301e23e95e786 /mysql-test
parentc97ddd06f4c9eceac9b698f07eb5cc168b1006b6 (diff)
downloadmariadb-git-2d9a417d56f03f1af44649a0c3f5d757f717fffc.tar.gz
Updated results for 4.0
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/rpl_insert_id.result26
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;