summaryrefslogtreecommitdiff
path: root/mysql-test/r/explain.result
diff options
context:
space:
mode:
authorunknown <monty@mashka.mysql.fi>2003-01-20 18:48:10 +0200
committerunknown <monty@mashka.mysql.fi>2003-01-20 18:48:10 +0200
commita6aac0a215af63b7bb3d03a764589a72875680dc (patch)
tree0668cd9810fda8ef66c9ef0f5fede1a3894172f6 /mysql-test/r/explain.result
parenta74659ddb2ba2b2c1fe265c075eb73912e42d63c (diff)
parentcd5cca0dc6cfddc669b7f87a91c2ff5f34839b23 (diff)
downloadmariadb-git-a6aac0a215af63b7bb3d03a764589a72875680dc.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/r/explain.result')
-rw-r--r--mysql-test/r/explain.result3
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/explain.result b/mysql-test/r/explain.result
index 2892c2ea587..e85aca4c6f3 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