summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authormonty@hundin.mysql.fi <>2001-11-28 14:52:11 +0200
committermonty@hundin.mysql.fi <>2001-11-28 14:52:11 +0200
commit69f6802632a9f0027041b53b1fcff78c51503f33 (patch)
treeb5ae91cc685e7d8ed845e9ecbcd94e7f8857ea7f /mysql-test
parent5fedd2dda72f59c1a00525862a093bdaf042d034 (diff)
parent41afc03a85b92ac9d3bfe81a633631f17832b461 (diff)
downloadmariadb-git-69f6802632a9f0027041b53b1fcff78c51503f33.tar.gz
merge
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/null_key.result2
-rw-r--r--mysql-test/t/rpl000013.test2
-rw-r--r--mysql-test/t/rpl000016.test5
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;