Debian Codegraph @

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

raw
1 SET GLOBAL innodb_file_per_table=1;
2 SET SESSION innodb_strict_mode=ON;
3 CREATE TABLE t1 (id int, a TEXT) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
4 ERROR HY000: Table storage engine for 't1' doesn't have this option
5 SHOW WARNINGS;
6 Level Code Message
7 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k.
8 Error 1031 Table storage engine for 't1' doesn't have this option
9 CREATE TABLE t1 (id int, a TEXT) ROW_FORMAT=COMPRESSED;
10 ERROR HY000: Table storage engine for 't1' doesn't have this option
11 SHOW WARNINGS;
12 Level Code Message
13 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k.
14 Error 1031 Table storage engine for 't1' doesn't have this option
15 CREATE TABLE t1(id int, a TEXT) KEY_BLOCK_SIZE=4;
16 ERROR HY000: Table storage engine for 't1' doesn't have this option
17 SHOW WARNINGS;
18 Level Code Message
19 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k.
20 Error 1031 Table storage engine for 't1' doesn't have this option
21 CREATE TABLE t1 (id int, a TEXT);
22 SHOW WARNINGS;
23 Level Code Message
24 ALTER TABLE t1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
25 ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'KEY_BLOCK_SIZE'
26 SHOW WARNINGS;
27 Level Code Message
28 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k.
29 Error 1478 Table storage engine 'InnoDB' does not support the create option 'KEY_BLOCK_SIZE'
30 ALTER TABLE t1 ROW_FORMAT=COMPRESSED;
31 ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'ROW_TYPE'
32 SHOW WARNINGS;
33 Level Code Message
34 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k.
35 Error 1478 Table storage engine 'InnoDB' does not support the create option 'ROW_TYPE'
36 ALTER TABLE t1 KEY_BLOCK_SIZE=4;
37 ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'KEY_BLOCK_SIZE'
38 SHOW WARNINGS;
39 Level Code Message
40 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k.
41 Error 1478 Table storage engine 'InnoDB' does not support the create option 'KEY_BLOCK_SIZE'
42 DROP TABLE t1;
43 SET SESSION innodb_strict_mode=OFF;
44 CREATE TABLE t1 (id int, a TEXT) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
45 Warnings:
46 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC.
47 DROP TABLE t1;
48 CREATE TABLE t1 (id int, a TEXT) ROW_FORMAT=COMPRESSED;
49 Warnings:
50 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC.
51 DROP TABLE t1;
52 CREATE TABLE t1 (id int, a TEXT) KEY_BLOCK_SIZE=4;
53 Warnings:
54 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC.
55 DROP TABLE t1;
56 CREATE TABLE t1 (id int, a TEXT);
57 ALTER TABLE t1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
58 Warnings:
59 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC.
60 ALTER TABLE t1 ROW_FORMAT=COMPRESSED;
61 Warnings:
62 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC.
63 ALTER TABLE t1 KEY_BLOCK_SIZE=4;
64 Warnings:
65 Warning 1478 InnoDB: ignoring KEY_BLOCK_SIZE=4 as ROW_FORMAT is not COMPRESSED.
66 DROP TABLE t1;
67 SET GLOBAL innodb_file_per_table=default;
68 CREATE TABLE t1 (id int, a TEXT) ROW_FORMAT=COMPACT;
69 INSERT INTO t1 VALUES (1, REPEAT('a',2000)), (2, REPEAT('a',2000));
70 UPDATE t1 SET a=REPEAT('a',31000) WHERE id = 1;
71 INSERT INTO t1 VALUES (1, REPEAT('a',33000));
72 DROP TABLE t1;