diff options
author | unknown <monty@mashka.mysql.fi> | 2003-01-28 09:02:51 +0200 |
---|---|---|
committer | unknown <monty@mashka.mysql.fi> | 2003-01-28 09:02:51 +0200 |
commit | c97ddd06f4c9eceac9b698f07eb5cc168b1006b6 (patch) | |
tree | bbd008d05f1c1111676b46f092fde8257666d9c2 /mysql-test/t/rpl_insert_id.test | |
parent | 3595556335b31d908555da9abaa669d3cfcce1e2 (diff) | |
parent | 88b405c4e21162b73077e000a9b8f7ffe9d6d251 (diff) | |
download | mariadb-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.test | 39 |
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; |