summaryrefslogtreecommitdiff
path: root/mysql-test/t/rpl_insert_id.test
diff options
context:
space:
mode:
authorunknown <monty@mashka.mysql.fi>2003-01-28 09:02:51 +0200
committerunknown <monty@mashka.mysql.fi>2003-01-28 09:02:51 +0200
commitc97ddd06f4c9eceac9b698f07eb5cc168b1006b6 (patch)
treebbd008d05f1c1111676b46f092fde8257666d9c2 /mysql-test/t/rpl_insert_id.test
parent3595556335b31d908555da9abaa669d3cfcce1e2 (diff)
parent88b405c4e21162b73077e000a9b8f7ffe9d6d251 (diff)
downloadmariadb-git-c97ddd06f4c9eceac9b698f07eb5cc168b1006b6.tar.gz
merge
include/my_sys.h: Auto merged sql/item_create.cc: Auto merged sql/log.cc: Auto merged sql/mysql_priv.h: Auto merged sql/set_var.cc: Auto merged sql/sql_parse.cc: Auto merged innobase/btr/btr0cur.c: Use local file scripts/make_binary_distribution.sh: Add mysql_waitpid sql/mysqld.cc: Simple cleanup
Diffstat (limited to 'mysql-test/t/rpl_insert_id.test')
-rw-r--r--mysql-test/t/rpl_insert_id.test39
1 files changed, 39 insertions, 0 deletions
diff --git a/mysql-test/t/rpl_insert_id.test b/mysql-test/t/rpl_insert_id.test
new file mode 100644
index 00000000000..3f3636d3082
--- /dev/null
+++ b/mysql-test/t/rpl_insert_id.test
@@ -0,0 +1,39 @@
+#see if queries that use both
+#auto_increment and LAST_INSERT_ID()
+#are replicated well
+source include/master-slave.inc;
+connection master;
+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());
+save_master_pos;
+connection slave;
+sync_with_master;
+select * from t1;
+select * from t2;
+connection master;
+#check if multi-line inserts,
+#which set last_insert_id to the first id inserted,
+#are replicated the same way
+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());
+save_master_pos;
+connection slave;
+sync_with_master;
+select * from t1;
+select * from t2;
+connection master;
+drop table t1;
+drop table t2;
+save_master_pos;
+connection slave;
+sync_with_master;