Debian Codegraph @

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

raw
1 ##############################################
2 # Test instant ADD/DROP COLUMN for REDUNDANT format
3 ##############################################
4 # ------------------------------------------------------------
5 # Create a table with 3 columns. [id, c1, c2]
6 # ------------------------------------------------------------
7 CREATE TABLE t1(id INT PRIMARY KEY, c1 CHAR(10), c2 CHAR(10)) ROW_FORMAT=REDUNDANT;;
8 # Metadata from INFORMATION_SCHEMA.TABLES
9 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
10 test/t1 6 0 0 3 3 3
11 # Metadata from INFORMATION_SCHEMA.COLUMNS
12 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
13 id 0 6 1283 0 0 0
14 c1 1 13 16711934 0 0 0
15 c2 2 13 16711934 0 0 0
16 # DD Metadata of table
17 NAME SE_PRIVATE_DATA
18 t1 NULL
19 # DD Metadata of columns in table
20 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
21 id 1 MYSQL_TYPE_LONG 1 Visible table_id=TABLE_ID;
22 c1 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
23 c2 3 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
24 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
25 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID;
26 INSERT INTO t1 VALUES (1, "r1c1", "r1c2");
27 SELECT * FROM t1;
28 id c1 c2
29 1 r1c1 r1c2
30 # INSTANT ADD a column
31 Alter table t1 add column c3 char(10), algorithm=instant;
32 # Metadata from INFORMATION_SCHEMA.TABLES
33 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
34 test/t1 7 0 1 3 4 4
35 # Metadata from INFORMATION_SCHEMA.COLUMNS
36 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
37 id 0 6 1283 0 0 0
38 c1 1 13 16711934 0 0 0
39 c2 2 13 16711934 0 0 0
40 c3 3 13 16711934 1 1 0
41 # DD Metadata of table
42 NAME SE_PRIVATE_DATA
43 t1 NULL
44 # DD Metadata of columns in table
45 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
46 id 1 MYSQL_TYPE_LONG 1 Visible physical_pos=0;table_id=TABLE_ID;
47 c1 2 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
48 c2 3 MYSQL_TYPE_STRING 0 Visible physical_pos=4;table_id=TABLE_ID;
49 c3 4 MYSQL_TYPE_STRING 0 Visible default_null=1;physical_pos=5;table_id=TABLE_ID;version_added=1;
50 DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
51 DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
52 INSERT INTO t1 VALUES (2, "r2c1", "r2c2", "r2c3");
53 SELECT * FROM t1;
54 id c1 c2 c3
55 1 r1c1 r1c2 NULL
56 2 r2c1 r2c2 r2c3
57 # INSTANT DROP a column
58 Alter table t1 drop column c2 , algorithm=instant;
59 # Metadata from INFORMATION_SCHEMA.TABLES
60 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
61 test/t1 6 0 2 3 3 4
62 # Metadata from INFORMATION_SCHEMA.COLUMNS
63 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
64 id 0 6 1283 0 0 0
65 c1 1 13 16711934 0 0 0
66 c3 2 13 16711934 1 1 0
67 !hidden!_dropped_v2_p4_c2 6 13 16711934 0 0 2
68 # DD Metadata of table
69 NAME SE_PRIVATE_DATA
70 t1 NULL
71 # DD Metadata of columns in table
72 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
73 id 1 MYSQL_TYPE_LONG 1 Visible physical_pos=0;table_id=TABLE_ID;
74 c1 2 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
75 c3 3 MYSQL_TYPE_STRING 0 Visible default_null=1;physical_pos=5;table_id=TABLE_ID;version_added=1;
76 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
77 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
78 !hidden!_dropped_v2_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=2;
79 INSERT INTO t1 VALUES (3, "r3c1", "r3c3");
80 SELECT * FROM t1;
81 id c1 c3
82 1 r1c1 NULL
83 2 r2c1 r2c3
84 3 r3c1 r3c3
85 # Make sure nothing gets flushed on disk
86 SET GLOBAL innodb_log_checkpoint_now = ON;
87 SET GLOBAL innodb_page_cleaner_disabled_debug = 1;
88 SET GLOBAL innodb_dict_stats_disabled_debug = 1;
89 SET GLOBAL innodb_master_thread_disabled_debug = 1;
90 # Make inplace update
91 UPDATE t1 SET c1="r0c0";
92 # Make not-inplace update
93 UPDATE t1 SET c3="r1c3" WHERE id=1;
94 # Insert a new record
95 INSERT INTO t1 VALUES (4, "r4c1", "r4c3");
96 # Delete a record
97 DELETE FROM t1 WHERE id=2;
98 # Kill and restart
99 # Metadata from INFORMATION_SCHEMA.TABLES
100 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
101 test/t1 6 0 2 3 3 4
102 # Metadata from INFORMATION_SCHEMA.COLUMNS
103 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
104 id 0 6 1283 0 0 0
105 c1 1 13 16711934 0 0 0
106 c3 2 13 16711934 1 1 0
107 !hidden!_dropped_v2_p4_c2 6 13 16711934 0 0 2
108 # DD Metadata of table
109 NAME SE_PRIVATE_DATA
110 t1 NULL
111 # DD Metadata of columns in table
112 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
113 id 1 MYSQL_TYPE_LONG 1 Visible physical_pos=0;table_id=TABLE_ID;
114 c1 2 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
115 c3 3 MYSQL_TYPE_STRING 0 Visible default_null=1;physical_pos=5;table_id=TABLE_ID;version_added=1;
116 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
117 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
118 !hidden!_dropped_v2_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=2;
119 SELECT * FROM t1;
120 id c1 c3
121 1 r0c0 r1c3
122 3 r0c0 r3c3
123 4 r4c1 r4c3
124 ###########
125 # CLEANUP #
126 ###########
127 DROP TABLE t1;
128 CREATE TABLE t1 (`c` text, `b` blob NOT NULL, `nc03242` longblob, `d` int DEFAULT NULL, UNIQUE KEY `b` (`b`(99))) ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
129 alter table t1
130 change c c text after d,
131 add column nc05984 bool,
132 algorithm=instant;
133 SET GLOBAL innodb_log_checkpoint_now = ON;
134 SET GLOBAL innodb_page_cleaner_disabled_debug = 1;
135 SET GLOBAL innodb_dict_stats_disabled_debug = 1;
136 SET GLOBAL innodb_master_thread_disabled_debug = 1;
137 INSERT INTO t1 SET b='ulccclraaacaucrouorouoooolrlo', d=6;
138 # Kill and restart
139 SELECT * FROM t1;
140 b nc03242 d c nc05984
141 ulccclraaacaucrouorouoooolrlo NULL 6 NULL NULL
142 DROP TABLE t1;
143 ############################################
144 # Test instant ADD/DROP COLUMN for DYNAMIC format
145 ############################################
146 # ------------------------------------------------------------
147 # Create a table with 3 columns. [id, c1, c2]
148 # ------------------------------------------------------------
149 CREATE TABLE t1(id INT PRIMARY KEY, c1 CHAR(10), c2 CHAR(10)) ROW_FORMAT=DYNAMIC;;
150 # Metadata from INFORMATION_SCHEMA.TABLES
151 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
152 test/t1 6 0 0 3 3 3
153 # Metadata from INFORMATION_SCHEMA.COLUMNS
154 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
155 id 0 6 1283 0 0 0
156 c1 1 13 16711934 0 0 0
157 c2 2 13 16711934 0 0 0
158 # DD Metadata of table
159 NAME SE_PRIVATE_DATA
160 t1 NULL
161 # DD Metadata of columns in table
162 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
163 id 1 MYSQL_TYPE_LONG 1 Visible table_id=TABLE_ID;
164 c1 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
165 c2 3 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
166 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
167 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID;
168 INSERT INTO t1 VALUES (1, "r1c1", "r1c2");
169 SELECT * FROM t1;
170 id c1 c2
171 1 r1c1 r1c2
172 # INSTANT ADD a column
173 Alter table t1 add column c3 char(10), algorithm=instant;
174 # Metadata from INFORMATION_SCHEMA.TABLES
175 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
176 test/t1 7 0 1 3 4 4
177 # Metadata from INFORMATION_SCHEMA.COLUMNS
178 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
179 id 0 6 1283 0 0 0
180 c1 1 13 16711934 0 0 0
181 c2 2 13 16711934 0 0 0
182 c3 3 13 16711934 1 1 0
183 # DD Metadata of table
184 NAME SE_PRIVATE_DATA
185 t1 NULL
186 # DD Metadata of columns in table
187 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
188 id 1 MYSQL_TYPE_LONG 1 Visible physical_pos=0;table_id=TABLE_ID;
189 c1 2 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
190 c2 3 MYSQL_TYPE_STRING 0 Visible physical_pos=4;table_id=TABLE_ID;
191 c3 4 MYSQL_TYPE_STRING 0 Visible default_null=1;physical_pos=5;table_id=TABLE_ID;version_added=1;
192 DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
193 DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
194 INSERT INTO t1 VALUES (2, "r2c1", "r2c2", "r2c3");
195 SELECT * FROM t1;
196 id c1 c2 c3
197 1 r1c1 r1c2 NULL
198 2 r2c1 r2c2 r2c3
199 # INSTANT DROP a column
200 Alter table t1 drop column c2 , algorithm=instant;
201 # Metadata from INFORMATION_SCHEMA.TABLES
202 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
203 test/t1 6 0 2 3 3 4
204 # Metadata from INFORMATION_SCHEMA.COLUMNS
205 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
206 id 0 6 1283 0 0 0
207 c1 1 13 16711934 0 0 0
208 c3 2 13 16711934 1 1 0
209 !hidden!_dropped_v2_p4_c2 6 13 16711934 0 0 2
210 # DD Metadata of table
211 NAME SE_PRIVATE_DATA
212 t1 NULL
213 # DD Metadata of columns in table
214 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
215 id 1 MYSQL_TYPE_LONG 1 Visible physical_pos=0;table_id=TABLE_ID;
216 c1 2 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
217 c3 3 MYSQL_TYPE_STRING 0 Visible default_null=1;physical_pos=5;table_id=TABLE_ID;version_added=1;
218 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
219 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
220 !hidden!_dropped_v2_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=2;
221 INSERT INTO t1 VALUES (3, "r3c1", "r3c3");
222 SELECT * FROM t1;
223 id c1 c3
224 1 r1c1 NULL
225 2 r2c1 r2c3
226 3 r3c1 r3c3
227 # Make sure nothing gets flushed on disk
228 SET GLOBAL innodb_log_checkpoint_now = ON;
229 SET GLOBAL innodb_page_cleaner_disabled_debug = 1;
230 SET GLOBAL innodb_dict_stats_disabled_debug = 1;
231 SET GLOBAL innodb_master_thread_disabled_debug = 1;
232 # Make inplace update
233 UPDATE t1 SET c1="r0c0";
234 # Make not-inplace update
235 UPDATE t1 SET c3="r1c3" WHERE id=1;
236 # Insert a new record
237 INSERT INTO t1 VALUES (4, "r4c1", "r4c3");
238 # Delete a record
239 DELETE FROM t1 WHERE id=2;
240 # Kill and restart
241 # Metadata from INFORMATION_SCHEMA.TABLES
242 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
243 test/t1 6 0 2 3 3 4
244 # Metadata from INFORMATION_SCHEMA.COLUMNS
245 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
246 id 0 6 1283 0 0 0
247 c1 1 13 16711934 0 0 0
248 c3 2 13 16711934 1 1 0
249 !hidden!_dropped_v2_p4_c2 6 13 16711934 0 0 2
250 # DD Metadata of table
251 NAME SE_PRIVATE_DATA
252 t1 NULL
253 # DD Metadata of columns in table
254 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
255 id 1 MYSQL_TYPE_LONG 1 Visible physical_pos=0;table_id=TABLE_ID;
256 c1 2 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
257 c3 3 MYSQL_TYPE_STRING 0 Visible default_null=1;physical_pos=5;table_id=TABLE_ID;version_added=1;
258 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
259 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
260 !hidden!_dropped_v2_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=2;
261 SELECT * FROM t1;
262 id c1 c3
263 1 r0c0 r1c3
264 3 r0c0 r3c3
265 4 r4c1 r4c3
266 ###########
267 # CLEANUP #
268 ###########
269 DROP TABLE t1;
270 CREATE TABLE t1 (`c` text, `b` blob NOT NULL, `nc03242` longblob, `d` int DEFAULT NULL, UNIQUE KEY `b` (`b`(99))) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
271 alter table t1
272 change c c text after d,
273 add column nc05984 bool,
274 algorithm=instant;
275 SET GLOBAL innodb_log_checkpoint_now = ON;
276 SET GLOBAL innodb_page_cleaner_disabled_debug = 1;
277 SET GLOBAL innodb_dict_stats_disabled_debug = 1;
278 SET GLOBAL innodb_master_thread_disabled_debug = 1;
279 INSERT INTO t1 SET b='ulccclraaacaucrouorouoooolrlo', d=6;
280 # Kill and restart
281 SELECT * FROM t1;
282 b nc03242 d c nc05984
283 ulccclraaacaucrouorouoooolrlo NULL 6 NULL NULL
284 DROP TABLE t1;
285 ############################################
286 # Test instant ADD/DROP COLUMN for COMPACT format
287 ############################################
288 # ------------------------------------------------------------
289 # Create a table with 3 columns. [id, c1, c2]
290 # ------------------------------------------------------------
291 CREATE TABLE t1(id INT PRIMARY KEY, c1 CHAR(10), c2 CHAR(10)) ROW_FORMAT=COMPACT;;
292 # Metadata from INFORMATION_SCHEMA.TABLES
293 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
294 test/t1 6 0 0 3 3 3
295 # Metadata from INFORMATION_SCHEMA.COLUMNS
296 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
297 id 0 6 1283 0 0 0
298 c1 1 13 16711934 0 0 0
299 c2 2 13 16711934 0 0 0
300 # DD Metadata of table
301 NAME SE_PRIVATE_DATA
302 t1 NULL
303 # DD Metadata of columns in table
304 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
305 id 1 MYSQL_TYPE_LONG 1 Visible table_id=TABLE_ID;
306 c1 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
307 c2 3 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
308 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
309 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID;
310 INSERT INTO t1 VALUES (1, "r1c1", "r1c2");
311 SELECT * FROM t1;
312 id c1 c2
313 1 r1c1 r1c2
314 # INSTANT ADD a column
315 Alter table t1 add column c3 char(10), algorithm=instant;
316 # Metadata from INFORMATION_SCHEMA.TABLES
317 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
318 test/t1 7 0 1 3 4 4
319 # Metadata from INFORMATION_SCHEMA.COLUMNS
320 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
321 id 0 6 1283 0 0 0
322 c1 1 13 16711934 0 0 0
323 c2 2 13 16711934 0 0 0
324 c3 3 13 16711934 1 1 0
325 # DD Metadata of table
326 NAME SE_PRIVATE_DATA
327 t1 NULL
328 # DD Metadata of columns in table
329 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
330 id 1 MYSQL_TYPE_LONG 1 Visible physical_pos=0;table_id=TABLE_ID;
331 c1 2 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
332 c2 3 MYSQL_TYPE_STRING 0 Visible physical_pos=4;table_id=TABLE_ID;
333 c3 4 MYSQL_TYPE_STRING 0 Visible default_null=1;physical_pos=5;table_id=TABLE_ID;version_added=1;
334 DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
335 DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
336 INSERT INTO t1 VALUES (2, "r2c1", "r2c2", "r2c3");
337 SELECT * FROM t1;
338 id c1 c2 c3
339 1 r1c1 r1c2 NULL
340 2 r2c1 r2c2 r2c3
341 # INSTANT DROP a column
342 Alter table t1 drop column c2 , algorithm=instant;
343 # Metadata from INFORMATION_SCHEMA.TABLES
344 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
345 test/t1 6 0 2 3 3 4
346 # Metadata from INFORMATION_SCHEMA.COLUMNS
347 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
348 id 0 6 1283 0 0 0
349 c1 1 13 16711934 0 0 0
350 c3 2 13 16711934 1 1 0
351 !hidden!_dropped_v2_p4_c2 6 13 16711934 0 0 2
352 # DD Metadata of table
353 NAME SE_PRIVATE_DATA
354 t1 NULL
355 # DD Metadata of columns in table
356 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
357 id 1 MYSQL_TYPE_LONG 1 Visible physical_pos=0;table_id=TABLE_ID;
358 c1 2 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
359 c3 3 MYSQL_TYPE_STRING 0 Visible default_null=1;physical_pos=5;table_id=TABLE_ID;version_added=1;
360 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
361 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
362 !hidden!_dropped_v2_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=2;
363 INSERT INTO t1 VALUES (3, "r3c1", "r3c3");
364 SELECT * FROM t1;
365 id c1 c3
366 1 r1c1 NULL
367 2 r2c1 r2c3
368 3 r3c1 r3c3
369 # Make sure nothing gets flushed on disk
370 SET GLOBAL innodb_log_checkpoint_now = ON;
371 SET GLOBAL innodb_page_cleaner_disabled_debug = 1;
372 SET GLOBAL innodb_dict_stats_disabled_debug = 1;
373 SET GLOBAL innodb_master_thread_disabled_debug = 1;
374 # Make inplace update
375 UPDATE t1 SET c1="r0c0";
376 # Make not-inplace update
377 UPDATE t1 SET c3="r1c3" WHERE id=1;
378 # Insert a new record
379 INSERT INTO t1 VALUES (4, "r4c1", "r4c3");
380 # Delete a record
381 DELETE FROM t1 WHERE id=2;
382 # Kill and restart
383 # Metadata from INFORMATION_SCHEMA.TABLES
384 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
385 test/t1 6 0 2 3 3 4
386 # Metadata from INFORMATION_SCHEMA.COLUMNS
387 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
388 id 0 6 1283 0 0 0
389 c1 1 13 16711934 0 0 0
390 c3 2 13 16711934 1 1 0
391 !hidden!_dropped_v2_p4_c2 6 13 16711934 0 0 2
392 # DD Metadata of table
393 NAME SE_PRIVATE_DATA
394 t1 NULL
395 # DD Metadata of columns in table
396 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
397 id 1 MYSQL_TYPE_LONG 1 Visible physical_pos=0;table_id=TABLE_ID;
398 c1 2 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
399 c3 3 MYSQL_TYPE_STRING 0 Visible default_null=1;physical_pos=5;table_id=TABLE_ID;version_added=1;
400 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
401 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
402 !hidden!_dropped_v2_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=2;
403 SELECT * FROM t1;
404 id c1 c3
405 1 r0c0 r1c3
406 3 r0c0 r3c3
407 4 r4c1 r4c3
408 ###########
409 # CLEANUP #
410 ###########
411 DROP TABLE t1;
412 CREATE TABLE t1 (`c` text, `b` blob NOT NULL, `nc03242` longblob, `d` int DEFAULT NULL, UNIQUE KEY `b` (`b`(99))) ENGINE=InnoDB ROW_FORMAT=COMPACT;
413 alter table t1
414 change c c text after d,
415 add column nc05984 bool,
416 algorithm=instant;
417 SET GLOBAL innodb_log_checkpoint_now = ON;
418 SET GLOBAL innodb_page_cleaner_disabled_debug = 1;
419 SET GLOBAL innodb_dict_stats_disabled_debug = 1;
420 SET GLOBAL innodb_master_thread_disabled_debug = 1;
421 INSERT INTO t1 SET b='ulccclraaacaucrouorouoooolrlo', d=6;
422 # Kill and restart
423 SELECT * FROM t1;
424 b nc03242 d c nc05984
425 ulccclraaacaucrouorouoooolrlo NULL 6 NULL NULL
426 DROP TABLE t1;