diff options
author | Sergei Golubchik <serg@mariadb.org> | 2020-06-16 19:37:27 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2020-07-04 01:44:46 +0200 |
commit | f17f7a43ba7da44608618f9e612f9808d363da23 (patch) | |
tree | f71f6ec50ad909fde43b553abd9987cf6ecf8edd | |
parent | d2b852b4ca326f2a47ba1f51cd27e04a9954aa0d (diff) | |
download | mariadb-git-f17f7a43ba7da44608618f9e612f9808d363da23.tar.gz |
test dropping of a MEMORY table
-rw-r--r-- | mysql-test/suite/heap/drop.result | 3 | ||||
-rw-r--r-- | mysql-test/suite/heap/drop.test | 11 |
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; |