| Bug #54846 | main.lowercase_table2 on Mac OSX | ||
|---|---|---|---|
| Submitted: | 28 Jun 2010 6:09 | Modified: | 26 Jul 2010 15:32 |
| Reporter: | Alexander Nozdrin | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Tests: Server | Severity: | S7 (Test Cases) |
| Version: | M3 (Celosia), M4 (Dahlia) | OS: | MacOS |
| Assigned to: | Magne Mæhre | CPU Architecture: | Any |
| Tags: | pb2, test failure | ||
[28 Jun 2010 9:26]
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/112326 3080 Magne Mahre 2010-06-28 Bug#54846 main.lowercase_table2 on Mac OSX This bug is a consequence of WL#5349, as the default storage engine was changed. The fix was to explicitly add an ENGINE clause to a CREATE TABLE statement, to ensure that we test case preservement on MyISAM.
[28 Jun 2010 10:29]
Magne Mæhre
Pushed to mysql-trunk-bugfixing (rev. 3080)
[23 Jul 2010 12:23]
Bugs System
Pushed into mysql-trunk 5.5.6-m3 (revid:alik@sun.com-20100723121820-jryu2fuw3pc53q9w) (version source revid:vasil.dimov@oracle.com-20100531152341-x2d4hma644icamh1) (merge vers: 5.5.5-m3) (pib:18)
[23 Jul 2010 12:30]
Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100723121929-90e9zemk3jkr2ocy) (version source revid:vasil.dimov@oracle.com-20100531152341-x2d4hma644icamh1) (pib:18)
[26 Jul 2010 15:32]
Paul DuBois
Changes to test case. No changelog entry needed.
Description: main.lowercase_table2 started to fail on Mac OSX with the symptoms as follows: ------------------------------------------------------ main.lowercase_table2 [ fail ] Test ended at 2010-06-24 12:56:57 CURRENT_TEST: main.lowercase_table2 --- /Volumes/hd2/test/sb_1-1968546-1277371580.87/mysql-5.5.6-m3-osx10.5-x86-test/mysql-test/r/lowercase_table2.result 2010-06-23 12:04:22.000000000 +0300 +++ /Volumes/hd2/test/sb_1-1968546-1277371580.87/mysql-5.5.6-m3-osx10.5-x86-test/mysql-test/r/lowercase_table2.reject 2010-06-24 13:56:57.000000000 +0300 @@ -14,7 +14,7 @@ Table Create Table T1 CREATE TABLE `T1` ( `a` int(11) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=InnoDB DEFAULT CHARSET=latin1 RENAME TABLE T1 TO T2; SHOW TABLES LIKE "T2"; Tables_in_test (T2) mysqltest: Result content mismatch ------------------------------------------------------ Probably that happened due to WL#5349. How to repeat: Check out PB.