summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb/t/truncate_restart.test
blob: 60a3d83cd81d0fd6ac70ea24c8452679ba099c80 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
--source include/have_innodb.inc
--source include/have_debug.inc
--source include/have_debug_sync.inc

SET GLOBAL innodb_stats_persistent= ON;
CREATE TABLE t1 (t TEXT) ENGINE=InnoDB STATS_PERSISTENT=1;
--connect (con1,localhost,root,,test)
SET DEBUG_SYNC='ib_trunc_table_trunc_completing SIGNAL committed WAIT_FOR ever';
--send
TRUNCATE TABLE t1;
--connection default
SET DEBUG_SYNC='now WAIT_FOR committed';
--source include/restart_mysqld.inc
--disconnect con1
SELECT COUNT(*) FROM t1;
DROP TABLE t1;