Debian Codegraph @

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

raw
1 SET @saved_innodb_strict_mode=@@SESSION.innodb_strict_mode;
2 CREATE TABLE t1 (id INT PRIMARY KEY, c1 VARCHAR(4000), c2 VARCHAR(4000), c3 VARCHAR(500)) ROW_FORMAT=COMPACT;
3 ERROR 42000: Row size too large (> 1982). 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.
4 CREATE TABLE t1 (id INT PRIMARY KEY, c1 VARCHAR(4000), c2 VARCHAR(4000), c3 VARCHAR(500)) ROW_FORMAT=REDUNDANT;
5 ERROR 42000: Row size too large (> 1979). 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.
6 SET SESSION innodb_strict_mode=OFF;
7 CREATE TABLE t1 (id INT PRIMARY KEY, c1 VARCHAR(4000), c2 VARCHAR(4000), c3 VARCHAR(500)) ROW_FORMAT=COMPACT;
8 Warnings:
9 Warning 139 Row size too large (> 1982). 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.
10 INSERT INTO t1 VALUES(2, repeat('e', 4000), repeat('f', 4000), repeat('h', 500));
11 ERROR 42000: Row size too large (> 1982). 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.
12 DROP TABLE t1;
13 CREATE TABLE t1 (id INT PRIMARY KEY, c1 VARCHAR(4000), c2 VARCHAR(4000), c3 VARCHAR(500)) ROW_FORMAT=REDUNDANT;
14 Warnings:
15 Warning 139 Row size too large (> 1979). 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.
16 INSERT INTO t1 VALUES(2, repeat('e', 4000), repeat('f', 4000), repeat('h', 500));
17 ERROR 42000: Row size too large (> 1979). 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.
18 DROP TABLE t1;
19 SET SESSION innodb_strict_mode=@saved_innodb_strict_mode;
20 CREATE TABLE t1 (id INT PRIMARY KEY, c1 VARCHAR(4000), c2 VARCHAR(4000), c3 VARCHAR(500)) ROW_FORMAT=DYNAMIC;
21 INSERT INTO t1 VALUES(2, repeat('e', 4000), repeat('f', 4000), repeat('h', 500));
22 SELECT id, LEFT(c1 , 10), LEFT(c2, 10), LEFT(c3, 10) FROM t1;
23 id LEFT(c1 , 10) LEFT(c2, 10) LEFT(c3, 10)
24 2 eeeeeeeeee ffffffffff hhhhhhhhhh
25 DROP TABLE t1;