| 1 |
CREATE TABLE t (a INT PRIMARY KEY, c TEXT) ENGINE=InnoDB; |
| 2 |
CREATE TABLE u (a INT PRIMARY KEY, b INT, c INT NOT NULL) ENGINE=InnoDB; |
| 3 |
INSERT INTO t VALUES (1,'aa'); |
| 4 |
BEGIN; |
| 5 |
INSERT INTO u SET a=1, c=1; |
| 6 |
INSERT INTO u SELECT a+1,NULL,a+1 FROM u; |
| 7 |
INSERT INTO u SELECT a+2,NULL,a+2 FROM u; |
| 8 |
INSERT INTO u SELECT a+4,NULL,a+4 FROM u; |
| 9 |
INSERT INTO u SELECT a+8,NULL,a+8 FROM u; |
| 10 |
INSERT INTO u SELECT a+16,NULL,a+16 FROM u; |
| 11 |
INSERT INTO u SELECT a+32,NULL,a+32 FROM u; |
| 12 |
INSERT INTO u SELECT a+64,NULL,a+64 FROM u; |
| 13 |
INSERT INTO u SELECT a+128,NULL,a+64 FROM u; |
| 14 |
INSERT INTO u SELECT a+256,NULL,a+64 FROM u; |
| 15 |
COMMIT; |
| 16 |
BEGIN; |
| 17 |
DELETE FROM u; |
| 18 |
SET DEBUG_SYNC='row_log_apply_before SIGNAL created_u WAIT_FOR dml_done_u'; |
| 19 |
ALTER TABLE u ADD INDEX (c); |
| 20 |
COMMIT; |
| 21 |
SET DEBUG_SYNC='now WAIT_FOR created_u'; |
| 22 |
SELECT state FROM information_schema.processlist |
| 23 |
WHERE info='ALTER TABLE u ADD INDEX (c)'; |
| 24 |
state |
| 25 |
debug sync point: row_log_apply_before |
| 26 |
Warnings: |
| 27 |
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead |
| 28 |
SET DEBUG_SYNC='row_log_apply_before SIGNAL created_t WAIT_FOR dml_done_t'; |
| 29 |
CREATE INDEX c1 ON t (c(1)); |
| 30 |
SET DEBUG_SYNC='now WAIT_FOR created_t'; |
| 31 |
UPDATE t SET c='ab'; |
| 32 |
SET DEBUG_SYNC='now SIGNAL dml_done_u'; |
| 33 |
SET DEBUG_SYNC='now SIGNAL dml_done_t'; |
| 34 |
SET DEBUG_SYNC='RESET'; |
| 35 |
DROP TABLE t,u; |