Bug #46933 backup_*_lctn2 tests fail on windows
Submitted: 26 Aug 2009 9:15 Modified: 25 Feb 2010 1:44
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version:mysql-6.0-codebase OS:Windows
Assigned to: Sanjay Manwani CPU Architecture:Any
Tags: experimental, pb2, test failure

[26 Aug 2009 9:15] Alexander Nozdrin
Description:
The following test cases fail on Windows:
  - backup.backup_dbname_lctn2
  - backup.backup_xpfm_compat_backup_lctn2

The test started to fail after push on 2009-Aug-13 in mysql-next-bugfixing.

Symptoms:
-------------------------------------------------------------
backup.backup_dbname_lctn2               [ fail ]
        Test ended at 2009-08-25 10:19:58

CURRENT_TEST: backup.backup_dbname_lctn2
'diff' is not recognized as an internal or external command,
operable program or batch file.
--- G:/pb2/test/sb_1-708217-1251186993.47/mysql-5.4.4-alpha-win-x86_64-test/mysql-test/suite/backup/r/backup_dbname_lctn2.result	2009-08-25 10:44:45.000000000 +0300
+++ G:\pb2\test\sb_1-708217-1251186993.47\mysql-5.4.4-alpha-win-x86_64-test\mysql-test\suite\backup\r\backup_dbname_lctn2.reject	2009-08-25 11:19:58.105145500 +0300
@@ -125,11 +125,6 @@
 ucase
 SELECT * FROM UPPER.ucase ORDER BY b;
 a	b
-U00	1000
-U41	1300
-U41	1301
-U41	1305
-U01	1453
 #
 # Drop the databases
 #
@@ -174,11 +169,6 @@
 ucase
 SELECT * FROM UPPER.ucase ORDER BY b;
 a	b
-U00	1000
-U41	1300
-U41	1301
-U41	1305
-U01	1453
 #
 # Drop the databases
 #
@@ -215,11 +205,6 @@
 ucase
 SELECT * FROM UPPER.ucase ORDER BY b;
 a	b
-U00	1000
-U41	1300
-U41	1301
-U41	1305
-U01	1453
 #
 # Verify that BACKUP errors if the same database is written twice, 
 # but with different case

mysqltest: Result content mismatch
-------------------------------------------------------------
backup.backup_xpfm_compat_backup_lctn2   [ fail ]  timeout after 900 seconds
        Test ended at 2009-08-25 10:37:28
-------------------------------------------------------------

How to repeat:
XRef2: http://pb2.norway.sun.com/web.py?template=mysql_show_test_failure&test_failure_id=2287708&...

http://pb2.norway.sun.com/web.py?template=mysql_show_test_failure&test_failure_id=2287709&...
[25 Sep 2009 12:24] Alexander Nozdrin
It fails also on Mac OS X.
[23 Nov 2009 10:08] Alexander Nozdrin
It fails in 6.0-codebase.
[26 Nov 2009 16:37] Sanjay Manwani
backup.backup_xpfm_compat_backup_lctn2 is not failing any more in the latest backup branch.

Here is a simpler test case instead of backup.backup_dbname_lctn2 for the same error.
You need to start mysqld on Windows with --lower_case_table_names=2

CREATE DATABASE UPPER;
CREATE TABLE UPPER.ucase (a char(10), b char(10)) ENGINE=MEMORY;
BACKUP DATABASE UPPER to 'upup.bup';
RESTORE FROM 'upup.bup'OVERWRITE;
[30 Nov 2009 11:58] Sanjay Manwani
Waiting for 43596 since it may resolve this too.
[30 Nov 2009 11:59] Sanjay Manwani
Providing link 
BUG#43596
[2 Dec 2009 12:06] Sanjay Manwani
This bug seems to have been fixed due to the patch for BUG#48923.
Could not repeat after the fix.
[11 Jan 2010 9:53] Ingo Strüwing
The backup_xpfm_compat_backup_lctn2 part will be fixed in Bug#49899 (The backup_xpfm_compat_backup_lctn2 failing on Windows PB machines).

The backup_dbname_lctn2 failure doesn't happen any more on the team tree,
but the test is still to be removed from
mysql-test/collections/default.experimental.
No review is required for this.
[22 Jan 2010 8:48] 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/97813

2936 Sanjay Manwani	2010-01-22
      Bug#46933 backup_*ltcn2 tests fail on windows
      
      These tests now pass on windows.
      Removed the tests:
        backup.backup_dbname_lctn2
        backup.backup_xpfm_compat_backup_lctn2
      from the file  default.experimental
     @ mysql-test/collections/default.experimental
        Bug#46933 backup_*ltcn2 tests fail on windows
        
        These tests now pass on windows.
        Removed the tests:
          backup.backup_dbname_lctn2
          backup.backup_xpfm_compat_backup_lctn2
[27 Jan 2010 9:33] 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/98293

2938 Sanjay Manwani	2010-01-27
      Bug#46933 backup_*ltcn2 tests fail on windows
      
      These tests now pass on windows.
      Removed the tests:
        backup.backup_dbname_lctn2
        backup.backup_xpfm_compat_backup_lctn2
      from the file  default.experimental
     @ mysql-test/collections/default.experimental
        Bug#46933 backup_*ltcn2 tests fail on windows
        
        These tests now pass on windows.
        Removed the tests:
          backup.backup_dbname_lctn2
          backup.backup_xpfm_compat_backup_lctn2
[20 Feb 2010 9:18] Bugs System
Pushed into 6.0.14-alpha (revid:ingo.struewing@sun.com-20100218152520-s4v1ld76bif06eqn) (version source revid:ingo.struewing@sun.com-20100202134837-dgbscc9m1d4dnw3y) (merge vers: 6.0.14-alpha) (pib:16)
[25 Feb 2010 1:44] Paul DuBois
Changes to test cases. No changelog entry needed.