diff options
| author | unknown <evgen@moonbone.local> | 2006-07-13 18:16:16 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2006-07-13 18:16:16 +0400 |
| commit | 805c33a5e161864c5eee91f02335eb59000c77b2 (patch) | |
| tree | 7f6569df935d07558c6602029f0648e288a95f84 /mysql-test/t/rpl_insert_id.test | |
| parent | a7dddd3b67e70292c0813e80ad255f1dc2f3a867 (diff) | |
| parent | f783a15aada23772e9aae11f9732dd6e9ed095de (diff) | |
| download | mariadb-git-805c33a5e161864c5eee91f02335eb59000c77b2.tar.gz | |
Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0
into moonbone.local:/work/tmp_merge-5.0-opt-mysql
mysql-test/r/rpl_insert_id.result:
Auto merged
mysql-test/t/rpl_insert_id.test:
Auto merged
sql/item_strfunc.cc:
Auto merged
sql/item_strfunc.h:
Auto merged
sql/sql_class.cc:
Auto merged
sql/sql_class.h:
Auto merged
sql/sql_insert.cc:
Auto merged
sql/sql_select.cc:
Auto merged
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 90a123cf5dc..fa66306aaa6 100644 --- a/mysql-test/t/rpl_insert_id.test +++ b/mysql-test/t/rpl_insert_id.test @@ -77,6 +77,24 @@ sync_slave_with_master; connection master; drop table t1; sync_slave_with_master; + +# +# Bug#14553: NULL in WHERE resets LAST_INSERT_ID +# +connection master; +create table t1(a int auto_increment, key(a)); +create table t2(a int); +insert into t1 (a) values (null); +insert into t2 (a) select a from t1 where a is null; +insert into t2 (a) select a from t1 where a is null; +select * from t2; +sync_slave_with_master; +connection slave; +select * from t2; +connection master; +drop table t1; +drop table t2; +sync_slave_with_master; # End of 4.1 tests |