diff options
author | unknown <guilhem@mysql.com> | 2003-05-27 14:50:14 +0200 |
---|---|---|
committer | unknown <guilhem@mysql.com> | 2003-05-27 14:50:14 +0200 |
commit | da338c599cadc2ec7206fcd53da14543962e9b05 (patch) | |
tree | d59f1682d9aab458b2227ff66c5221b72caca949 /mysql-test/r/rpl_insert_id.result | |
parent | 515ca2c4b41c077898660117d3faccc337f059da (diff) | |
parent | 2917fdb9d38c798cdc8e9341bec667ce4cb3c281 (diff) | |
download | mariadb-git-da338c599cadc2ec7206fcd53da14543962e9b05.tar.gz |
temporary update of the test to satisfy merge; will commit a final update
soon.
mysql-test/r/rpl_insert_id.result:
Auto merged
Diffstat (limited to 'mysql-test/r/rpl_insert_id.result')
-rw-r--r-- | mysql-test/r/rpl_insert_id.result | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/r/rpl_insert_id.result b/mysql-test/r/rpl_insert_id.result index 70f9ff0de0f..0065d83f169 100644 --- a/mysql-test/r/rpl_insert_id.result +++ b/mysql-test/r/rpl_insert_id.result @@ -41,3 +41,31 @@ b c 6 11 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; +b c +5 0 +6 10 +7 11 +8 12 +9 13 +select * from t1; +a +10 +11 +12 +13 +select * from t2; +b c +5 0 +6 10 +7 11 +8 12 +9 13 +drop table t1; +drop table t2; |