summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2020-06-16 19:37:27 +0200
committerSergei Golubchik <serg@mariadb.org>2020-07-04 01:44:46 +0200
commitf17f7a43ba7da44608618f9e612f9808d363da23 (patch)
treef71f6ec50ad909fde43b553abd9987cf6ecf8edd
parentd2b852b4ca326f2a47ba1f51cd27e04a9954aa0d (diff)
downloadmariadb-git-f17f7a43ba7da44608618f9e612f9808d363da23.tar.gz
test dropping of a MEMORY table
-rw-r--r--mysql-test/suite/heap/drop.result3
-rw-r--r--mysql-test/suite/heap/drop.test11
2 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/suite/heap/drop.result b/mysql-test/suite/heap/drop.result
new file mode 100644
index 00000000000..cbc784fd59b
--- /dev/null
+++ b/mysql-test/suite/heap/drop.result
@@ -0,0 +1,3 @@
+create table t1 (a int) engine=memory;
+drop table t1;
+drop table t2;
diff --git a/mysql-test/suite/heap/drop.test b/mysql-test/suite/heap/drop.test
new file mode 100644
index 00000000000..ef61d4400f1
--- /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;