|
CREATE TEMPORARY TABLE ... LIKE is a convenient way to clone tables for testing, but table compression breaks it:
(10:51) vagrant@localhost:[test]> CREATE TABLE t(c INT) ROW_FORMAT=COMPRESSED;
|
Query OK, 0 rows affected (0.025 sec)
|
|
(10:51) vagrant@localhost:[test]> CREATE TEMPORARY TABLE tt LIKE t;
|
ERROR 4047 (HY000): CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
|
Error (Code 4047): CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
|
Warning (Code 1030): Got error 140 "Wrong create options" from storage engine InnoDB
|
It would be more sensible behavior to just ignore the origin table's ROW_FORMAT setting.
|