1 files changed, 50 insertions, 0 deletions
diff --git a/mysql-test/suite/storage_engine/describe.test b/mysql-test/suite/storage_engine/describe.test
new file mode 100644
index 00000000..9f792469
--- /dev/null
+++ b/mysql-test/suite/storage_engine/describe.test
@@ -0,0 +1,50 @@
+# 
+# DESCRIBE statement
+#
+# Note: the output might well be different 
+#       (depending on default values for the engine).
+#       Examine mismatch carefully and, if columns are shown
+#       with correct options, add an rdiff.
+#       If you create combinations (with different startup options),
+#       you might have to add an rdiff for each of them.
+#
+
+--source have_engine.inc
+
+--disable_warnings
+DROP TABLE IF EXISTS t1, t2, t3;
+--enable_warnings
+
+--let $create_definition = a $int_col, b $char_col
+--let $table_options = CHARACTER SET utf8
+--source create_table.inc
+if ($mysql_errname)
+{
+  --let $functionality = CHARACTER SET
+  --source unexpected_result.inc
+}
+if (!$mysql_errname)
+{
+  INSERT INTO t1 (a,b) VALUES (100,'foo'),(2, 'b');
+
+  --let $create_definition = a $int_col, b $char_col
+  --let $table_options = CHARACTER SET utf8
+  --let $table_name = t2
+  --source create_table.inc
+
+  INSERT INTO t2 (a,b) VALUES (1, 'bar');
+
+  --let $create_definition = a $int_col, b $char_col
+  --let $table_name = t3
+  --let $table_options = CHARACTER SET utf8
+  --source create_table.inc
+
+  DESCRIBE t1;
+  DESC t2 a;
+  DESCRIBE t3 '%';
+
+  DROP TABLE t1, t2, t3;
+}
+
+--source cleanup_engine.inc
+