diff options
author | guilhem@mysql.com <> | 2003-05-27 14:50:14 +0200 |
---|---|---|
committer | guilhem@mysql.com <> | 2003-05-27 14:50:14 +0200 |
commit | 97f9aa2aaf6a269dadeecaf3e25a984c20188a5c (patch) | |
tree | d59f1682d9aab458b2227ff66c5221b72caca949 /mysql-test/t/rpl_insert_id.test | |
parent | 553637cbc48e0126997a44ab34463d8deabb1f1c (diff) | |
parent | 9ed9ad5374e230dc971cd25155f0baa42c4cdb94 (diff) | |
download | mariadb-git-97f9aa2aaf6a269dadeecaf3e25a984c20188a5c.tar.gz |
temporary update of the test to satisfy merge; will commit a final update
soon.
Diffstat (limited to 'mysql-test/t/rpl_insert_id.test')
-rw-r--r-- | mysql-test/t/rpl_insert_id.test | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/t/rpl_insert_id.test b/mysql-test/t/rpl_insert_id.test index a9e4de21e5c..26d5d3a9ed2 100644 --- a/mysql-test/t/rpl_insert_id.test +++ b/mysql-test/t/rpl_insert_id.test @@ -36,6 +36,24 @@ sync_with_master; select * from t1; select * from t2; connection master; + +# check if INSERT SELECT in auto_increment is well replicated (bug #490) + +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 (c) select * from t1; +select * from t2; +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; |