Bug #59418 parts suite have several failures with --embedded-server
Submitted: 11 Jan 2011 13:56 Modified: 9 Feb 2011 19:24
Reporter: Mattias Jonsson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1+ OS:Any
Assigned to: Mattias Jonsson CPU Architecture:Any

[11 Jan 2011 13:56] Mattias Jonsson
Description:
When running './mtr --suite=parts --embedded-server --force' it fails on at least 8 different tests:

Failing test(s): parts.partition_recover_myisam parts.partition_syntax_myisam parts.partition_special_innodb parts.partition_alter1_1_2_myisam parts.partition_alter1_1_myisam parts.partition_engine_myisam parts.partition_alter1_2_myisam parts.partition_basic_myisam

How to repeat:
perl mysql-test-run.pl --suite=parts --embedded-server --force

Suggested fix:
Fix the tests! I will attach patch.
[11 Jan 2011 14:56] Mattias Jonsson
Proposed patch for this bug, tested on both windows and linux

Attachment: b59418.proposed.diff (application/octet-stream, text), 5.62 KiB.

[11 Jan 2011 15:15] Valeriy Kravchuk
Verified with current mysql-5.5 tree on 32-bit Ubuntu.
[18 Jan 2011 22:59] 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/129112

3551 Mattias Jonsson	2011-01-18
      Bug#59418: parts suite have several failures with --embedded-server
      
      The test were using external tools not available for embedded.
      
      Fixed by rewriting the test to not rely on external tools like the mysql-client
      
      Also fixed some non portable --exec commands and replaced #p# to #P# to pass
      on windows.
[27 Jan 2011 18:08] Horst Hunger
Inserted patches in mysql-5.1 and run partition tests successfully in embedded mode on Linux.
Ready to push.
[28 Jan 2011 14:11] Bugs System
Pushed into mysql-trunk 5.6.2 (revid:mattias.jonsson@oracle.com-20110128135805-3pgrced799kccf9f) (version source revid:mattias.jonsson@oracle.com-20110128135805-3pgrced799kccf9f) (merge vers: 5.6.2) (pib:24)
[28 Jan 2011 14:11] Bugs System
Pushed into mysql-5.5 5.5.10 (revid:mattias.jonsson@oracle.com-20110128123939-vpwx5uyyzu16ma45) (version source revid:mattias.jonsson@oracle.com-20110128122815-wid0zjuqf5h57r18) (merge vers: 5.5.10) (pib:24)
[28 Jan 2011 14:12] Bugs System
Pushed into mysql-5.1 5.1.56 (revid:mattias.jonsson@oracle.com-20110128123739-lyb84h4fdbbouyqg) (version source revid:mattias.jonsson@oracle.com-20110127223917-2gstc26k196fscpe) (merge vers: 5.1.56) (pib:24)
[28 Jan 2011 15:50] Paul DuBois
Changes to test suite. No changelog entry needed.