Debian Codegraph @

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

raw
1 --source include/have_valgrind.inc
2
3 CREATE TABLE t1 (c1 INT);
4 ALTER TABLE t1 ADD COLUMN c2 INT, ALGORITHM=INSTANT;
5 INSERT INTO t1 VALUES (1,1);
6
7 SELECT * FROM t1;
8 DROP TABLE t1;
9
10 --echo # Redundant:
11 CREATE TABLE t1_redundant (c1 INT) ROW_FORMAT=REDUNDANT, ENGINE=INNODB;
12 ALTER TABLE t1_redundant ADD COLUMN c2 INT, ALGORITHM=INSTANT;
13 INSERT INTO t1_redundant VALUES (1,1);
14
15 SHOW CREATE TABLE t1_redundant;
16 SELECT * FROM t1_redundant;
17 CHECK TABLE t1_redundant;
18 DROP TABLE t1_redundant;
19
20 --echo # Compact:
21 CREATE TABLE t1_compact (c1 INT) ROW_FORMAT=COMPACT, ENGINE=INNODB;
22 ALTER TABLE t1_compact ADD COLUMN c2 INT, ALGORITHM=INSTANT;
23 INSERT INTO t1_compact VALUES (1,1);
24
25 SHOW CREATE TABLE t1_compact;
26 SELECT * FROM t1_compact;
27 CHECK TABLE t1_compact;
28 DROP TABLE t1_compact;
29
30 --echo # Dynamic:
31 CREATE TABLE t1_dynamic (c1 INT) ROW_FORMAT=DYNAMIC, ENGINe=INNODB;
32 ALTER TABLE t1_dynamic ADD COLUMN c2 INT, ALGORITHM=INSTANT;
33 INSERT INTO t1_dynamic VALUES (1,1);
34
35 SHOW CREATE TABLE t1_dynamic;
36 SELECT * FROM t1_dynamic;
37 CHECK TABLE t1_dynamic;
38 DROP TABLE t1_dynamic;