Debian Codegraph @

mysql-test/suite/innodb/r/innodb-table-online.result

raw
1 ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2 SET GLOBAL innodb_monitor_reset_all=all;
3 SET GLOBAL innodb_monitor_reset_all=default;
4 call mtr.add_suppression("InnoDB: Warning: Small buffer pool size");
5 call mtr.add_suppression("InnoDB: Error: table 'test/t1'");
6 call mtr.add_suppression("MariaDB is trying to open a table handle but the .ibd file for");
7 CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(255) NOT NULL)
8 ENGINE = InnoDB;
9 INSERT INTO t1 VALUES (1,1,''), (2,2,''), (3,3,''), (4,4,''), (5,5,'');
10 SET GLOBAL innodb_monitor_enable = module_ddl;
11 SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
12 name count
13 ddl_background_drop_indexes 0
14 ddl_online_create_index 0
15 ddl_pending_alter_table 0
16 ddl_sort_file_alter_table 0
17 ddl_log_file_alter_table 0
18 SET DEBUG_SYNC = 'RESET';
19 SET DEBUG_SYNC = 'write_row_noreplace SIGNAL have_handle WAIT_FOR go_ahead';
20 INSERT INTO t1 VALUES(1,2,3);
21 connect con1,localhost,root,,;
22 SET DEBUG_SYNC = 'now WAIT_FOR have_handle';
23 SET lock_wait_timeout = 1;
24 ALTER TABLE t1 ROW_FORMAT=REDUNDANT;
25 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
26 SET DEBUG_SYNC = 'now SIGNAL go_ahead';
27 connection default;
28 ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
29 SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
30 name count
31 ddl_background_drop_indexes 0
32 ddl_online_create_index 0
33 ddl_pending_alter_table 0
34 ddl_sort_file_alter_table 0
35 ddl_log_file_alter_table 0
36 connection con1;
37 SET @saved_debug_dbug = @@SESSION.debug_dbug;
38 SET DEBUG_DBUG = '+d,innodb_OOM_prepare_inplace_alter';
39 ALTER TABLE t1 ROW_FORMAT=REDUNDANT, ALGORITHM=INPLACE, LOCK=NONE;
40 ERROR HY000: Out of memory.
41 SET SESSION DEBUG_DBUG = @saved_debug_dbug;
42 SET SESSION DEBUG_DBUG = '+d,innodb_OOM_inplace_alter';
43 ALTER TABLE t1 ROW_FORMAT=REDUNDANT, ALGORITHM=INPLACE, LOCK=NONE;
44 ERROR HY000: Out of memory.
45 SET SESSION DEBUG_DBUG = @saved_debug_dbug;
46 ALTER TABLE t1 ROW_FORMAT=REDUNDANT, ALGORITHM=INPLACE, LOCK=NONE;
47 connection default;
48 SHOW CREATE TABLE t1;
49 Table Create Table
50 t1 CREATE TABLE `t1` (
51 `c1` int(11) NOT NULL,
52 `c2` int(11) NOT NULL,
53 `c3` char(255) NOT NULL,
54 PRIMARY KEY (`c1`)
55 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=REDUNDANT
56 BEGIN;
57 INSERT INTO t1 VALUES(7,4,2);
58 connection con1;
59 SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL scanned WAIT_FOR insert_done';
60 ALTER TABLE t1 DROP PRIMARY KEY, ADD UNIQUE INDEX(c2);
61 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
62 connection default;
63 COMMIT;
64 connection con1;
65 ALTER TABLE t1 DROP PRIMARY KEY, ADD UNIQUE INDEX(c2);
66 ERROR 23000: Duplicate entry '4' for key 'c2'
67 connection default;
68 DELETE FROM t1 WHERE c1 = 7;
69 connection con1;
70 ALTER TABLE t1 DROP PRIMARY KEY, ADD UNIQUE INDEX(c2), ROW_FORMAT=COMPACT,
71 LOCK = SHARED, ALGORITHM = INPLACE;
72 ALTER TABLE t1 ADD UNIQUE INDEX(c2),
73 LOCK = EXCLUSIVE, ALGORITHM = INPLACE;
74 Warnings:
75 Note 1831 Duplicate index `c2_2`. This is deprecated and will be disallowed in a future release
76 SHOW CREATE TABLE t1;
77 Table Create Table
78 t1 CREATE TABLE `t1` (
79 `c1` int(11) NOT NULL,
80 `c2` int(11) NOT NULL,
81 `c3` char(255) NOT NULL,
82 UNIQUE KEY `c2` (`c2`),
83 UNIQUE KEY `c2_2` (`c2`)
84 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=COMPACT
85 ALTER TABLE t1 DROP INDEX c2, ADD PRIMARY KEY(c1);
86 connection default;
87 SET DEBUG_SYNC = 'now WAIT_FOR scanned';
88 SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
89 name count
90 ddl_background_drop_indexes 0
91 ddl_online_create_index 1
92 ddl_pending_alter_table 1
93 ddl_sort_file_alter_table 0
94 ddl_log_file_alter_table 0
95 INSERT INTO t1 VALUES(4,7,2);
96 SET DEBUG_SYNC = 'now SIGNAL insert_done';
97 connection con1;
98 ERROR 23000: Duplicate entry '4' for key 'PRIMARY'
99 DELETE FROM t1 WHERE c1=4 and c2=7;
100 connection default;
101 ROLLBACK;
102 connection con1;
103 SHOW CREATE TABLE t1;
104 Table Create Table
105 t1 CREATE TABLE `t1` (
106 `c1` int(11) NOT NULL,
107 `c2` int(11) NOT NULL,
108 `c3` char(255) NOT NULL,
109 UNIQUE KEY `c2` (`c2`),
110 UNIQUE KEY `c2_2` (`c2`)
111 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=COMPACT
112 ALTER TABLE t1 DROP PRIMARY KEY, ADD UNIQUE INDEX(c2), ALGORITHM = INPLACE;
113 ERROR 42000: Can't DROP INDEX `PRIMARY`; check that it exists
114 ALTER TABLE t1 DROP INDEX c2, ADD PRIMARY KEY(c1), ALGORITHM = INPLACE;
115 SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
116 name count
117 ddl_background_drop_indexes 0
118 ddl_online_create_index 0
119 ddl_pending_alter_table 0
120 ddl_sort_file_alter_table 0
121 ddl_log_file_alter_table 0
122 connection default;
123 INSERT INTO t1 VALUES(6,3,1);
124 ERROR 23000: Duplicate entry '3' for key 'c2_2'
125 INSERT INTO t1 VALUES(7,4,2);
126 ERROR 23000: Duplicate entry '4' for key 'c2_2'
127 DROP INDEX c2_2 ON t1;
128 BEGIN;
129 INSERT INTO t1 VALUES(7,4,2);
130 ROLLBACK;
131 connection con1;
132 KILL QUERY @id;
133 ERROR 70100: Query execution was interrupted
134 SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL rebuilt WAIT_FOR dml_done';
135 SET DEBUG_SYNC = 'row_log_table_apply2_before SIGNAL applied WAIT_FOR kill_done';
136 ALTER TABLE t1 ROW_FORMAT=REDUNDANT;
137 connection default;
138 SET DEBUG_SYNC = 'now WAIT_FOR rebuilt';
139 SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
140 name count
141 ddl_background_drop_indexes 0
142 ddl_online_create_index 1
143 ddl_pending_alter_table 1
144 ddl_sort_file_alter_table 0
145 ddl_log_file_alter_table 0
146 BEGIN;
147 INSERT INTO t1 VALUES(7,4,2);
148 ROLLBACK;
149 SET DEBUG_SYNC = 'now SIGNAL dml_done WAIT_FOR applied';
150 KILL QUERY @id;
151 SET DEBUG_SYNC = 'now SIGNAL kill_done';
152 connection con1;
153 ERROR 70100: Query execution was interrupted
154 SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
155 name count
156 ddl_background_drop_indexes 0
157 ddl_online_create_index 0
158 ddl_pending_alter_table 0
159 ddl_sort_file_alter_table 0
160 ddl_log_file_alter_table 0
161 connection default;
162 CHECK TABLE t1;
163 Table Op Msg_type Msg_text
164 test.t1 check status OK
165 INSERT INTO t1 SELECT 5 + c1, c2, c3 FROM t1;
166 INSERT INTO t1 SELECT 10 + c1, c2, c3 FROM t1;
167 INSERT INTO t1 SELECT 20 + c1, c2, c3 FROM t1;
168 INSERT INTO t1 SELECT 40 + c1, c2, c3 FROM t1;
169 EXPLAIN SELECT COUNT(*) FROM t1 WHERE c2 > 3;
170 id select_type table type possible_keys key key_len ref rows Extra
171 1 SIMPLE t1 ALL NULL NULL NULL NULL ROWS Using where
172 ANALYZE TABLE t1;
173 Table Op Msg_type Msg_text
174 test.t1 analyze status Engine-independent statistics collected
175 test.t1 analyze status OK
176 SET @merge_encrypt_0=
177 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
178 WHERE variable_name = 'innodb_encryption_n_merge_blocks_encrypted');
179 SET @merge_decrypt_0=
180 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
181 WHERE variable_name = 'innodb_encryption_n_merge_blocks_decrypted');
182 SET @rowlog_encrypt_0=
183 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
184 WHERE variable_name = 'innodb_encryption_n_rowlog_blocks_encrypted');
185 connection con1;
186 SHOW CREATE TABLE t1;
187 Table Create Table
188 t1 CREATE TABLE `t1` (
189 `c1` int(11) NOT NULL,
190 `c2` int(11) NOT NULL,
191 `c3` char(255) NOT NULL,
192 PRIMARY KEY (`c1`)
193 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=COMPACT
194 ALTER TABLE t1 ROW_FORMAT=REDUNDANT;
195 SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL rebuilt2 WAIT_FOR dml2_done';
196 SET lock_wait_timeout = 10;
197 ALTER TABLE t1 ROW_FORMAT=COMPACT
198 PAGE_COMPRESSED = YES PAGE_COMPRESSION_LEVEL = 1, ALGORITHM = INPLACE;
199 connection default;
200 SET DEBUG_SYNC = 'now WAIT_FOR rebuilt2';
201 INSERT INTO t1 SELECT 80 + c1, c2, c3 FROM t1;
202 INSERT INTO t1 SELECT 160 + c1, c2, c3 FROM t1;
203 UPDATE t1 SET c2 = c2 + 1;
204 SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
205 name count
206 ddl_background_drop_indexes 0
207 ddl_online_create_index 1
208 ddl_pending_alter_table 1
209 ddl_sort_file_alter_table 0
210 ddl_log_file_alter_table 1
211 UPDATE t1 SET c2 = c2 + 1;
212 UPDATE t1 SET c2 = c2 + 2;
213 UPDATE t1 SET c2 = c2 + 1;
214 UPDATE t1 SET c2 = c2 + 2;
215 UPDATE t1 SET c2 = c2 + 1;
216 UPDATE t1 SET c2 = c2 + 2;
217 UPDATE t1 SET c2 = c2 + 1;
218 UPDATE t1 SET c2 = c2 + 2;
219 UPDATE t1 SET c2 = c2 + 1;
220 UPDATE t1 SET c2 = c2 + 2;
221 UPDATE t1 SET c2 = c2 + 1;
222 UPDATE t1 SET c2 = c2 + 2;
223 UPDATE t1 SET c2 = c2 + 1;
224 UPDATE t1 SET c2 = c2 + 2;
225 UPDATE t1 SET c2 = c2 + 1;
226 UPDATE t1 SET c2 = c2 + 2;
227 SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
228 name count
229 ddl_background_drop_indexes 0
230 ddl_online_create_index 1
231 ddl_pending_alter_table 1
232 ddl_sort_file_alter_table 0
233 ddl_log_file_alter_table 1
234 SET @merge_encrypt_1=
235 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
236 WHERE variable_name = 'innodb_encryption_n_merge_blocks_encrypted');
237 SET @merge_decrypt_1=
238 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
239 WHERE variable_name = 'innodb_encryption_n_merge_blocks_decrypted');
240 SET @rowlog_encrypt_1=
241 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
242 WHERE variable_name = 'innodb_encryption_n_rowlog_blocks_encrypted');
243 SELECT
244 (@merge_encrypt_1-@merge_encrypt_0)-
245 (@merge_decrypt_1-@merge_decrypt_0) as sort_balance,
246 @merge_encrypt_1>@merge_encrypt_0, @merge_decrypt_1>@merge_decrypt_0,
247 @rowlog_encrypt_1>@rowlog_encrypt_0;
248 sort_balance @merge_encrypt_1>@merge_encrypt_0 @merge_decrypt_1>@merge_decrypt_0 @rowlog_encrypt_1>@rowlog_encrypt_0
249 0 0 0 0
250 SET DEBUG_SYNC = 'now SIGNAL dml2_done';
251 connection con1;
252 ERROR HY000: Creating index 'PRIMARY' required more than 'innodb_online_alter_log_max_size' bytes of modification log. Please try again
253 SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
254 name count
255 ddl_background_drop_indexes 0
256 ddl_online_create_index 0
257 ddl_pending_alter_table 0
258 ddl_sort_file_alter_table 0
259 ddl_log_file_alter_table 1
260 SET @merge_encrypt_1=
261 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
262 WHERE variable_name = 'innodb_encryption_n_merge_blocks_encrypted');
263 SET @merge_decrypt_1=
264 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
265 WHERE variable_name = 'innodb_encryption_n_merge_blocks_decrypted');
266 SET @rowlog_encrypt_1=
267 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
268 WHERE variable_name = 'innodb_encryption_n_rowlog_blocks_encrypted');
269 SET @rowlog_decrypt_1=
270 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
271 WHERE variable_name = 'innodb_encryption_n_rowlog_blocks_decrypted');
272 SET GLOBAL innodb_max_purge_lag_wait=0;
273 SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL rebuilt3 WAIT_FOR dml3_done';
274 ALTER TABLE t1 ADD PRIMARY KEY(c22f), CHANGE c2 c22f INT;
275 ERROR 42000: Multiple primary key defined
276 ALTER TABLE t1 DROP PRIMARY KEY, ADD PRIMARY KEY(c22f), CHANGE c2 c22f INT;
277 ERROR 23000: Duplicate entry '26' for key 'PRIMARY'
278 ALTER TABLE t1 DROP PRIMARY KEY, ADD PRIMARY KEY(c22f,c1,c4(5)),
279 CHANGE c2 c22f INT, CHANGE c3 c3 CHAR(255) NULL, CHANGE c1 c1 INT AFTER c22f,
280 ADD COLUMN c4 VARCHAR(6) DEFAULT 'Online', LOCK=NONE;
281 connection default;
282 SET DEBUG_SYNC = 'now WAIT_FOR rebuilt3';
283 SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
284 name count
285 ddl_background_drop_indexes 0
286 ddl_online_create_index 1
287 ddl_pending_alter_table 1
288 ddl_sort_file_alter_table 2
289 ddl_log_file_alter_table 1
290 BEGIN;
291 INSERT INTO t1 SELECT 320 + c1, c2, c3 FROM t1 WHERE c1 > 240;
292 DELETE FROM t1 WHERE c1 > 320;
293 UPDATE t1 SET c2 = c2 + 1;
294 COMMIT;
295 SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
296 name count
297 ddl_background_drop_indexes 0
298 ddl_online_create_index 1
299 ddl_pending_alter_table 1
300 ddl_sort_file_alter_table 2
301 ddl_log_file_alter_table 2
302 SET DEBUG_SYNC = 'now SIGNAL dml3_done';
303 connection con1;
304 SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
305 name count
306 ddl_background_drop_indexes 0
307 ddl_online_create_index 0
308 ddl_pending_alter_table 0
309 ddl_sort_file_alter_table 2
310 ddl_log_file_alter_table 2
311 SELECT COUNT(c22f) FROM t1;
312 COUNT(c22f)
313 320
314 CHECK TABLE t1;
315 Table Op Msg_type Msg_text
316 test.t1 check status OK
317 SET @merge_encrypt_2=
318 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
319 WHERE variable_name = 'innodb_encryption_n_merge_blocks_encrypted');
320 SET @merge_decrypt_2=
321 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
322 WHERE variable_name = 'innodb_encryption_n_merge_blocks_decrypted');
323 SET @rowlog_encrypt_2=
324 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
325 WHERE variable_name = 'innodb_encryption_n_rowlog_blocks_encrypted');
326 SET @rowlog_decrypt_2=
327 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
328 WHERE variable_name = 'innodb_encryption_n_rowlog_blocks_decrypted');
329 SELECT
330 (@merge_encrypt_2-@merge_encrypt_1)-
331 (@merge_decrypt_2-@merge_decrypt_1) as sort_balance,
332 (@rowlog_encrypt_2-@rowlog_encrypt_1)-
333 (@rowlog_decrypt_2-@rowlog_decrypt_1) as log_balance;
334 sort_balance log_balance
335 0 0
336 SELECT
337 @merge_encrypt_2-@merge_encrypt_1>0 as sort_encrypted,
338 @merge_decrypt_2-@merge_decrypt_1>0 as sort_decrypted,
339 @rowlog_encrypt_2-@rowlog_encrypt_1>0 as log_encrypted,
340 @rowlog_decrypt_2-@rowlog_decrypt_1>0 as log_decrypted;
341 sort_encrypted sort_decrypted log_encrypted log_decrypted
342 0 0 0 0
343 ALTER TABLE t1 DROP PRIMARY KEY, ADD PRIMARY KEY c3p5(c3(5));
344 ERROR 23000: Duplicate entry '' for key 'PRIMARY'
345 UPDATE t1 SET c3 = NULL WHERE c3 = '';
346 SET lock_wait_timeout = 1;
347 ALTER TABLE t1 DROP COLUMN c22f, ADD PRIMARY KEY c3p5(c3(5));
348 ERROR 42000: Key column 'c22f' doesn't exist in table
349 ALTER IGNORE TABLE t1 DROP COLUMN c22f, DROP PRIMARY KEY, ADD PRIMARY KEY c3p5(c3(5)),
350 ALGORITHM = INPLACE;
351 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Creating unique indexes with IGNORE requires COPY algorithm to remove duplicate rows. Try ALGORITHM=COPY
352 UPDATE t1 SET c3=LEFT(CONCAT(c1,REPEAT('foo',c1)),255) WHERE c3 IS NULL;
353 SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL c3p5_created0 WAIT_FOR ins_done0';
354 ALTER TABLE t1 MODIFY c3 CHAR(255) NOT NULL, DROP COLUMN c22f,
355 DROP PRIMARY KEY, ADD PRIMARY KEY(c1,c4(5)),
356 ADD COLUMN c5 CHAR(5) DEFAULT 'tired' FIRST;
357 connection default;
358 SET DEBUG_SYNC = 'now WAIT_FOR c3p5_created0';
359 BEGIN;
360 INSERT INTO t1 VALUES(347,33101,'Pikku kakkosen posti','YLETV2');
361 INSERT INTO t1 VALUES(33101,347,NULL,'');
362 COMMIT;
363 SET DEBUG_SYNC = 'now SIGNAL ins_done0';
364 connection con1;
365 ERROR 22004: Invalid use of NULL value
366 DELETE FROM t1 WHERE c1= 347 and c22f = 33101;
367 ALTER TABLE t1 MODIFY c3 CHAR(255) NOT NULL;
368 SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL c3p5_created WAIT_FOR ins_done';
369 ALTER TABLE t1 DROP PRIMARY KEY, DROP COLUMN c22f,
370 ADD COLUMN c6 VARCHAR(1000) DEFAULT
371 'I love tracking down hard-to-reproduce bugs.',
372 ADD PRIMARY KEY c3p5(c3(5), c6(2));
373 connection default;
374 SET DEBUG_SYNC = 'now WAIT_FOR c3p5_created';
375 SET DEBUG_SYNC = 'ib_after_row_insert SIGNAL ins_done WAIT_FOR ddl_timed_out';
376 INSERT INTO t1 VALUES(347,33101,NULL,'');
377 ERROR 23000: Column 'c3' cannot be null
378 INSERT INTO t1 VALUES(347,33101,'Pikku kakkosen posti','');
379 connection con1;
380 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
381 SET DEBUG_SYNC = 'now SIGNAL ddl_timed_out';
382 SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
383 name count
384 ddl_background_drop_indexes 0
385 ddl_online_create_index 0
386 ddl_pending_alter_table 0
387 ddl_sort_file_alter_table 6
388 ddl_log_file_alter_table 2
389 connection default;
390 SELECT COUNT(*) FROM t1;
391 COUNT(*)
392 322
393 ALTER TABLE t1 ROW_FORMAT=REDUNDANT;
394 SELECT * FROM t1 LIMIT 10;
395 c22f c1 c3 c4
396 27 1 1foo Online
397 27 6 6foofoofoofoofoofoo Online
398 27 11 11foofoofoofoofoofoofoofoofoofoofoo Online
399 27 16 16foofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoo Online
400 27 21 21foofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoo Online
401 27 26 26foofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoo Online
402 27 31 31foofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoo Online
403 27 36 36foofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoo Online
404 27 41 41foofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoo Online
405 27 46 46foofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoo Online
406 connection con1;
407 ALTER TABLE t1 DISCARD TABLESPACE;
408 connection default;
409 SHOW CREATE TABLE t1;
410 Table Create Table
411 t1 CREATE TABLE `t1` (
412 `c22f` int(11) NOT NULL,
413 `c1` int(11) NOT NULL,
414 `c3` char(255) NOT NULL,
415 `c4` varchar(6) NOT NULL DEFAULT 'Online',
416 PRIMARY KEY (`c22f`,`c1`,`c4`(5))
417 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=REDUNDANT
418 SET GLOBAL innodb_monitor_disable = module_ddl;
419 DROP TABLE t1;
420 CREATE TABLE t1 (a INT PRIMARY KEY, b blob) ENGINE=InnoDB;
421 INSERT INTO t1 VALUES(0,NULL);
422 connection con1;
423 SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL created WAIT_FOR ins';
424 ALTER TABLE t1 FORCE;
425 connection default;
426 SET DEBUG_SYNC = 'now WAIT_FOR created';
427 BEGIN;
428 INSERT INTO t1 VALUES(1, repeat('a', 10000));
429 ROLLBACK;
430 SET DEBUG_SYNC = 'now SIGNAL ins';
431 connection con1;
432 connection default;
433 SELECT * FROM t1;
434 a b
435 0 NULL
436 DROP TABLE t1;
437 SET DEBUG_SYNC = 'RESET';
438 #
439 # MDEV-29600 Memory leak in row_log_table_apply_update()
440 #
441 CREATE TABLE t1 (pk INT PRIMARY KEY, f TEXT) ENGINE=InnoDB;
442 INSERT INTO t1 SET pk=1;
443 connection con1;
444 SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL created WAIT_FOR updated';
445 ALTER TABLE t1 FORCE;
446 connection default;
447 SET DEBUG_SYNC = 'now WAIT_FOR created';
448 UPDATE t1 SET f = REPEAT('a', 20000);
449 SET DEBUG_SYNC = 'now SIGNAL updated';
450 connection con1;
451 connection default;
452 DROP TABLE t1;
453 #
454 # MDEV-29977 Memory leak in row_log_table_apply_update
455 #
456 CREATE TABLE t1(f1 longtext, f2 int, KEY(f1(1024)), KEY(f2, f1(20))) ENGINE=InnoDB;
457 INSERT INTO t1 VALUES('a', 1);
458 connection con1;
459 set DEBUG_SYNC="innodb_inplace_alter_table_enter SIGNAL con_default WAIT_FOR con1_signal";
460 ALTER TABLE t1 FORCE;
461 connection default;
462 SET DEBUG_SYNC="now WAIT_FOR con_default";
463 UPDATE t1 SET f1 = NULL;
464 UPDATE t1 SET f1 = REPEAT('b', 9000);
465 SET DEBUG_SYNC="now SIGNAL con1_signal";
466 connection con1;
467 DROP TABLE t1;
468 connection default;
469 #
470 # MDEV-28122 Optimize table crash while applying online log
471 #
472 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL,
473 f3 CHAR(200), f4 CHAR(200),
474 f5 VARCHAR(87), PRIMARY KEY(f1))ENGINE=InnoDB;
475 INSERT INTO t1 VALUES(6000, 6000, "InnoDB",
476 "MariaDB", repeat('a', 87));
477 SET DEBUG_SYNC="inplace_after_index_build SIGNAL dml_start WAIT_FOR dml_commit";
478 ALTER TABLE t1 FORCE;
479 connection con1;
480 SET DEBUG_SYNC="now WAIT_FOR dml_start";
481 BEGIN;
482 INSERT INTO t1 SELECT seq, seq, "IDB", "MDB", repeat('a', 87) FROM seq_1_to_127;
483 INSERT INTO t1 VALUES(128, 128, "IDB", "MDB", repeat('a', 86));
484 INSERT INTO t1 VALUES(129, 129, "idb", "mdb", repeat('a', 2));
485 COMMIT;
486 SET DEBUG_SYNC="now SIGNAL dml_commit";
487 connection default;
488 CHECK TABLE t1;
489 Table Op Msg_type Msg_text
490 test.t1 check status OK
491 DROP TABLE t1;
492 SET DEBUG_SYNC=RESET;
493 disconnect con1;
494 SET GLOBAL innodb_monitor_enable = default;
495 SET GLOBAL innodb_monitor_disable = default;
496 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;