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