mysql-test/suite/innodb/r/truncate_crash.result
raw| 1 | FLUSH TABLES; |
| 2 | CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB STATS_PERSISTENT=0; |
| 3 | INSERT INTO t1 VALUES (1),(2); |
| 4 | connect wait,localhost,root,,test; |
| 5 | SET DEBUG_SYNC='before_trx_state_committed_in_memory SIGNAL c WAIT_FOR ever'; |
| 6 | TRUNCATE TABLE t1; |
| 7 | connection default; |
| 8 | SET DEBUG_SYNC='now WAIT_FOR c'; |
| 9 | # restart |
| 10 | disconnect wait; |
| 11 | InnoDB 0 transactions not purged |
| 12 | SELECT COUNT(*) FROM t1; |
| 13 | COUNT(*) |
| 14 | 0 |
| 15 | TRUNCATE TABLE t1; |
| 16 | DROP TABLE t1; |