From: Annamalai Gurusami Date: May 23 2012 4:46am Subject: bzr push into mysql-5.5 branch (annamalai.gurusami:3841 to 3842) Bug#12752572 List-Archive: http://lists.mysql.com/commits/143913 X-Bug: 12752572 Message-Id: <201205230446.q4N4kb97024621@acsmt357.oracle.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 3842 Annamalai Gurusami 2012-05-23 After the fix for Bug #12752572, there is a pb2 failure. Fixing it by updating the result file. Because a multi-row insert now reserves the auto increment values before hand, if any explicitly specified auto increment values are there, then some of the reserved values are lost. modified: mysql-test/suite/rpl/r/rpl_trigger.result 3841 Annamalai Gurusami 2012-05-21 [merge] Merge from mysql-5.1 to mysql-5.5 modified: sql/handler.cc === modified file 'mysql-test/suite/rpl/r/rpl_trigger.result' --- a/mysql-test/suite/rpl/r/rpl_trigger.result revid:annamalai.gurusami@stripped +++ b/mysql-test/suite/rpl/r/rpl_trigger.result revid:annamalai.gurusami@stripped @@ -29,7 +29,7 @@ a b 1 2 3 0 4 0 -5 0 +6 0 500 0 select a,name, old_a, old_b, truncate(rand_value,4) from t3; a name old_a old_b truncate(rand_value,4) @@ -39,7 +39,7 @@ a name old_a old_b truncate(rand_value,4 103 t2 1 2 0.9164 104 t2 3 0 0.8826 105 t2 4 0 0.6635 -106 t2 5 0 0.6699 +106 t2 6 0 0.6699 107 t2 500 0 0.3593 --- On slave -- @@ -52,7 +52,7 @@ a b 1 2 3 0 4 0 -5 0 +6 0 500 0 select a,name, old_a, old_b, truncate(rand_value,4) from t3; a name old_a old_b truncate(rand_value,4) @@ -62,7 +62,7 @@ a name old_a old_b truncate(rand_value,4 103 t2 1 2 0.9164 104 t2 3 0 0.8826 105 t2 4 0 0.6635 -106 t2 5 0 0.6699 +106 t2 6 0 0.6699 107 t2 500 0 0.3593 drop table t1,t2,t3; select get_lock("bug12480",2); No bundle (reason: useless for push emails).