diff options
Diffstat (limited to 'mysql-test/t')
-rw-r--r-- | mysql-test/t/rpl000009.test | 2 | ||||
-rw-r--r-- | mysql-test/t/rpl_insert_id.test | 6 | ||||
-rw-r--r-- | mysql-test/t/subselect.test | 3 |
3 files changed, 6 insertions, 5 deletions
diff --git a/mysql-test/t/rpl000009.test b/mysql-test/t/rpl000009.test index 1fbdd65e1fb..e349d891415 100644 --- a/mysql-test/t/rpl000009.test +++ b/mysql-test/t/rpl000009.test @@ -12,7 +12,7 @@ create database mysqltest; save_master_pos; connection slave; sync_with_master; -create database mysqltest; +create database mysqltest2; create table mysqltest2.foo (n int); insert into mysqltest2.foo values(4); connection master; diff --git a/mysql-test/t/rpl_insert_id.test b/mysql-test/t/rpl_insert_id.test index 3f3636d3082..93062f39c20 100644 --- a/mysql-test/t/rpl_insert_id.test +++ b/mysql-test/t/rpl_insert_id.test @@ -1,9 +1,7 @@ -#see if queries that use both -#auto_increment and LAST_INSERT_ID() -#are replicated well +# See if queries that use both auto_increment and LAST_INSERT_ID() +# are replicated well source include/master-slave.inc; connection master; -drop table if exists t1; 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); diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 03575858c3e..bb872df3e5c 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -91,7 +91,10 @@ select * from t3 where a in (select b from t2); select * from t3 where a not in (select b from t2); select * from t3 where a = some (select b from t2); select * from t3 where a <> any (select b from t2); + +# Rewrite: select * from t3 where not exists (select b from t2 where a <> b); select * from t3 where a = all (select b from t2); + select * from t3 where a <> all (select b from t2); insert into t2 values (100, 5); select * from t3 where a < any (select b from t2); |