diff options
| author | unknown <monty@mashka.mysql.fi> | 2003-01-20 18:17:14 +0200 |
|---|---|---|
| committer | unknown <monty@mashka.mysql.fi> | 2003-01-20 18:17:14 +0200 |
| commit | f6cbace93e27301bda14d833763b805bf64f0da2 (patch) | |
| tree | ee83f54a5857c95a2c506f7ab404fb491e94d0bf /mysql-test | |
| parent | 09b1e7d6076748b198f54008495cf4e60e156b86 (diff) | |
| download | mariadb-git-f6cbace93e27301bda14d833763b805bf64f0da2.tar.gz | |
Fixed bug with EXPLAIN on empty table
mysql-test/r/explain.result:
test of bug with EXPLAIN on empty table
mysql-test/t/explain.test:
test of bug with EXPLAIN on empty table
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/explain.result | 3 | ||||
| -rw-r--r-- | mysql-test/t/explain.test | 7 |
2 files changed, 8 insertions, 2 deletions
diff --git a/mysql-test/r/explain.result b/mysql-test/r/explain.result index 876846a5236..fa15165722d 100644 --- a/mysql-test/r/explain.result +++ b/mysql-test/r/explain.result @@ -1,5 +1,8 @@ drop table if exists t1; create table t1 (id int not null, str char(10), unique(str)); +explain select * from t1; +table type possible_keys key key_len ref rows Extra +t1 system NULL NULL NULL NULL 0 const row not found insert into t1 values (1, null),(2, null),(3, "foo"),(4, "bar"); select * from t1 where str is null; id str diff --git a/mysql-test/t/explain.test b/mysql-test/t/explain.test index 31a01ae1360..8a41ebe5b4f 100644 --- a/mysql-test/t/explain.test +++ b/mysql-test/t/explain.test @@ -3,6 +3,7 @@ drop table if exists t1; 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"; @@ -12,8 +13,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; |