Debian Codegraph @

mysql-test/suite/innodb/t/innodb-index-online.test

raw
1 --source include/innodb_page_size_small.inc
2 --source include/innodb_encrypt_log.inc
3 --source include/have_debug.inc
4 --source include/have_debug_sync.inc
5 --source include/no_valgrind_without_big.inc
6
7 --disable_query_log
8 call mtr.add_suppression("InnoDB: Cannot reset all values for monitor counter");
9 --enable_query_log
10
11 SET GLOBAL innodb_monitor_reset_all=all;
12 --disable_warnings
13 SET GLOBAL innodb_monitor_reset_all=default;
14 --enable_warnings
15 let $innodb_metrics_select=
16 SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
17
18 call mtr.add_suppression("InnoDB: Warning: Small buffer pool size");
19
20 # Save the initial number of concurrent sessions.
21 --source include/count_sessions.inc
22
23 CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 INT, c3 TEXT)
24 ENGINE=InnoDB STATS_PERSISTENT=0;
25 INSERT INTO t1 VALUES (1,1,''), (2,2,''), (3,3,''), (4,4,''), (5,5,'');
26
27 SET GLOBAL innodb_monitor_enable = module_ddl;
28 eval $innodb_metrics_select;
29
30 SET DEBUG_SYNC = 'RESET';
31 SET DEBUG_SYNC = 'write_row_noreplace SIGNAL have_handle WAIT_FOR go_ahead';
32 --send
33 INSERT INTO t1 VALUES(1,2,3);
34
35 connect (con1,localhost,root,,);
36
37 # This should block at the end because of the INSERT in connection default
38 # is holding a metadata lock.
39 SET DEBUG_SYNC = 'now WAIT_FOR have_handle';
40 SET lock_wait_timeout = 1;
41 --error ER_LOCK_WAIT_TIMEOUT
42 ALTER TABLE t1 ADD UNIQUE INDEX(c2);
43 SET DEBUG_SYNC = 'now SIGNAL go_ahead';
44
45 connection default;
46 --error ER_DUP_ENTRY
47 reap;
48 eval $innodb_metrics_select;
49
50 connection con1;
51 SET @saved_debug_dbug = @@SESSION.debug_dbug;
52 SET DEBUG_DBUG = '+d,innodb_OOM_prepare_inplace_alter';
53 --error ER_OUT_OF_RESOURCES
54 ALTER TABLE t1 ADD UNIQUE INDEX(c2);
55 SET DEBUG_DBUG = @saved_debug_dbug;
56 SET DEBUG_DBUG = '+d,innodb_OOM_inplace_alter';
57 --error ER_OUT_OF_RESOURCES
58 CREATE UNIQUE INDEX c2 ON t1(c2);
59 SET DEBUG_DBUG = @saved_debug_dbug;
60 SET DEBUG_DBUG = '+d,innodb_OOM_prepare_add_index';
61 --error ER_OUT_OF_RESOURCES
62 ALTER TABLE t1 ADD KEY(c2), ADD KEY c3_10(c3(10)), ADD KEY c3_c2(c3(4),c2);
63 SET DEBUG_DBUG = @saved_debug_dbug;
64 CREATE UNIQUE INDEX c2 ON t1(c2);
65 DROP INDEX c2 ON t1;
66
67 connection default;
68 SHOW CREATE TABLE t1;
69 # Insert a duplicate entry (4) for the upcoming UNIQUE INDEX(c2).
70 BEGIN;
71 INSERT INTO t1 VALUES(7,4,2);
72
73 connection con1;
74 # This DEBUG_SYNC should not kick in yet, because the duplicate key will be
75 # detected before we get a chance to apply the online log.
76 SET DEBUG_SYNC = 'row_log_apply_before SIGNAL scanned WAIT_FOR rollback_done';
77 # This will be a lock wait timeout on the meta-data lock,
78 # because the transaction inserting (7,4,2) is still active.
79 --error ER_LOCK_WAIT_TIMEOUT
80 ALTER TABLE t1 ADD UNIQUE INDEX(c2);
81 connection default;
82 COMMIT;
83 connection con1;
84 --error ER_DUP_ENTRY
85 ALTER TABLE t1 ADD UNIQUE INDEX(c2);
86 connection default;
87 DELETE FROM t1 WHERE c1 = 7;
88 connection con1;
89 # ADD FOREIGN KEY is not supported in-place
90 --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
91 ALTER TABLE t1 ADD FOREIGN KEY(c2) REFERENCES t1(c2), ALGORITHM = INPLACE;
92 # The previous DEBUG_SYNC should be ignored, because an exclusive lock
93 # has been requested and the online log is not being allocated.
94 ALTER TABLE t1 ADD UNIQUE INDEX(c2), LOCK = EXCLUSIVE, ALGORITHM = INPLACE;
95 DROP INDEX c2 ON t1;
96 # Now the previous DEBUG_SYNC should kick in.
97 --send
98 ALTER TABLE t1 ADD UNIQUE INDEX(c2);
99 connection default;
100 SET DEBUG_SYNC = 'now WAIT_FOR scanned';
101 eval $innodb_metrics_select;
102
103 # Insert a duplicate entry (4) for the already started UNIQUE INDEX(c2).
104 BEGIN;
105 INSERT INTO t1 VALUES(7,4,2);
106 COMMIT;
107 DELETE FROM t1 where c1 = 7;
108 SET DEBUG_SYNC = 'now SIGNAL rollback_done';
109
110 connection con1;
111 # Because the modification log will be applied in order, there will be
112 # a duplicate key error on the (7,4,2) even though we roll it back.
113 --error ER_DUP_ENTRY
114 reap;
115 # Now, create the index without any concurrent DML, while no duplicate exists.
116 SET DEBUG_SYNC = 'row_log_apply_after SIGNAL created WAIT_FOR dml_done';
117 --send
118 ALTER TABLE t1 ADD UNIQUE INDEX(c2);
119 connection default;
120 SET DEBUG_SYNC = 'now WAIT_FOR created';
121 # At this point, the index has been created inside InnoDB but not yet
122 # in the MySQL data dictionary.
123 eval $innodb_metrics_select;
124 # A duplicate key error should now be triggered by InnoDB, but reported
125 # by the ALTER TABLE because the index does not 'officially' exist yet.
126 INSERT INTO t1 VALUES(6,3,1);
127 SET DEBUG_SYNC = 'now SIGNAL dml_done';
128 connection con1;
129 # This is due to the duplicate entry (6,3,1).
130 --error ER_DUP_ENTRY
131 reap;
132 DELETE FROM t1 WHERE c1=6;
133 ALTER TABLE t1 ADD UNIQUE INDEX(c2);
134 eval $innodb_metrics_select;
135
136 connection default;
137 --error ER_DUP_ENTRY
138 INSERT INTO t1 VALUES(6,3,1);
139 --error ER_DUP_ENTRY
140 INSERT INTO t1 VALUES(7,4,2);
141 ALTER TABLE t1 STATS_PERSISTENT=1;
142 ANALYZE TABLE t1;
143 # Purge may or may not have cleaned up the DELETE FROM t1 WHERE c1 = 7;
144 UPDATE mysql.innodb_index_stats SET stat_value = 5
145 WHERE database_name = 'test' AND table_name= 't1' AND index_name = 'PRIMARY'
146 AND stat_value = 6;
147 --replace_column 4 LAST_UPDATE
148 SELECT * FROM mysql.innodb_index_stats WHERE table_name IN ('t1');
149 CREATE TABLE t1_c2_stats SELECT * FROM mysql.innodb_index_stats
150 WHERE database_name = 'test' AND table_name = 't1' and index_name = 'c2';
151 # in Embedded mode (./mtr --embedded-server) the t1_c2_stats table gets
152 # created in MyISAM format by default even if we set
153 # default_storage_engine='innodb'
154 ALTER TABLE t1_c2_stats ENGINE=INNODB;
155 DROP INDEX c2 ON t1;
156 ANALYZE TABLE t1_c2_stats;
157 --replace_column 4 LAST_UPDATE
158 SELECT * FROM mysql.innodb_index_stats WHERE table_name IN ('t1', 't1_c2_stats');
159
160 connection con1;
161 let $ID= `SELECT @id := CONNECTION_ID()`;
162 --error ER_QUERY_INTERRUPTED
163 KILL QUERY @id;
164
165 SET GLOBAL innodb_max_purge_lag_wait=0;
166 SET DEBUG_SYNC = 'row_log_apply_before SIGNAL c2d_created WAIT_FOR kill_done';
167 --send
168 CREATE INDEX c2d ON t1(c2);
169
170 connection default;
171 SET DEBUG_SYNC = 'now WAIT_FOR c2d_created';
172 eval $innodb_metrics_select;
173 let $ignore= `SELECT @id := $ID`;
174 KILL QUERY @id;
175 SET DEBUG_SYNC = 'now SIGNAL kill_done';
176
177 connection con1;
178 --error ER_QUERY_INTERRUPTED
179 reap;
180 eval $innodb_metrics_select;
181
182 connection default;
183 CHECK TABLE t1;
184 INSERT INTO t1 SELECT 5 + c1, c2, c3 FROM t1;
185 INSERT INTO t1 SELECT 10 + c1, c2, c3 FROM t1;
186 INSERT INTO t1 SELECT 20 + c1, c2, c3 FROM t1;
187 INSERT INTO t1 SELECT 40 + c1, c2, c3 FROM t1;
188 # Purge may or may not have cleaned up the DELETE FROM t1 WHERE c1 = 7;
189 --replace_result 81 80
190 EXPLAIN SELECT COUNT(*) FROM t1 WHERE c2 > 3;
191 ANALYZE TABLE t1;
192
193 connection con1;
194 # Forge some statistics for c2d, and see that they will be used
195 UPDATE t1_c2_stats SET index_name = 'c2d';
196 # Fake the statistics. The cardinality should be 5,80.
197 UPDATE t1_c2_stats SET stat_value = 2 WHERE stat_name = 'n_diff_pfx01';
198 INSERT INTO t1_c2_stats
199 SELECT database_name, table_name, index_name, last_update, 'n_diff_pfx02', 80,
200 sample_size, 'c2,c1' FROM t1_c2_stats
201 WHERE stat_name = 'n_diff_pfx01' AND stat_description = 'c2';
202 INSERT INTO mysql.innodb_index_stats SELECT * FROM t1_c2_stats;
203 DROP TABLE t1_c2_stats;
204
205 CREATE INDEX c2d ON t1(c2);
206 # This should show the newly calculated stats by CREATE INDEX above,
207 # not the faked cardinality=4 for c2d(c2).
208 # Purge may or may not have cleaned up the DELETE FROM t1 WHERE c1 = 7;
209 --replace_result 81 80
210 SHOW INDEX FROM t1;
211 EXPLAIN SELECT COUNT(*) FROM t1 WHERE c2 > 3;
212
213 SHOW CREATE TABLE t1;
214
215 connection default;
216 SET @merge_encrypt_0=
217 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
218 WHERE variable_name = 'innodb_encryption_n_merge_blocks_encrypted');
219 SET @merge_decrypt_0=
220 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
221 WHERE variable_name = 'innodb_encryption_n_merge_blocks_decrypted');
222 SET @rowlog_encrypt_0=
223 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
224 WHERE variable_name = 'innodb_encryption_n_rowlog_blocks_encrypted');
225 connection con1;
226
227 # Exceed the configured innodb_online_alter_log_max_size.
228 # The actual limit is a multiple of innodb_sort_buf_size,
229 # because that is the size of the in-memory log buffers.
230 SET DEBUG_SYNC = 'row_log_apply_before SIGNAL c2e_created WAIT_FOR dml2_done';
231 # Ensure that the ALTER TABLE will be executed even with some concurrent DML.
232 SET lock_wait_timeout = 10;
233 --send
234 ALTER TABLE t1 CHANGE c2 c22 INT, DROP INDEX c2d, ADD INDEX c2e(c22, c3(10)), ALGORITHM = NOCOPY;
235
236 # Generate some log (delete-mark, delete-unmark, insert etc.)
237 # while the index creation is blocked. Some of this may run
238 # in parallel with the clustered index scan.
239 connection default;
240 INSERT INTO t1 SELECT 80 + c1, c2, c3 FROM t1;
241 INSERT INTO t1 SELECT 160 + c1, c2, c3 FROM t1;
242 #UPDATE t1 SET c2 = c2 + 1;
243 SET DEBUG_SYNC = 'now WAIT_FOR c2e_created';
244 # At this point, the clustered index scan must have completed,
245 # but the modification log keeps accumulating due to the DEBUG_SYNC.
246 eval $innodb_metrics_select;
247 let $c= 8;
248 while ($c)
249 {
250 UPDATE t1 SET c2 = c2 + 1;
251 UPDATE t1 SET c2 = c2 + 2;
252 dec $c;
253 }
254 # Incomplete index c2e should exist until the DDL thread notices the overflow.
255 # (The output below strips TEMP_INDEX_PREFIX from the name.)
256 eval $innodb_metrics_select;
257 SELECT sf.name, sf.pos FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES si
258 INNER JOIN INFORMATION_SCHEMA.INNODB_SYS_FIELDS sf
259 ON si.index_id = sf.index_id WHERE si.name = '?c2e';
260
261 SET @merge_encrypt_1=
262 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
263 WHERE variable_name = 'innodb_encryption_n_merge_blocks_encrypted');
264 SET @merge_decrypt_1=
265 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
266 WHERE variable_name = 'innodb_encryption_n_merge_blocks_decrypted');
267 SET @rowlog_encrypt_1=
268 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
269 WHERE variable_name = 'innodb_encryption_n_rowlog_blocks_encrypted');
270
271 SELECT
272 (@merge_encrypt_1-@merge_encrypt_0)-
273 (@merge_decrypt_1-@merge_decrypt_0) as sort_balance,
274 @merge_encrypt_1>@merge_encrypt_0, @merge_decrypt_1>@merge_decrypt_0,
275 @rowlog_encrypt_1>@rowlog_encrypt_0;
276
277 # Release con1.
278 SET DEBUG_SYNC = 'now SIGNAL dml2_done';
279
280 connection con1;
281 # If the following fails with the wrong error, it probably means that
282 # you should rerun with a larger mtr --debug-sync-timeout.
283 --error ER_INNODB_ONLINE_LOG_TOO_BIG
284 reap;
285 # The index c2e should have been dropped from the data dictionary
286 # when the above error was noticed. It should still exist in the
287 # cache with index->online_status = ONLINE_INDEX_ABORTED_DROPPED.
288 eval $innodb_metrics_select;
289 SELECT sf.name, sf.pos FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES si
290 INNER JOIN INFORMATION_SCHEMA.INNODB_SYS_FIELDS sf
291 ON si.index_id = sf.index_id WHERE si.name = 'c2e';
292
293 # ddl_background_drop_indexes = 1 here, because the incomplete index c2e still
294 # exists in the InnoDB data dictionary cache.
295 eval $innodb_metrics_select;
296
297 connection default;
298
299 ALTER TABLE t1 COMMENT 'testing if c2e will be dropped';
300
301 # Check that the 'zombie' index c2e was dropped.
302 eval $innodb_metrics_select;
303
304 SET @merge_encrypt_1=
305 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
306 WHERE variable_name = 'innodb_encryption_n_merge_blocks_encrypted');
307 SET @merge_decrypt_1=
308 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
309 WHERE variable_name = 'innodb_encryption_n_merge_blocks_decrypted');
310 SET @rowlog_encrypt_1=
311 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
312 WHERE variable_name = 'innodb_encryption_n_rowlog_blocks_encrypted');
313 SET @rowlog_decrypt_1=
314 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
315 WHERE variable_name = 'innodb_encryption_n_rowlog_blocks_decrypted');
316
317 connection con1;
318 # Accumulate and apply some modification log.
319 SET DEBUG_SYNC = 'row_log_apply_before SIGNAL c2f_created WAIT_FOR dml3_done';
320 --send
321 ALTER TABLE t1 ADD INDEX c2f(c22f), CHANGE c2 c22f INT;
322
323 connection default;
324 SET DEBUG_SYNC = 'now WAIT_FOR c2f_created';
325 # Generate some log (delete-mark, delete-unmark, insert etc.)
326 eval $innodb_metrics_select;
327 let $c= 6;
328 while ($c)
329 {
330 BEGIN;
331 INSERT INTO t1 SELECT 320 + c1, c2, c3 FROM t1 WHERE c1 > 160;
332 DELETE FROM t1 WHERE c1 > 320;
333 COMMIT;
334 BEGIN;
335 UPDATE t1 SET c2 = c2 + 1;
336 COMMIT;
337 dec $c;
338 }
339 eval $innodb_metrics_select;
340 # Release con1.
341 SET DEBUG_SYNC = 'now SIGNAL dml3_done';
342
343 connection con1;
344 reap;
345
346 eval $innodb_metrics_select;
347
348 connection default;
349
350 SET @merge_encrypt_2=
351 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
352 WHERE variable_name = 'innodb_encryption_n_merge_blocks_encrypted');
353 SET @merge_decrypt_2=
354 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
355 WHERE variable_name = 'innodb_encryption_n_merge_blocks_decrypted');
356 SET @rowlog_encrypt_2=
357 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
358 WHERE variable_name = 'innodb_encryption_n_rowlog_blocks_encrypted');
359 SET @rowlog_decrypt_2=
360 (SELECT CAST(variable_value AS INTEGER) FROM information_schema.global_status
361 WHERE variable_name = 'innodb_encryption_n_rowlog_blocks_decrypted');
362
363 SELECT
364 (@merge_encrypt_2-@merge_encrypt_1)-
365 (@merge_decrypt_2-@merge_decrypt_1) as sort_balance,
366 (@rowlog_encrypt_2-@rowlog_encrypt_1)-
367 (@rowlog_decrypt_2-@rowlog_decrypt_1) as log_balance;
368 SELECT
369 @merge_encrypt_2-@merge_encrypt_1>0 as sort_encrypted,
370 @merge_decrypt_2-@merge_decrypt_1>0 as sort_decrypted,
371 @rowlog_encrypt_2-@rowlog_encrypt_1>0 as log_encrypted,
372 @rowlog_decrypt_2-@rowlog_decrypt_1>0 as log_decrypted;
373
374 connection con1;
375 SELECT COUNT(c22f) FROM t1;
376 CHECK TABLE t1;
377 # Avoid a strange DEBUG_SYNC timeout on c3p5_created.
378 SET GLOBAL innodb_max_purge_lag_wait=0;
379
380 # Create a column prefix index.
381 --error ER_DUP_ENTRY
382 ALTER TABLE t1 ADD UNIQUE INDEX c3p5(c3(5));
383 UPDATE t1 SET c3 = NULL WHERE c3 = '';
384 SET lock_wait_timeout = 1;
385 SET DEBUG_SYNC = 'row_log_apply_before SIGNAL c3p5_created WAIT_FOR ins_done';
386 --send
387 ALTER TABLE t1 ADD UNIQUE INDEX c3p5(c3(5));
388
389 connection default;
390 SET DEBUG_SYNC = 'now WAIT_FOR c3p5_created';
391
392 # Check that the index was created.
393 SELECT sf.name, sf.pos FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES si
394 INNER JOIN INFORMATION_SCHEMA.INNODB_SYS_FIELDS sf
395 ON si.index_id = sf.index_id WHERE si.name = '?c3p5';
396
397 SET DEBUG_SYNC = 'ib_after_row_insert SIGNAL ins_done WAIT_FOR ddl_timed_out';
398 --send
399 INSERT INTO t1 VALUES(347,33101,NULL);
400
401 connection con1;
402 --error ER_LOCK_WAIT_TIMEOUT
403 reap;
404 SET DEBUG_SYNC = 'now SIGNAL ddl_timed_out';
405
406 # InnoDB should have cleaned up the index c3p5 from the data dictionary,
407 # but not yet from the dictionary cache.
408 SELECT sf.name, sf.pos FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES si
409 INNER JOIN INFORMATION_SCHEMA.INNODB_SYS_FIELDS sf
410 ON si.index_id = sf.index_id WHERE si.name = 'c3p5';
411 eval $innodb_metrics_select;
412
413 connection default;
414 reap;
415 # Index c3p5 should still exist in the data dictionary cache.
416 eval $innodb_metrics_select;
417
418 --disable_parsing
419 # Temporarily disabled by fix for bug#14213236. Should be either
420 # removed or updated to take into account that locking for IMPORT/
421 # DISCARD TABLESPACE happens on MDL layer. New test case is added
422 # to validate this at MDL layer(i_main.alter_table.test)
423
424 SET DEBUG_SYNC = 'row_log_apply_before SIGNAL c2g_created WAIT_FOR dml4_done';
425 # The lock upgrade at the end of the ALTER will conflict with the DISCARD.
426 SET lock_wait_timeout = 1;
427 --send
428 ALTER TABLE t1 DROP INDEX c2f, ADD INDEX c2g(c22f);
429
430 connection con1;
431 SET DEBUG_SYNC = 'now WAIT_FOR c2g_created';
432
433 connect (con2,localhost,root,,);
434
435 # This will conflict with the ALTER in connection default, above.
436 SET lock_wait_timeout = 10;
437 --send
438 ALTER TABLE t1 DISCARD TABLESPACE;
439
440 connection con1;
441 let $wait_condition=
442 SELECT COUNT(*) = 1 FROM information_schema.processlist
443 WHERE state = 'Waiting for table level lock' and
444 info = 'ALTER TABLE t1 DISCARD TABLESPACE';
445 --source include/wait_condition.inc
446
447 SET DEBUG_SYNC = 'now SIGNAL dml4_done';
448 disconnect con1;
449 connection con2;
450 reap;
451 disconnect con2;
452 connection default;
453 --error ER_LOCK_WAIT_TIMEOUT
454 reap;
455 --enable_parsing
456 #remove below con1 disconnect if above test case is enabled
457 connection default;
458
459 SHOW CREATE TABLE t1;
460 ALTER TABLE t1 DROP INDEX c2d, DROP INDEX c2f;
461 # The ALTER TABLE should have cleaned up c3p5 from the cache.
462 eval $innodb_metrics_select;
463 ALTER TABLE t1 ADD INDEX c2h(c22f), ALGORITHM = INPLACE;
464 --error ER_DUP_KEYNAME
465 ALTER TABLE t1 ADD INDEX c2h(c22f), ALGORITHM = COPY;
466
467 SET DEBUG_SYNC = 'RESET';
468 SET GLOBAL innodb_monitor_disable = module_ddl;
469
470 DROP TABLE t1;
471
472 --echo #
473 --echo # MDEV-13205 assertion !dict_index_is_online_ddl(index) upon ALTER TABLE
474 --echo #
475 CREATE TABLE t1 (c VARCHAR(64)) ENGINE=InnoDB;
476 INSERT INTO t1 VALUES('foo');
477 SET DEBUG_SYNC = 'row_log_apply_before SIGNAL t1u_created WAIT_FOR dup_done';
478 send ALTER TABLE t1 ADD UNIQUE(c);
479
480 connection con1;
481 SET DEBUG_SYNC = 'now WAIT_FOR t1u_created';
482 INSERT INTO t1 VALUES('bar'),('bar');
483 SET DEBUG_SYNC = 'now SIGNAL dup_done';
484
485 connection default;
486 --error ER_DUP_ENTRY
487 reap;
488
489 SET DEBUG_SYNC = 'RESET';
490 disconnect con1;
491
492 CREATE TABLE t2 (c VARCHAR(64)) ENGINE=InnoDB;
493 --error ER_CANT_CREATE_TABLE
494 ALTER TABLE t2 ADD FOREIGN KEY (c) REFERENCES t1 (c);
495 DROP TABLE t2,t1;
496
497 CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB;
498 INSERT INTO t1 VALUES(0,0);
499
500 connect (con1,localhost,root,,);
501 SET DEBUG_SYNC = 'row_log_apply_before SIGNAL created WAIT_FOR inserted';
502 send ALTER TABLE t1 ADD INDEX(b);
503
504 connection default;
505 SET DEBUG_SYNC = 'now WAIT_FOR created';
506 BEGIN;
507 INSERT INTO t1 VALUES(1,1);
508 ROLLBACK;
509 SET DEBUG_SYNC = 'now SIGNAL inserted';
510
511 connection con1;
512 reap;
513
514 connection default;
515 SELECT * FROM t1;
516 CHECK TABLE t1;
517 DROP TABLE t1;
518
519 --echo #
520 --echo # MDEV-36281 DML aborts during online virtual index
521 --echo #
522 CREATE TABLE t1(f1 INT NOT NULL PRIMARY KEY, f2 INT NOT NULL,
523 f3 INT NOT NULL, f4 INT AS (f3) VIRTUAL,
524 f5 INT AS (f1) VIRTUAL, INDEX(f4))ENGINE=InnoDB;
525 INSERT INTO t1(f1, f2, f3) VALUES(1, 2, 3);
526 SET DEBUG_SYNC = 'innodb_inplace_alter_table_enter SIGNAL dml_start WAIT_FOR dml_finish';
527 send ALTER TABLE t1 ADD INDEX v1(f5, f2, f4), ADD INDEX v2(f3, f5);
528
529 connection con1;
530 set DEBUG_SYNC="now WAIT_FOR dml_start";
531 UPDATE t1 SET f3= f3 + 1;
532 set DEBUG_SYNC="now SIGNAL dml_finish";
533
534 disconnect con1;
535 connection default;
536 reap;
537 CHECK TABLE t1 EXTENDED;
538 SELECT f5, f2, f4 FROM t1 USE INDEX(v1);
539 SELECT f3, f5 FROM t1 USE INDEX(v2);
540 DROP TABLE t1;
541
542 SET DEBUG_SYNC = 'RESET';
543
544 # Check that all connections opened by test cases in this file are really
545 # gone so execution of other tests won't be affected by their presence.
546 --source include/wait_until_count_sessions.inc
547
548 --disable_warnings
549 SET GLOBAL innodb_monitor_enable = default;
550 SET GLOBAL innodb_monitor_disable = default;
551 --enable_warnings