summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/heap/drop.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/heap/drop.test')
-rw-r--r--mysql-test/suite/heap/drop.test11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/suite/heap/drop.test b/mysql-test/suite/heap/drop.test
new file mode 100644
index 00000000..ef61d440
--- /dev/null
+++ b/mysql-test/suite/heap/drop.test
@@ -0,0 +1,11 @@
+create table t1 (a int) engine=memory;
+let $DATADIR= `select @@datadir`;
+copy_file $DATADIR/test/t1.frm $DATADIR/test/t2.frm;
+#
+# drop a newly created MEMORY table
+#
+drop table t1;
+#
+# drop a MEMORY table after a server restart (frm only, nothing in memory)
+#
+drop table t2;