Debian Codegraph @

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

raw
1 # restart: with restart_parameters
2 CREATE TABLE tr(a INT PRIMARY KEY)ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
3 CREATE TABLE tc(a INT PRIMARY KEY)ENGINE=InnoDB ROW_FORMAT=COMPACT;
4 CREATE TABLE td(a INT PRIMARY KEY)ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
5 SET innodb_strict_mode=OFF;
6 CREATE TABLE tz(a INT PRIMARY KEY)ENGINE=InnoDB ROW_FORMAT=COMPRESSED
7 KEY_BLOCK_SIZE=1;
8 SET innodb_strict_mode=ON;
9 CREATE TABLE tp(a INT PRIMARY KEY)ENGINE=InnoDB ROW_FORMAT=DYNAMIC
10 PAGE_COMPRESSED=1 PAGE_COMPRESSION_LEVEL=9;
11 SYS_TABLES clustered index root page (8):
12 N_RECS=8; LEVEL=0; INDEX_ID=0x0000000000000001
13 header=0x01000003008d (NAME=0x696e66696d756d00)
14 header=0x0000101500d5 (NAME='SYS_FOREIGN',
15 DB_TRX_ID=0xXXXXXXXXXXXX,
16 DB_ROLL_PTR=0xXXXXXXXXXXXXXX,
17 ID=0x000000000000000b,
18 N_COLS=0x00000004,
19 TYPE=0x00000001,
20 MIX_ID=0x0000000000000000,
21 MIX_LEN=0x00000040,
22 CLUSTER_NAME=NULL(0 bytes),
23 SPACE=0x00000000)
24 header=0x000018150122 (NAME='SYS_FOREIGN_COLS',
25 DB_TRX_ID=0xXXXXXXXXXXXX,
26 DB_ROLL_PTR=0xXXXXXXXXXXXXXX,
27 ID=0x000000000000000c,
28 N_COLS=0x00000004,
29 TYPE=0x00000001,
30 MIX_ID=0x0000000000000000,
31 MIX_LEN=0x00000040,
32 CLUSTER_NAME=NULL(0 bytes),
33 SPACE=0x00000000)
34 header=0x0000201501ae (NAME='SYS_VIRTUAL',
35 DB_TRX_ID=0xXXXXXXXXXXXX,
36 DB_ROLL_PTR=0xXXXXXXXXXXXXXX,
37 ID=0x000000000000000d,
38 N_COLS=0x00000003,
39 TYPE=0x00000001,
40 MIX_ID=0x0000000000000000,
41 MIX_LEN=0x00000040,
42 CLUSTER_NAME=NULL(0 bytes),
43 SPACE=0x00000000)
44 header=0x0400301501f2 (NAME='test/tc',
45 DB_TRX_ID=0xXXXXXXXXXXXX,
46 DB_ROLL_PTR=0xXXXXXXXXXXXXXX,
47 ID=0x000000000000000f,
48 N_COLS=0x80000001,
49 TYPE=0x00000001,
50 MIX_ID=0x0000000000000000,
51 MIX_LEN=0x00000050,
52 CLUSTER_NAME=NULL(0 bytes),
53 SPACE=0x00000002)
54 header=0x00003815027a (NAME='test/td',
55 DB_TRX_ID=0xXXXXXXXXXXXX,
56 DB_ROLL_PTR=0xXXXXXXXXXXXXXX,
57 ID=0x0000000000000010,
58 N_COLS=0x80000001,
59 TYPE=0x00000021,
60 MIX_ID=0x0000000000000000,
61 MIX_LEN=0x00000050,
62 CLUSTER_NAME=NULL(0 bytes),
63 SPACE=0x00000003)
64 header=0x00004815016a (NAME='test/tp',
65 DB_TRX_ID=0xXXXXXXXXXXXX,
66 DB_ROLL_PTR=0xXXXXXXXXXXXXXX,
67 ID=0x0000000000000012,
68 N_COLS=0x80000001,
69 TYPE=0x000009a1,
70 MIX_ID=0x0000000000000000,
71 MIX_LEN=0x00000050,
72 CLUSTER_NAME=NULL(0 bytes),
73 SPACE=0x00000005)
74 header=0x000028150236 (NAME='test/tr',
75 DB_TRX_ID=0xXXXXXXXXXXXX,
76 DB_ROLL_PTR=0xXXXXXXXXXXXXXX,
77 ID=0x000000000000000e,
78 N_COLS=0x00000001,
79 TYPE=0x00000001,
80 MIX_ID=0x0000000000000000,
81 MIX_LEN=0x00000050,
82 CLUSTER_NAME=NULL(0 bytes),
83 SPACE=0x00000001)
84 header=0x000040150074 (NAME='test/tz',
85 DB_TRX_ID=0xXXXXXXXXXXXX,
86 DB_ROLL_PTR=0xXXXXXXXXXXXXXX,
87 ID=0x0000000000000011,
88 N_COLS=0x80000001,
89 TYPE=0x00000023,
90 MIX_ID=0x0000000000000000,
91 MIX_LEN=0x00000050,
92 CLUSTER_NAME=NULL(0 bytes),
93 SPACE=0x00000004)
94 header=0x050008030000 (NAME=0x73757072656d756d00)
95 # restart: with restart_parameters
96 SHOW CREATE TABLE tr;
97 ERROR 42S02: Table 'test.tr' doesn't exist in engine
98 SHOW CREATE TABLE tc;
99 ERROR 42S02: Table 'test.tc' doesn't exist in engine
100 SELECT * FROM tc;
101 ERROR 42S02: Table 'test.tc' doesn't exist in engine
102 SHOW CREATE TABLE td;
103 ERROR HY000: Got error 194 "Tablespace is missing for a table" from storage engine InnoDB
104 SELECT * FROM td;
105 ERROR HY000: Got error 194 "Tablespace is missing for a table" from storage engine InnoDB
106 SHOW CREATE TABLE tz;
107 Table Create Table
108 tz CREATE TABLE `tz` (
109 `a` int(11) NOT NULL,
110 PRIMARY KEY (`a`)
111 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1
112 BEGIN;
113 INSERT INTO tz VALUES(42);
114 ROLLBACK;
115 SELECT * FROM tz;
116 a
117 42
118 SHOW CREATE TABLE tp;
119 ERROR 42S02: Table 'test.tp' doesn't exist in engine
120 FOUND 3 /InnoDB: Table test/t[cp] in InnoDB data dictionary contains invalid flags\. SYS_TABLES\.TYPE=(129|289|3873|1232[13]) SYS_TABLES\.N_COLS=2147483649/ in mysqld.1.err
121 FOUND 1 /InnoDB: Table test/tr in InnoDB data dictionary contains invalid flags\. SYS_TABLES\.TYPE=65 SYS_TABLES\.MIX_LEN=4294967295\b/ in mysqld.1.err
122 Restoring SYS_TABLES clustered index root page (8)
123 # restart: with restart_parameters
124 SHOW CREATE TABLE tr;
125 Table Create Table
126 tr CREATE TABLE `tr` (
127 `a` int(11) NOT NULL,
128 PRIMARY KEY (`a`)
129 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci ROW_FORMAT=REDUNDANT
130 SHOW CREATE TABLE tc;
131 Table Create Table
132 tc CREATE TABLE `tc` (
133 `a` int(11) NOT NULL,
134 PRIMARY KEY (`a`)
135 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci ROW_FORMAT=COMPACT
136 SHOW CREATE TABLE td;
137 Table Create Table
138 td CREATE TABLE `td` (
139 `a` int(11) NOT NULL,
140 PRIMARY KEY (`a`)
141 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci ROW_FORMAT=DYNAMIC
142 SHOW CREATE TABLE tz;
143 Table Create Table
144 tz CREATE TABLE `tz` (
145 `a` int(11) NOT NULL,
146 PRIMARY KEY (`a`)
147 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1
148 SHOW CREATE TABLE tp;
149 Table Create Table
150 tp CREATE TABLE `tp` (
151 `a` int(11) NOT NULL,
152 PRIMARY KEY (`a`)
153 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci ROW_FORMAT=DYNAMIC `PAGE_COMPRESSED`=1 `PAGE_COMPRESSION_LEVEL`=9
154 BEGIN;
155 INSERT INTO tr VALUES(1);
156 INSERT INTO tc VALUES(1);
157 INSERT INTO td VALUES(1);
158 INSERT INTO tz VALUES(1);
159 INSERT INTO tp VALUES(1);
160 ROLLBACK;
161 SELECT * FROM tr;
162 a
163 SELECT * FROM tc;
164 a
165 SELECT * FROM td;
166 a
167 SELECT * FROM tp;
168 a
169 DROP TABLE tr,tc,td,tz,tp;
170 # restart
171 ib_logfile0
172 ibdata1
173 sys_tables.bin
174 call mtr.add_suppression("ERROR HY000: Can't create table `test`.`t1`");
175 CREATE TABLE t1(f1 INT, f2 VARCHAR(1), KEY k1(f2),
176 FULLTEXT KEY(f2),
177 FOREIGN KEY (f2) REFERENCES t1(f3))ENGINE=InnoDB;
178 ERROR HY000: Can't create table `test`.`t1` (errno: 150 "Foreign key constraint is incorrectly formed")
179 #
180 # MDEV-23199 page_compression flag is missing
181 # for full_crc32 tablespace
182 #
183 CREATE TABLE t1(f1 BIGINT PRIMARY KEY)ENGINE=InnoDB;
184 INSERT INTO t1 VALUES(1);
185 ALTER TABLE t1 PAGE_COMPRESSED = 1;
186 INSERT INTO t1 VALUES(2);
187 # restart
188 DROP TABLE t1;
189 #
190 # MDEV-38079 Crash recovery fails after ALTER TABLE…PAGE_COMPRESSED=1
191 #
192 SET @df_row = @@global.INNODB_DEFAULT_ROW_FORMAT;
193 SET GLOBAL INNODB_DEFAULT_ROW_FORMAT=REDUNDANT;
194 CREATE TABLE t1 (c CHAR(1)) ENGINE=InnoDB;
195 ALTER TABLE t1 PAGE_COMPRESSED=1, ALGORITHM=INPLACE;
196 ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'PAGE_COMPRESSED'
197 ALTER TABLE t1 PAGE_COMPRESSED=1, ALGORITHM=COPY;
198 ERROR HY000: Can't create table `test`.`t1` (errno: 140 "Wrong create options")
199 SET GLOBAL INNODB_DEFAULT_ROW_FORMAT=compact;
200 ALTER TABLE t1 PAGE_COMPRESSED=1, ALGORITHM=COPY;
201 DROP TABLE t1;
202 SET @@global.INNODB_DEFAULT_ROW_FORMAT = @df_row;