Bug #11805 Test case 'ndb_autodiscover' fails on Mac OS X 10.4 (Tiger)

• Submitted: 8 Jul 2005 5:39
• Modified: 12 Jul 2005 11:48
• Reporter: Kent Boortz
• Status: Won't fix
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S2 (Serious)
• Version: 5.0.9-pre
• OS: MacOS (Mac OS X 10.4)
• Assigned to: Martin Skold
• CPU Architecture: Any

[8 Jul 2005 5:39] Kent Boortz

Description:
Test fails with

ndb_autodiscover                [ fail ]
Errors are (from /Volumes/StripedRAID/Build/xserve/test/mysql-max-5.0.9-beta-osx10.4-powerpc/mysql-test/var/log/mysqltest-time) :
/Volumes/StripedRAID/Build/xserve/test/mysql-max-5.0.9-beta-osx10.4-powerpc/bin/mysqltest: At line 505: query 'CREATE TABLE sys.SYSTAB_0 (a int)' failed with wrong errno 1 instead of 1...
/Volumes/StripedRAID/Build/xserve/test/mysql-max-5.0.9-beta-osx10.4-powerpc/bin/mysqltest: At line 507: query 'select * from sys.SYSTAB_0' failed with wrong errno 1146 instead of 1...
/Volumes/StripedRAID/Build/xserve/test/mysql-max-5.0.9-beta-osx10.4-powerpc/bin/mysqltest: At line 509: unable to execute statement 'CREATE TABLE IF NOT EXISTS sys.SYSTAB_0 (a int)': Can't create/\
write to file './sys/SYSTAB_0.frm' (Errcode: 2) (mysql_stmt_errno=1 returned=1)

How to repeat:
Run the test case

[11 Jul 2005 14:37] Martin Skold

Problem here is that when installing database, one gets:
050711  6:54:50 [Warning] Setting lower_case_table_names=2 because file system for /tmp/mysql-5.0.9/var/ is case insensitive
Ndb Cluster does not follow this setting and internal Ndb data dictionary is still case
sensitive.

[12 Jul 2005 11:48] Martin Skold

Disabled test since it only works on case sensiitive systems