Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.3.37
-
None
-
None
-
Debian Buster
Description
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.
Attachments
Issue Links
- relates to
-
-
- Closed
-