Debian Codegraph @

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

raw
1 call mtr.add_suppression("Cannot add field `.*` in table `test`.`t1` because after adding it, the row size is");
2 ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
3 CREATE TABLE t1 (
4 c1 CHAR(255), c2 CHAR(255), c3 CHAR(255), c4 CHAR(255),
5 c5 CHAR(255), c6 CHAR(255), c7 CHAR(255), c8 CHAR(255),
6 c9 CHAR(255), c10 CHAR(255), c11 CHAR(255), c12 CHAR(255),
7 c13 CHAR(255), c14 CHAR(255), c15 CHAR(255)
8 ) ENGINE=INNODB;
9 DROP TABLE t1;
10 CREATE TABLE t1 (
11 c1 CHAR(255), c2 CHAR(255), c3 CHAR(255), c4 CHAR(255),
12 c5 CHAR(255), c6 CHAR(255), c7 CHAR(255), c8 CHAR(255),
13 c9 CHAR(255), c10 CHAR(255), c11 CHAR(255), c12 CHAR(255),
14 c13 CHAR(255), c14 CHAR(255), c15 CHAR(255), c16 CHAR(255)
15 ) ENGINE=INNODB;
16 ERROR 42000: Row size too large (> 4027). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
17 CREATE TABLE t1 (
18 c1 VARCHAR(255), c2 VARCHAR(255), c3 VARCHAR(255), c4 VARCHAR(255),
19 c5 VARCHAR(255), c6 VARCHAR(255), c7 VARCHAR(255), c8 VARCHAR(255),
20 c9 VARCHAR(255), c10 VARCHAR(255), c11 VARCHAR(255), c12 VARCHAR(255),
21 c13 VARCHAR(255), c14 VARCHAR(255), c15 VARCHAR(255)
22 ) ENGINE=INNODB;
23 DROP TABLE t1;
24 CREATE TABLE t1 (
25 c1 VARCHAR(255), c2 VARCHAR(255), c3 VARCHAR(255), c4 VARCHAR(255),
26 c5 VARCHAR(255), c6 VARCHAR(255), c7 VARCHAR(255), c8 VARCHAR(255),
27 c9 VARCHAR(255), c10 VARCHAR(255), c11 VARCHAR(255), c12 VARCHAR(255),
28 c13 VARCHAR(255), c14 VARCHAR(255), c15 VARCHAR(255), c16 VARCHAR(255)
29 ) ENGINE=INNODB;
30 ERROR 42000: Row size too large (> 4027). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
31 CREATE TABLE t1 (
32 c1 VARCHAR(788), c2 VARCHAR(788), c3 VARCHAR(788), c4 VARCHAR(788),
33 c5 VARCHAR(788)
34 ) ENGINE=INNODB;
35 DROP TABLE t1;
36 CREATE TABLE t1 (
37 c1 VARCHAR(788), c2 VARCHAR(788), c3 VARCHAR(788), c4 VARCHAR(788),
38 c5 VARCHAR(788), c6 VARCHAR(788)
39 ) ENGINE=INNODB;
40 ERROR 42000: Row size too large (> 4027). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
41 CREATE TABLE t1 (
42 c1 TEXT, c2 TEXT, c3 TEXT, c4 TEXT, c5 TEXT
43 ) ENGINE=INNODB;
44 DROP TABLE t1;
45 CREATE TABLE t1 (
46 c1 TEXT, c2 TEXT, c3 TEXT, c4 TEXT, c5 TEXT, c6 TEXT
47 ) ENGINE=INNODB;
48 ERROR 42000: Row size too large (> 4027). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
49 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;