Debian Codegraph @

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

raw
1 CREATE TABLE t1 (c1 INT);
2 ALTER TABLE t1 ADD COLUMN c2 INT, ALGORITHM=INSTANT;
3 INSERT INTO t1 VALUES (1,1);
4 SELECT * FROM t1;
5 c1 c2
6 1 1
7 DROP TABLE t1;
8 # Redundant:
9 CREATE TABLE t1_redundant (c1 INT) ROW_FORMAT=REDUNDANT, ENGINE=INNODB;
10 ALTER TABLE t1_redundant ADD COLUMN c2 INT, ALGORITHM=INSTANT;
11 INSERT INTO t1_redundant VALUES (1,1);
12 SHOW CREATE TABLE t1_redundant;
13 Table Create Table
14 t1_redundant CREATE TABLE `t1_redundant` (
15 `c1` int DEFAULT NULL,
16 `c2` int DEFAULT NULL
17 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
18 SELECT * FROM t1_redundant;
19 c1 c2
20 1 1
21 CHECK TABLE t1_redundant;
22 Table Op Msg_type Msg_text
23 test.t1_redundant check status OK
24 DROP TABLE t1_redundant;
25 # Compact:
26 CREATE TABLE t1_compact (c1 INT) ROW_FORMAT=COMPACT, ENGINE=INNODB;
27 ALTER TABLE t1_compact ADD COLUMN c2 INT, ALGORITHM=INSTANT;
28 INSERT INTO t1_compact VALUES (1,1);
29 SHOW CREATE TABLE t1_compact;
30 Table Create Table
31 t1_compact CREATE TABLE `t1_compact` (
32 `c1` int DEFAULT NULL,
33 `c2` int DEFAULT NULL
34 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
35 SELECT * FROM t1_compact;
36 c1 c2
37 1 1
38 CHECK TABLE t1_compact;
39 Table Op Msg_type Msg_text
40 test.t1_compact check status OK
41 DROP TABLE t1_compact;
42 # Dynamic:
43 CREATE TABLE t1_dynamic (c1 INT) ROW_FORMAT=DYNAMIC, ENGINe=INNODB;
44 ALTER TABLE t1_dynamic ADD COLUMN c2 INT, ALGORITHM=INSTANT;
45 INSERT INTO t1_dynamic VALUES (1,1);
46 SHOW CREATE TABLE t1_dynamic;
47 Table Create Table
48 t1_dynamic CREATE TABLE `t1_dynamic` (
49 `c1` int DEFAULT NULL,
50 `c2` int DEFAULT NULL
51 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
52 SELECT * FROM t1_dynamic;
53 c1 c2
54 1 1
55 CHECK TABLE t1_dynamic;
56 Table Op Msg_type Msg_text
57 test.t1_dynamic check status OK
58 DROP TABLE t1_dynamic;