Description:
When testing 5.0 build, the test suite fails on "information_schema" and "lowercase_table3", which talking to Lenz and Brian, has to do with case insensitivity on Mac OSX. I notice that the most recent commits to this test seem to come from Gluh, though I don't know if he is the dev on this particular part of the code.
TEST RESULT
-------------------------------------------------------
lowercase_table3 [ fail ]
Errors are (from /Users/patg/mysql-5.0/mysql-test/var/log/mysqltest-time) :
/Users/patg/mysql-5.0/client/mysqltest: At line 36: query 'SELECT * from T1' failed with wrong errno 1030 instead of 1016...
/Users/patg/mysql-5.0/client/mysqltest: At line 38: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/lowercase_table3.result Fri Jan 7 06:29:10 2005
--- r/lowercase_table3.reject Thu Jan 27 04:30:56 2005
***************
*** 6,10 ****
flush tables;
CREATE TABLE t1 (a int) ENGINE=INNODB;
SELECT * from T1;
! ERROR HY000: Can't open file: 'T1.ibd' (errno: 1)
drop table t1;
--- 6,10 ----
flush tables;
CREATE TABLE t1 (a int) ENGINE=INNODB;
SELECT * from T1;
! ERROR HY000: Got error 1 from storage engine
drop table t1;
-------------------------------------------------------
TEST RESULT
-------------------------------------------------------
information_schema [ fail ]
Errors are (from /Users/patg/mysql-5.0/mysql-test/var/log/mysqltest-time) :
/Users/patg/mysql-5.0/client/mysqltest: At line 25: query 'select * from v1' failed: 1109: Unknown table 'tables' in order clause
(the last lines may be the most important ones)
How to repeat:
build mysql-5.0, run 'make test' on Mac OSX
Suggested fix:
tests must make sure the table names used will result in the data file having the same name - same _case_, that is.
