From c0f40d14cc36f56f5b4dba288583acd345429e4e Mon Sep 17 00:00:00 2001
From: "monty@donna.mysql.com" <>
Date: Thu, 28 Dec 2000 03:56:38 +0200
Subject: Added support for hex strings to mysqlimport A lot of new tests to
 mysqltest Fixed bug with BDB tables and autocommit

---
 mysql-test/t/explain.test | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100644 mysql-test/t/explain.test

(limited to 'mysql-test/t/explain.test')

diff --git a/mysql-test/t/explain.test b/mysql-test/t/explain.test
new file mode 100644
index 00000000000..31a01ae1360
--- /dev/null
+++ b/mysql-test/t/explain.test
@@ -0,0 +1,19 @@
+#
+# Test of different EXPLAIN's
+
+drop table if exists t1;
+create table t1 (id int not null, str char(10), unique(str));
+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";
+explain select * from t1 where str is null;
+explain select * from t1 where str="foo";
+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";
+drop table t1;
+
+explain select 1;
-- 
cgit v1.2.1