Bug #59830 parts.partition_debug_innodb failing due to case difference on windows
Submitted: 31 Jan 2011 5:42 Modified: 30 Jun 2011 14:57
Reporter: Anitha Gopi Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:mysql-trunk OS:Any
Assigned to: Mattias Jonsson CPU Architecture:Any
Tags: pb2

[31 Jan 2011 5:42] Anitha Gopi 
Description:
This test is failing on windows since 2011-01-26. 

http://pb2.norway.sun.com/?template=mysql_show_test_failure&test_failure_id=3486664

parts.partition_debug_innodb             [ fail ]
        Test ended at 2011-01-30 10:29:05

CURRENT_TEST: parts.partition_debug_innodb
--- G:/pb2/test/sb_1-2912083-1296344335.76/mysql-5.6.2-m5-winx64/mysql-test/suite/parts/r/partition_debug_innodb.result	2011-01-30 02:03:12.000000000 +0300
+++ G:\pb2\test\sb_1-2912083-1296344335.76\mysql-5.6.2-m5-winx64\mysql-test\suite\parts\r\partition_debug_innodb.reject	2011-01-30 12:29:05.418891400 +0300
@@ -755,8 +755,8 @@
 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
 # State before failure
-t1#P#p0.ibd
-t1#P#p10.ibd
+t1#p#p0.ibd
+t1#p#p10.ibd

How to repeat:
http://pb2.norway.sun.com/?template=mysql_show_test_failure&test_failure_id=3486664
[31 Jan 2011 7:54] Mattias Jonsson 
Test fails in 5.5+ under windows for debug-builds.

Fix is:
=== modified file 'mysql-test/suite/parts/inc/partition_fail.inc'
--- mysql-test/suite/parts/inc/partition_fail.inc       2010-10-01 13:59:07 +000
0
+++ mysql-test/suite/parts/inc/partition_fail.inc       2011-01-31 07:49:33 +000
0
@@ -23,6 +23,7 @@
 --eval $create_statement
 --eval $insert_statement
 --echo # State before failure
+--replace_result #p# #P# #sp# #SP#
 --list_files $DATADIR/test
 SHOW CREATE TABLE t1;
 --sorted_result
@@ -32,6 +33,7 @@
 --eval $fail_statement
 --enable_abort_on_error
 --echo # State after failure
+--replace_result #p# #P# #sp# #SP#
 --list_files $DATADIR/test
 SHOW CREATE TABLE t1;
 --sorted_result
[31 Jan 2011 8:30] 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/130005

3288 Mattias Jonsson	2011-01-31
      Bug#59830: parts.partition_debug_innodb failing due to case difference on windows
      
      Test was not working on windows due to the partitioning names
      was folded to lower case, fixed by replacing the results, so
      it looks the same on all platforms
[30 Jun 2011 14:57] Paul DuBois 
Closed bug since it is already pushed into mysql-trunk when merging WL#5217.