| 1 |
CREATE TABLE parent ( |
| 2 |
a INT PRIMARY KEY |
| 3 |
) ENGINE=INNODB; |
| 4 |
CREATE TABLE child ( |
| 5 |
a INT PRIMARY KEY, |
| 6 |
FOREIGN KEY (a) REFERENCES parent(a) ON DELETE CASCADE |
| 7 |
) ENGINE=INNODB; |
| 8 |
INSERT INTO parent VALUES (1); |
| 9 |
INSERT INTO child VALUES (1); |
| 10 |
# restart |
| 11 |
SET SESSION DEBUG='+d,test_upd_stats_if_needed_not_inited'; |
| 12 |
DELETE FROM parent; |
| 13 |
SET SESSION DEBUG='-d,test_upd_stats_if_needed_not_inited'; |
| 14 |
Pattern "test_upd_stats_if_needed_not_inited was executed" found |
| 15 |
DROP TABLE child; |
| 16 |
DROP TABLE parent; |