summaryrefslogtreecommitdiff
path: root/mysql-test/t/explain.test
diff options
context:
space:
mode:
authormonty@mashka.mysql.fi <>2003-02-07 17:57:07 +0200
committermonty@mashka.mysql.fi <>2003-02-07 17:57:07 +0200
commit1b9b042654512c7013fceb135795fc4453011033 (patch)
tree47bb4c4c761190424e909ac9f98674ad71c80b6d /mysql-test/t/explain.test
parentf68914addb4a59927cbc47c8d3a2431b5b180770 (diff)
downloadmariadb-git-1b9b042654512c7013fceb135795fc4453011033.tar.gz
Fix problem in MIN/MAX optimisation (from last patch)
Don't make OLD_PASSWORD() a reserved word
Diffstat (limited to 'mysql-test/t/explain.test')
-rw-r--r--mysql-test/t/explain.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/explain.test b/mysql-test/t/explain.test
index 8a41ebe5b4f..045598e97df 100644
--- a/mysql-test/t/explain.test
+++ b/mysql-test/t/explain.test
@@ -20,3 +20,11 @@ explain select * from t1 ignore key (str,str,foo) where str="foo";
drop table t1;
explain select 1;
+
+create table t1 (a int not null);
+explain select count(*) from t1;
+insert into t1 values(1);
+explain select count(*) from t1;
+insert into t1 values(1);
+explain select count(*) from t1;
+drop table t1;