summaryrefslogtreecommitdiff
path: root/mysql-test/t/partition_not_blackhole.test
diff options
context:
space:
mode:
authorMattias Jonsson <mattias.jonsson@oracle.com>2010-07-08 14:36:55 +0200
committerMattias Jonsson <mattias.jonsson@oracle.com>2010-07-08 14:36:55 +0200
commitb7ad17d06a31e0ca8b8ef771e8ba3fcd8b534b32 (patch)
tree776983e36518bb0b994f161df04080bf8afed7c3 /mysql-test/t/partition_not_blackhole.test
parentd9e7c4efb6bfebf625af629b3ca878f1d0dc7e02 (diff)
downloadmariadb-git-b7ad17d06a31e0ca8b8ef771e8ba3fcd8b534b32.tar.gz
Bug#46086: crash when dropping a partitioned table
and the original engine is disabled Missing check that engine is available. mysql-test/include/not_blackhole.inc: new include file mysql-test/r/partition_not_blackhole.result: new result file mysql-test/std_data/parts/t1_blackhole.frm: blackhole partitioned table .frm file: create table `t1` (`id` int primary key) engine=blackhole partition by key () partitions 1; mysql-test/std_data/parts/t1_blackhole.par: .par file matching blackhole partitioned .frm mysql-test/t/partition_not_blackhole-master.opt: new master-opt to disable blackhole if compiled in. mysql-test/t/partition_not_blackhole.test: New test sql/ha_partition.cc: Added check that engine is available.
Diffstat (limited to 'mysql-test/t/partition_not_blackhole.test')
-rw-r--r--mysql-test/t/partition_not_blackhole.test25
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/t/partition_not_blackhole.test b/mysql-test/t/partition_not_blackhole.test
new file mode 100644
index 00000000000..222c1bb091e
--- /dev/null
+++ b/mysql-test/t/partition_not_blackhole.test
@@ -0,0 +1,25 @@
+--source include/have_partition.inc
+--source include/not_blackhole.inc
+
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+let $MYSQLD_DATADIR= `SELECT @@datadir`;
+
+--echo #
+--echo # Bug#46086: crash when dropping a partitioned table and
+--echo # the original engine is disabled
+--echo # Copy a .frm and .par file which was created with:
+--echo # create table `t1` (`id` int primary key) engine=blackhole
+--echo # partition by key () partitions 1;
+--copy_file std_data/parts/t1_blackhole.frm $MYSQLD_DATADIR/test/t1.frm
+--copy_file std_data/parts/t1_blackhole.par $MYSQLD_DATADIR/test/t1.par
+SHOW TABLES;
+--error ER_NOT_FORM_FILE
+SHOW CREATE TABLE t1;
+--error ER_BAD_TABLE_ERROR
+DROP TABLE t1;
+--list_files $MYSQLD_DATADIR/test t1*
+--remove_file $MYSQLD_DATADIR/test/t1.frm
+--remove_file $MYSQLD_DATADIR/test/t1.par