Debian Codegraph @

mysql-test/suite/innodb/r/create_like.result

raw
1 #
2 # MDEV-35144 CREATE TABLE ... LIKE uses current innodb_compression_default instead of the create value
3 #
4 set innodb_compression_default= off;
5 create table t1 (a int, b blob) engine=innodb;
6 set innodb_compression_default= on;
7 create table s_import like t1;
8 show create table t1;
9 Table Create Table
10 t1 CREATE TABLE `t1` (
11 `a` int(11) DEFAULT NULL,
12 `b` blob DEFAULT NULL
13 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
14 show create table s_import;
15 Table Create Table
16 s_import CREATE TABLE `s_import` (
17 `a` int(11) DEFAULT NULL,
18 `b` blob DEFAULT NULL
19 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
20 DROP TABLE t1,s_import;
21 # End of 10.5 tests