1 # BUG #36763: TRUNCATE TABLE fails to replicate when stmt-based
2 # binlogging is not supported.
4 # This should always be logged as a statement, even when executed as a
7 # $before_truncate A statement to execute (just) before issuing the
11 eval CREATE TABLE t1 (a INT) ENGINE=$engine;
12 eval CREATE TABLE t2 (a INT) ENGINE=$engine;
13 INSERT INTO t2 VALUES (1),(2),(3);
14 let $binlog_start = query_get_value("SHOW MASTER STATUS", Position, 1);
15 if (`select length('$before_truncate') > 0`) {
16 eval $before_truncate;
18 --echo **** Truncate of empty table shall be logged
21 if (`select length('$before_truncate') > 0`) {
22 eval $before_truncate;
25 source include/show_binlog_events.inc;