diff options
| author | unknown <monty@mashka.mysql.fi> | 2003-01-20 18:48:10 +0200 |
|---|---|---|
| committer | unknown <monty@mashka.mysql.fi> | 2003-01-20 18:48:10 +0200 |
| commit | fd86106365476d5c774cd4779164516a0e56744a (patch) | |
| tree | 0668cd9810fda8ef66c9ef0f5fede1a3894172f6 /mysql-test/t/explain.test | |
| parent | f993a29ef1069dc841e3f74d4227672cc2c90c55 (diff) | |
| parent | f6cbace93e27301bda14d833763b805bf64f0da2 (diff) | |
| download | mariadb-git-fd86106365476d5c774cd4779164516a0e56744a.tar.gz | |
Merge with 4.0 (Fix bug in LEFT JOIN and EXPLAIN on empty table)
mysql-test/r/explain.result:
Auto merged
mysql-test/t/explain.test:
Auto merged
mysql-test/t/join.test:
Auto merged
Diffstat (limited to 'mysql-test/t/explain.test')
| -rw-r--r-- | mysql-test/t/explain.test | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/mysql-test/t/explain.test b/mysql-test/t/explain.test index 3e33d58215e..1cf8c5e93e1 100644 --- a/mysql-test/t/explain.test +++ b/mysql-test/t/explain.test @@ -5,6 +5,7 @@ drop table if exists t1; --enable_warnings create table t1 (id int not null, str char(10), unique(str)); +explain select * from t1; insert into t1 values (1, null),(2, null),(3, "foo"),(4, "bar"); select * from t1 where str is null; select * from t1 where str="foo"; @@ -14,8 +15,10 @@ explain select * from t1 ignore key (str) where str="foo"; explain select * from t1 use key (str,str) where str="foo"; #The following should give errors -!$1072 explain select * from t1 use key (str,str,foo) where str="foo"; -!$1072 explain select * from t1 ignore key (str,str,foo) where str="foo"; +--error 1072 +explain select * from t1 use key (str,str,foo) where str="foo"; +--error 1072 +explain select * from t1 ignore key (str,str,foo) where str="foo"; drop table t1; explain select 1; |