Bug #36630 Test jp.jp_enum_utf8 failing on Windows
Submitted: 9 May 2008 15:59 Modified: 9 May 2008 22:02
Reporter: Patrick Crews Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:5.1 OS:Windows
Assigned to: Patrick Crews CPU Architecture:Any
Tags: jp, test, windows

[9 May 2008 15:59] Patrick Crews
Description:
Description:
Test jp.jp_enum_utf8 failing on Windows.  Failure appears to be result of
single-character
difference (repeated multiple times)
77c77
< T1	CREATE TABLE `T1` (
---
> T1	CREATE TABLE `t1` (

NOTE:  This is a new bug written to close out
Bug #28563	Test suite "jp" fails completely.  

How to repeat:
This bug depends on pending patch for Bug #28563	Test suite "jp" fails completely

You can repeat by running the jp suite on Windows.

./mysql-test-run.pl --suite=jp jp_enum_utf8

Suggested fix:
Determine if this is an OS-specific issue and alter the test accordingly on Windows
[9 May 2008 21:18] Patrick Crews
This is a case-sensitivity issue.  The differences are due to the table name being in upper-case, but being saved in lower-case due to Windows lower_case_table_names settings.

Will work to correct this via the use of an .opt file to set the lower_case_table_names to 0
[9 May 2008 22:02] Patrick Crews
Corrected this situation via the use of an .opt file setting lower_case_table_names=0

As the fix for Bug #28563	Test suite "jp" fails completely had not been pushed yet, the addition of the .opt file was incorporated into that patch.

Will close out this Bug and refer to Bug#28563