Bug #34684 rpl_sporadic_master test fails with Falcon
Submitted: 20 Feb 2008 11:48 Modified: 9 Feb 2009 10:00
Reporter: Philip Stoev Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:6.0.4 OS:Any
Assigned to: Serge Kozlov CPU Architecture:Any

[20 Feb 2008 11:48] Philip Stoev
Description:
The rpl_sporadic_master test fails when run under the Falcon engine -- Records remain visible even after a TRUNCATE TABLE.

I am setting this to a replication bug because this test tests replication, which appears to fail.

How to repeat:
$ perl mysql-test-run.pl --mysqld=--default-storage-engine=falcon rpl_sporadic_master 

rpl.rpl_sporadic_master        [ fail ]

--- /build/6.0.4/mysql-test/suite/rpl/r/rpl_sporadic_master.result      2008-02-13 19:58:48.000000000 +0300
+++ /build/6.0.4/mysql-test/suite/rpl/r/rpl_sporadic_master.reject      2008-02-18 16:52:22.000000000 +0300
@@ -17,6 +17,12 @@
 insert into t1 values (10),(NULL),(NULL),(NULL),(NULL),(NULL);
 select * from t1 ORDER BY n;
 n
+1
+2
+4
+5
+6
+7
 10
 11
 12

$ perl mysql-test-run.pl --mysqld=--default-storage-engine=innodb rpl_sporadic_master --mysqld=--innodb

rpl.rpl_sporadic_master        [ pass ]
[20 Feb 2008 11:59] MySQL Verification Team
Thank you for the bug report. Verified as described.