diff options
author | monty@hundin.mysql.fi <> | 2001-11-28 14:52:11 +0200 |
---|---|---|
committer | monty@hundin.mysql.fi <> | 2001-11-28 14:52:11 +0200 |
commit | 69f6802632a9f0027041b53b1fcff78c51503f33 (patch) | |
tree | b5ae91cc685e7d8ed845e9ecbcd94e7f8857ea7f /mysql-test | |
parent | 5fedd2dda72f59c1a00525862a093bdaf042d034 (diff) | |
parent | 41afc03a85b92ac9d3bfe81a633631f17832b461 (diff) | |
download | mariadb-git-69f6802632a9f0027041b53b1fcff78c51503f33.tar.gz |
merge
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/null_key.result | 2 | ||||
-rw-r--r-- | mysql-test/t/rpl000013.test | 2 | ||||
-rw-r--r-- | mysql-test/t/rpl000016.test | 5 |
3 files changed, 5 insertions, 4 deletions
diff --git a/mysql-test/r/null_key.result b/mysql-test/r/null_key.result index 9906c7c5b2c..a28830a696d 100644 --- a/mysql-test/r/null_key.result +++ b/mysql-test/r/null_key.result @@ -21,7 +21,7 @@ table type possible_keys key key_len ref rows Extra t1 range a,b a 9 NULL 3 where used; Using index explain select * from t1 where (a is null or a = 7) and b=7; table type possible_keys key key_len ref rows Extra -t1 range a,b a 9 NULL 2 where used; Using index +t1 ref a,b b 4 const 2 where used explain select * from t1 where (a is null and b>a) or a is null and b=7 limit 2; table type possible_keys key key_len ref rows Extra t1 ref a,b a 5 const 3 where used; Using index diff --git a/mysql-test/t/rpl000013.test b/mysql-test/t/rpl000013.test index af693a720d4..a190d5324ae 100644 --- a/mysql-test/t/rpl000013.test +++ b/mysql-test/t/rpl000013.test @@ -12,7 +12,7 @@ insert into t2 select * from t1; connection master1; create temporary table t1 (n int); insert into t1 values (4),(5); -insert into t2 select * from t1; +insert into t2 select * from t1 as t10; save_master_pos; disconnect master; connection slave; diff --git a/mysql-test/t/rpl000016.test b/mysql-test/t/rpl000016.test index 76ce580da1f..cab99125161 100644 --- a/mysql-test/t/rpl000016.test +++ b/mysql-test/t/rpl000016.test @@ -28,7 +28,7 @@ select * from t1; connection master; flush logs; drop table if exists t2; -create table t2(m int not null primary key); +create table t2(m int not null auto_increment primary key); insert into t2 values (34),(67),(123); save_master_pos; flush logs; @@ -44,7 +44,8 @@ insert into t2 values(1234); #same value on the master connection master; save_master_pos; -insert into t2 values(1234); +set insert_id=1234; +insert into t2 values(NULL); connection slave; sync_with_master; |