diff options
| author | unknown <lars/lthalmann@mysql.com/dl145h.mysql.com> | 2006-09-21 13:19:52 +0200 |
|---|---|---|
| committer | unknown <lars/lthalmann@mysql.com/dl145h.mysql.com> | 2006-09-21 13:19:52 +0200 |
| commit | 4d147f32850a27052692ad520ed792a2d22027d8 (patch) | |
| tree | 77b6e84514e30a2ec48560e959dea43c2f4ac8a1 /mysql-test/r/rpl_insert_id.result | |
| parent | 9e9632fd9b8011333d6c2a0deb52a31ebfe2855f (diff) | |
| download | mariadb-git-4d147f32850a27052692ad520ed792a2d22027d8.tar.gz | |
Adding proper setup phase for test case rpl_insert_id
mysql-test/r/rpl_insert_id.result:
Updated result file
Diffstat (limited to 'mysql-test/r/rpl_insert_id.result')
| -rw-r--r-- | mysql-test/r/rpl_insert_id.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/rpl_insert_id.result b/mysql-test/r/rpl_insert_id.result index e683ea2fb39..fbdc9dc06cf 100644 --- a/mysql-test/r/rpl_insert_id.result +++ b/mysql-test/r/rpl_insert_id.result @@ -1,9 +1,20 @@ +# +# Setup +# stop slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; reset master; reset slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; start slave; +use test; +drop table if exists t1, t2, t3; +# +# See if queries that use both auto_increment and LAST_INSERT_ID() +# are replicated well +# +# We also check how the foreign_key_check variable is replicated +# 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); @@ -38,6 +49,9 @@ select * from t2; b c 5 0 6 11 +# +# check if INSERT SELECT in auto_increment is well replicated (bug #490) +# drop table t2; drop table t1; create table t1(a int auto_increment, key(a)); @@ -68,11 +82,18 @@ b c 9 13 drop table t1; drop table t2; +# +# Bug#8412: Error codes reported in binary log for CHARACTER SET, +# FOREIGN_KEY_CHECKS +# SET TIMESTAMP=1000000000; CREATE TABLE t1 ( a INT UNIQUE ); SET FOREIGN_KEY_CHECKS=0; INSERT INTO t1 VALUES (1),(1); ERROR 23000: Duplicate entry '1' for key 1 +# +# Bug#14553: NULL in WHERE resets LAST_INSERT_ID +# drop table t1; create table t1(a int auto_increment, key(a)); create table t2(a int); @@ -87,3 +108,6 @@ a 1 drop table t1; drop table t2; +# +# End of 4.1 tests +# |