Debian Codegraph @

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

raw
1 SET DEBUG_SYNC='reset';
2 CREATE TABLE t1 (
3 id INT UNIQUE NOT NULL,
4 a INT,
5 b BLOB,
6 ag INT GENERATED ALWAYS AS (a) VIRTUAL,
7 PRIMARY KEY(id),
8 INDEX bugidx (b(100),a)
9 ) ENGINE=InnoDB;
10 INSERT INTO t1 (id, a, b) VALUES (1001, 1, REPEAT('a', 50001));
11 INSERT INTO t1 (id, a, b) VALUES (1002, 2, REPEAT('b', 50002));
12 SET GLOBAL innodb_purge_stop_now = ON;
13 DELETE FROM t1 WHERE id = 1001;
14 SET DEBUG_SYNC='before_row_ins_upd_pessimistic SIGNAL s1 WAIT_FOR s2 TIMEOUT 10';
15 INSERT INTO t1 (id, a, b) VALUES (1001, 1, REPEAT('z', 60001));
16 SET DEBUG_SYNC='now WAIT_FOR s1';
17 SET GLOBAL innodb_purge_run_now = ON;
18 SET DEBUG_SYNC='now SIGNAL s2';
19 SET DEBUG_SYNC='reset';
20 SET DEBUG_SYNC='reset';
21 drop table t1;
22 CREATE TABLE t1 (
23 id INT UNIQUE NOT NULL,
24 a INT,
25 b BLOB,
26 ag INT GENERATED ALWAYS AS (a) VIRTUAL,
27 PRIMARY KEY(id),
28 INDEX bugidx (b(100),ag)
29 ) ENGINE=InnoDB;
30 INSERT INTO t1 (id, a, b) VALUES (1001, 1, REPEAT('a', 50001));
31 INSERT INTO t1 (id, a, b) VALUES (1002, 2, REPEAT('b', 50002));
32 SET GLOBAL innodb_purge_stop_now = ON;
33 DELETE FROM t1 WHERE id = 1001;
34 SET DEBUG_SYNC='before_row_ins_upd_pessimistic SIGNAL s1 WAIT_FOR s2 TIMEOUT 10';
35 INSERT INTO t1 (id, a, b) VALUES (1001, 1, REPEAT('z', 60001));
36 SET DEBUG_SYNC='now WAIT_FOR s1';
37 SET GLOBAL innodb_purge_run_now = ON;
38 SET DEBUG_SYNC='now SIGNAL s2';
39 SET DEBUG_SYNC='reset';
40 SET DEBUG_SYNC='reset';
41 drop table t1;