MySQL Bugs: #5127: "show_check" test fails on Mac OS X

Bug #5127	"show_check" test fails on Mac OS X
Submitted:	20 Aug 2004 15:19	Modified:	27 Aug 2004 13:37
Reporter:	Lenz Grimmer	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	4.1.4-pre	OS:	MacOS (Mac OS X)
Assigned to:	Alexander Barkov	CPU Architecture:	Any

Description:
(Most of the details of this one have been discussed via email already - just filing this 
as a bug so it does not get lost)

On Mac OS X, the test suite currently fails in the following test:

show_check                     [ fail ]

Errors are (from
/Users/mysqldev/powermacg5/test/mysql-debug-4.1.4-beta-apple-darwin7.5.0-powerpc
/mysql-test/var/log/mysqltest-time) :
/Users/mysqldev/powermacg5/test/mysql-debug-4.1.4-beta-apple-darwin7.5.0-powerpc
/bin/mysqltest: At line 315: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/show_check.resultFri Aug 20 06:12:31 2004
--- r/show_check.rejectFri Aug 20 07:16:10 2004
***************
*** 406,410 ****
  create table `ä`.`ä` (a int) engine=heap;
  show table status from `ä` LIKE 'ä';
  Name Engine  Version Row_format      Rows    Avg_row_length  Data_length
Max_data_lengthIndex_length    Data_free       Auto_increment  Create_time
Update_time    Check_time      Collation       ChecksumCreate_options  Comment
- ä    HEAP    9       Fixed   0       5       #       #       #       0
NULL   NULL    NULL    NULL    latin1_swedish_ci       NULL
  drop database `ä`;
--- 406,409 ----
-------------------------------------------------------

How to repeat:
Compile the current 4.1.4 MySQL tree on Mac OS X and run the test suite - watch this test case
fail.

This indicates that it's currently not possible to use non-ASCII characters for identifiers on Mac OS X,
as the file system would mangle the file name. 

See http://developer.apple.com/documentation/MacOSX/Conceptual/SystemOverview/FileSystem/chapt...

Setting it to verified, as it's reproducable here.

A quick fix is not possible. I just commented out
the query which makes the test fails.
I'm checking off showstopper flag from this bug
to continue working on it in 4.1.5.

The test itself is now fixed by commenting out some queries.

I'm moving the rest of the problem into related bug:
http://bugs.mysql.com/bug.php?id=3906