Debian Codegraph @

mysql-test/suite/innodb/t/file_format_defaults.test

raw
1 #***********************************************************
2 # WL#7703:
3 # Check boundary value of max key length 3073
4 #***********************************************************
5 -- source include/have_innodb.inc
6 -- source include/have_innodb_16k.inc
7
8 call mtr.add_suppression("InnoDB: Cannot add field `c1` in table `test`\\.`tab0`");
9
10 --source include/test_db_charset_latin1.inc
11
12 # Check some default settings
13 SELECT @@innodb_strict_mode;
14
15 SELECT @@innodb_file_per_table;
16
17 SET SQL_MODE=strict_all_tables;
18
19 --disable_query_log
20 SET @save_innodb_read_only_compressed=@@GLOBAL.innodb_read_only_compressed;
21 SET GLOBAL innodb_read_only_compressed=OFF;
22 --enable_query_log
23
24 CREATE TABLE tab0 (c1 VARCHAR(65530), KEY(c1(3073))) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
25 SHOW CREATE TABLE tab0;
26 DROP TABLE tab0;
27
28 --error ER_TOO_BIG_ROWSIZE
29 CREATE TABLE tab0 (c1 VARCHAR(65530), KEY(c1(3073))) ENGINE=InnoDB KEY_BLOCK_SIZE=2;
30
31 CREATE TABLE tab0(c1 INT,c2 LONGBLOB ) ENGINE=InnoDB ROW_FORMAT=Dynamic;
32 DROP TABLE tab0;
33
34 SET GLOBAL innodb_strict_mode=OFF;
35
36 # Check with default value
37 SET GLOBAL innodb_strict_mode=Default;
38
39 SELECT @@innodb_strict_mode;
40
41 CREATE TABLE tab1(c1 int ) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
42 DROP TABLE tab1;
43
44 --disable_query_log
45 SET GLOBAL innodb_read_only_compressed=@save_innodb_read_only_compressed;
46 --enable_query_log
47
48 --source include/test_db_charset_restore.inc