Bug #12692 TRUNCATE TABLE mysqltest1.t7 is not being replicated using rbr.

• Submitted: 19 Aug 2005 22:32
• Modified: 22 Nov 2005 15:09
• Reporter: Jonathan Miller
• Status: Closed
• Category: MySQL Server: Replication
• Severity: S3 (Non-critical)
• Version: 5.0-wl1012
• OS: Linux (Linux)
• Assigned to: Guilhem Bichot
• CPU Architecture: Any

[19 Aug 2005 22:32] Jonathan Miller

Description:
Taken from rpl_ddl.test (now known as rpl_row_ddl.test)
let $my_stmt= TRUNCATE TABLE mysqltest1.t7;
let $my_master_commit= true;
let $my_slave_commit= true;
--source include/rpl_stmt_seq.inc
SELECT * FROM mysqltest1.t7;
connection slave;
--disable_query_log
SELECT '-------- switch to slave --------' as "";
--enable_query_log
SELECT * FROM mysqltest1.t7;
connection master;
--disable_query_log
SELECT '-------- switch to master -------' as "";
--enable_query_log

********* RBR results ***********************

+ -------- switch to master -------
+ SELECT * FROM mysqltest1.t7;
+ f1
+
+ -------- switch to slave --------
+ SELECT * FROM mysqltest1.t7;
+ f1
+ 0
******************** STM  based results
+ -------- switch to master -------
+ SELECT * FROM mysqltest1.t7;
+ f1
+
+ -------- switch to slave --------
+ SELECT * FROM mysqltest1.t7;
+ f1
+

How to repeat:
see above

[22 Nov 2005 15:09] Guilhem Bichot

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

This was fixed previously: the content of rpl_row_ddl.result shows that TRUNCATE replicates ok in RBR:
-------- switch to master -------
SELECT * FROM mysqltest1.t7;
f1

-------- switch to slave --------
SELECT * FROM mysqltest1.t7;
f1
just as in SBR.