summaryrefslogtreecommitdiff
path: root/mysql-test/r/explain.result
diff options
context:
space:
mode:
authorunknown <monty@mashka.mysql.fi>2003-02-08 01:12:58 +0200
committerunknown <monty@mashka.mysql.fi>2003-02-08 01:12:58 +0200
commitcb38070e9f4e3dcaf3e2f9dc42577802ba035085 (patch)
treed54b65dfc052978dab95842c84f1a39745ef0d0c /mysql-test/r/explain.result
parent5dd528a2fda1412b8b75a6311dbc7262670983b6 (diff)
parent133ed0bf6ffde95d02ea35b6c02b5a042d73ecc0 (diff)
downloadmariadb-git-cb38070e9f4e3dcaf3e2f9dc42577802ba035085.tar.gz
merge
configure.in: Auto merged mysql-test/t/explain.test: Auto merged sql/ha_innodb.cc: Auto merged sql/item_create.cc: Auto merged sql/item_create.h: Auto merged sql/opt_range.cc: Auto merged sql/opt_sum.cc: Auto merged
Diffstat (limited to 'mysql-test/r/explain.result')
-rw-r--r--mysql-test/r/explain.result13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/explain.result b/mysql-test/r/explain.result
index ff38e9fae7d..9c9cac4762b 100644
--- a/mysql-test/r/explain.result
+++ b/mysql-test/r/explain.result
@@ -31,3 +31,16 @@ drop table t1;
explain select 1;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL No tables used
+create table t1 (a int not null);
+explain select count(*) from t1;
+Comment
+Select tables optimized away
+insert into t1 values(1);
+explain select count(*) from t1;
+Comment
+Select tables optimized away
+insert into t1 values(1);
+explain select count(*) from t1;
+Comment
+Select tables optimized away
+drop table t1;