Debian Codegraph @

mysql-test/suite/innodb/r/innodb-index-online-purge.result

raw
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;