Percona Server moved to https://jira.percona.com/projects/PS

  1. Bug #1208371
  2. Comment #5

Comment 5 for bug 1208371

Revision history for this message
Vlad Lesin (vlad-lesin) wrote : Re: Revert our fixes for bug 1049871 and bug 1175519

The bug #1049871 is not fixed as there are multiple failed cases when running rpl_mdev382.

The bug #1175519 is fixed but with bug. I wrote mtr test to illustrate the bug and attached the test files to this comment. Just unpack the test files into mysql-5.5.33 source directory and run "./mtr rpl_bug-16753869". Here is the difference between original result and generated one:

--- /home/vlesin/src/work/tmp/mysql-5.5.33/mysql-test/suite/rpl/r/rpl_bug-16753869.result 2013-08-26 14:16:25.816554708 +0300
+++ /home/vlesin/src/work/tmp/mysql-5.5.33/mysql-test/suite/rpl/r/rpl_bug-16753869.reject 2013-08-26 14:16:39.724554040 +0300
@@ -18,7 +18,7 @@
 /*!*/;
 use `test`/*!*/;
 SET TIMESTAMP=1000000000/*!*/;
-LOAD DATA LOCAL INFILE '<name>' INTO TABLE `t1` FIELDS TERMINATED BY ',' ENCLOSED BY '\'' ESCAPED BY '\\' LINES TERMINATED BY '\n' (@`a1`, @`b1`)
SET `a`= @`a1`, `b`= @`b1`
+LOAD DATA LOCAL INFILE '<name>' INTO TABLE `t1` FIELDS TERMINATED BY ',' ENCLOSED BY '\'' ESCAPED BY '\\' LINES TERMINATED BY '\n' (@`a1`, @`b1`)
SET `a`= @`a1`, `b` = @`b1`, `b`= @`b1`
 /*!*/;
 COMMIT/*!*/;
 DELIMITER ;

As it can be seen `b` = @`b1` is repeated twice in "LOAD DATA" statement in binlog.