Debian Codegraph @

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

raw
1 --source include/have_innodb_16k.inc
2
3 call mtr.add_suppression("Cannot create the table `test1`.`t1` because the record size will exceed the maximum allowed size for a record.");
4 call mtr.add_suppression("Cannot alter the table `test1`.`t1` because the record size will exceed the maximum allowed size for a record on the index 'PRIMARY'.");
5 call mtr.add_suppression("Trying to add or drop column\\(s\\) in table 'test1/t1'.*ADD or DROP column with ALGORITHM = INSTANT is not allowed.");
6
7 --let $orig_innodb_strict_mode = `SELECT @@session.innodb_strict_mode;`
8 CREATE DATABASE test1;
9 USE test1;
10
11 SET SESSION innodb_strict_mode=on;
12 --error ER_TOO_BIG_ROWSIZE
13 CREATE TABLE `t1` (
14 `c1` varchar(255),
15 `c2` varchar(255),
16 `c3` varchar(255),
17 `c4` varchar(255),
18 `c5` varchar(255),
19 `c6` varchar(255),
20 `c7` varchar(255),
21 `c8` varchar(255),
22 `c9` varchar(255),
23 `c10` varchar(255),
24 `c11` varchar(255),
25 primary key (`c1`(40))
26 ) ROW_FORMAT=COMPACT;
27
28 SET SESSION innodb_strict_mode=off;
29 CREATE TABLE `t1` (
30 `c1` varchar(255),
31 `c2` varchar(255),
32 `c3` varchar(255),
33 `c4` varchar(255),
34 `c5` varchar(255),
35 `c6` varchar(255),
36 `c7` varchar(255),
37 `c8` varchar(255),
38 `c9` varchar(255),
39 `c10` varchar(255),
40 `c11` varchar(255),
41 primary key (`c1`(40))
42 ) ROW_FORMAT=COMPACT;
43
44 INSERT INTO test1.t1 SET c1="foobar";
45
46 SET SESSION innodb_strict_mode=on;
47 --error ER_TOO_BIG_ROWSIZE
48 ALTER TABLE test1.t1 ADD COLUMN c12 varchar(255), ADD COLUMN c13 varchar(255);
49
50 SET SESSION innodb_strict_mode=off;
51 ALTER TABLE test1.t1 ADD COLUMN c12 varchar(255), ADD COLUMN c13 varchar(255);
52
53 SET SESSION innodb_strict_mode=on;
54 --error ER_TOO_BIG_ROWSIZE
55 ALTER TABLE test1.t1 DROP COLUMN c12;
56
57 SET SESSION innodb_strict_mode=off;
58 ALTER TABLE test1.t1 DROP COLUMN c13;
59
60 --error ER_INNODB_INSTANT_ADD_DROP_NOT_SUPPORTED_MAX_SIZE
61 ALTER TABLE test1.t1 ADD COLUMN c13 varchar(255), algorithm=instant;
62
63 --error ER_INNODB_INSTANT_ADD_DROP_NOT_SUPPORTED_MAX_SIZE
64 ALTER TABLE test1.t1 DROP COLUMN c12, algorithm=instant;
65
66 --source include/restart_mysqld.inc
67
68 --let $COUNT_BEFORE = `SELECT COUNT(*) from performance_schema.error_log;`
69
70 # This should not emit warning/error message in the error log.
71 SELECT * FROM test1.t1;
72
73 --let $COUNT_AFTER = `SELECT COUNT(*) from performance_schema.error_log;`
74
75 --let $assert_text = count in the error_log table should be same
76 --let $assert_cond = $COUNT_BEFORE = $COUNT_AFTER
77 --source include/assert.inc
78
79 # Clean up
80 DROP DATABASE test1;
81 --eval SET SESSION innodb_strict_mode = $orig_innodb_strict_mode