Bug #40504 Test failure in backup_engines.backup_ptr_objects_row 'innodb'
Submitted: 4 Nov 2008 16:06 Modified: 15 Nov 2008 0:46
Reporter: Øystein Grøvlen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:6.0-bzr OS:Any
Assigned to: Øystein Grøvlen CPU Architecture:Any

[4 Nov 2008 16:06] Øystein Grøvlen
Description:
backup_engines.backup_ptr_objects_row 'innodb' fails due to BUG#40384 with output like:

@@ -175,7 +175,7 @@
 2	Normal Insert2
 3	Normal Insert3
 4	Normal Insert4
-5	Trigger fired from after update of ptr_ob2.t1
+8	Trigger fired from after update of ptr_ob2.t1
 SELECT * FROM ptr_ob1.v1;
 id	b
 11	set1

How to repeat:
./mtr --suite=backup_engines backup_ptr_objects_row

Suggested fix:
Convert multi-row insert statement to single-row insert statements.
[4 Nov 2008 17:09] Valeriy Kravchuk
Thank you for a problem report. Verified just as described with latest 6.0 from bzr.
[4 Nov 2008 21:00] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/57836

2725 oystein.grovlen@sun.com	2008-11-04
      BUG#40504: Test failure in backup_engines.backup_ptr_objects_row 'innodb'
      
      Convert multi-row a insert statement to single-row insert statements as a
      work-around for bug 40384.
[5 Nov 2008 18:22] Chuck Bell
Patch approved.
[7 Nov 2008 8:43] Rafal Somla
Good to push.
[7 Nov 2008 14:00] Øystein Grøvlen
Patch pushed to backup team tree.
(Revision id: oystein.grovlen@sun.com-20081107104048-incl6avk0zx0l13w)
[14 Nov 2008 14:50] Bugs System
Pushed into 6.0.9-alpha  (revid:oystein.grovlen@sun.com-20081104210001-twoi9fj39hhnavfg) (version source revid:jorgen.loland@sun.com-20081114134411-xypyf8wyjc2nm3ly) (pib:5)
[15 Nov 2008 0:46] Paul DuBois
Test case changes. No changelog entry needed.