diff options
| author | unknown <lars/lthalmann@mysql.com/dl145j.mysql.com> | 2006-09-21 13:28:16 +0200 |
|---|---|---|
| committer | unknown <lars/lthalmann@mysql.com/dl145j.mysql.com> | 2006-09-21 13:28:16 +0200 |
| commit | b412be03c15d9780ba4b24b052f09733ea0f783e (patch) | |
| tree | 899ffe786df72ce7fbd9f574997154cf414689a3 /mysql-test/r/rpl_insert_id.result | |
| parent | 46235a29868e833f34dc4c0c69ee8682cb7d2ee8 (diff) | |
| parent | 41434a4d278bfeae87b3f6444811d384beb477bd (diff) | |
| download | mariadb-git-b412be03c15d9780ba4b24b052f09733ea0f783e.tar.gz | |
Merge mysql.com:/users/lthalmann/bk/MERGE/mysql-4.1-merge
into mysql.com:/users/lthalmann/bk/MERGE/mysql-5.0-merge
mysql-test/r/rpl_insert_id.result:
Merge 4.1-5.0
mysql-test/r/rpl_max_relay_size.result:
Merge 4.1-5.0
mysql-test/t/rpl_insert_id.test:
Merge 4.1-5.0
mysql-test/t/rpl_max_relay_size.test:
Merge 4.1-5.0
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 3aa82bf1d63..9c25157368e 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,6 +108,9 @@ a 1 drop table t1; drop table t2; +# +# End of 4.1 tests +# drop function if exists bug15728; drop function if exists bug15728_insert; drop table if exists t1, t2; |