|
Note: Most likely it's just a limitation of the debug injection, but it's worth checking, just in case.
--source include/have_partition.inc
|
|
CREATE TABLE t1 (i INT) PARTITION BY HASH (i) PARTITIONS 3;
|
SET debug_dbug= "+d,test_pseudo_invisible";
|
ALTER TABLE t1 COALESCE PARTITION 1;
|
SET debug_dbug= "";
|
SELECT * FROM t1;
|
|
# Cleanup
|
DROP TABLE t1;
|
|
With InnoDB
|
MariaDB [test]> SELECT * FROM t1;
|
ERROR 1932 (42S02): Table 'test.t1' doesn't exist in engine
|
|
With MyISAM
|
MariaDB [test]> SELECT * FROM t1;
|
ERROR 1030 (HY000): Got error 190 "Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine. You have to dump an" from storage engine MyISAM
|
|