| Bug #44605 | The test backup_dbname_lctn2 is failing in backup tree | ||
|---|---|---|---|
| Submitted: | 1 May 2009 14:37 | Modified: | 3 Jun 2009 23:32 |
| Reporter: | Chuck Bell | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Backup | Severity: | S3 (Non-critical) |
| Version: | 6.0.11 | OS: | Any |
| Assigned to: | Jørgen Løland | CPU Architecture: | Any |
[4 May 2009 5:49]
Rafal Somla
Probably explicit sorting of SELECT results would fix this issue.
[4 May 2009 8:40]
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/73274 2800 Jorgen Loland 2009-05-04 BUG#44605 - The test backup_dbname_lctn2 is failing in backup tree The fix for BUG 43220 revealed a bug in this test. The new result file contains the correct content of the restored tables on file systems with only lower case file names. @ mysql-test/suite/backup/r/backup_dbname_lctn1.result Added ordering of selects to make the test deterministic @ mysql-test/suite/backup/r/backup_dbname_lctn2.result Added ordering of selects to make the test deterministic and recorded correct content of restored tables @ mysql-test/suite/backup/t/backup_dbname_lctn1.test Added ordering of selects to make the test deterministic
[5 May 2009 14:24]
Chuck Bell
Patch approved.
[5 May 2009 15:29]
Rafal Somla
Good to push.
[6 May 2009 9:01]
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/73463 2803 Jorgen Loland 2009-05-06 BUG#44605 - The test backup_dbname_lctn2 is failing in backup tree The fix for BUG 43220 revealed a bug in this test. The new result file contains the correct content of the restored tables on file systems with only lower case file names. @ mysql-test/suite/backup/r/backup_dbname_lctn1.result Added ordering of selects to make the test deterministic @ mysql-test/suite/backup/r/backup_dbname_lctn2.result Added ordering of selects to make the test deterministic and recorded correct content of restored tables @ mysql-test/suite/backup/t/backup_dbname_lctn1.test Added ordering of selects to make the test deterministic
[3 Jun 2009 7:15]
Jørgen Løland
Merged to azalea June 2
[3 Jun 2009 23:32]
Paul DuBois
Test case changes. No changelog entry needed.
Description: The backup_dbname_lctn2 test fails with content mismatch on Windows: backup.backup_dbname_lctn2 [ fail ] Test ended at 2009-05-01 09:55:06 CURRENT_TEST: backup.backup_dbname_lctn2 --- c:/source/bzr/mysql-6.0-bug-44265/mysql-test/suite/backup/r/backup_dbname_lc tn2.result 2009-05-01 16:21:33.670101800 +0300 +++ c:\source\bzr\mysql-6.0-bug-44265\mysql-test\suite\backup\r\backup_dbname_lc tn2.reject 2009-05-01 16:55:06.023501800 +0300 @@ -125,6 +125,11 @@ ucase SELECT * FROM UPPER.ucase; a b +U41 1300 +U01 1453 +U00 1000 +U41 1301 +U41 1305 # # Drop the databases # @@ -169,6 +174,11 @@ ucase SELECT * FROM UPPER.ucase; a b +U41 1300 +U01 1453 +U00 1000 +U41 1301 +U41 1305 # # Drop the databases # @@ -205,6 +215,11 @@ ucase SELECT * FROM UPPER.ucase; a b +U41 1300 +U01 1453 +U00 1000 +U41 1301 +U41 1305 # # Verify that BACKUP errors if the same database is written twice, # but with different case mysqltest: Result content mismatch How to repeat: ./mysql-test-run.pl backup_dbame_lctn2 Suggested fix: Unknown. This test did not fail yesterday prior to BUG#43220 patch queued (or during testing/review of the same).