Description: The MySQL doc says : "lower_case_table_names : If set to 1 table names are stored in lowercase on disk and *table names will be case-insensitive*." This is still wrong in foreign key specification for an InnoDB table with Linux. Ok, in the InnoDB manual there is : "In a FOREIGN KEY constraint InnoDB is now case-insensitive to column names, and in Windows also to table names" (so my bug is "expected") but this disagrees with the expected behavior or lower_case_table_names as quoted above.

How-To-Repeat: use Linux, lower_case_table_names=1 in my.cnf, CREATE TABLE t ( a int NOT NULL, PRIMARY KEY (a) ) TYPE=innodb; CREATE TABLE u ( b int, index(b), FOREIGN KEY (b) references T(a) ) TYPE=innodb; The last CREATE is rejected (errno 150). If you write t(a) instead of T(a), OK.

Fix: ?

Synopsis: <Despite lower_case_table_names=1, case problems with InnoDB> Submitter-Id: <submitter ID> Originator: <BICHOT> Organization: <your organization> MySQL support: [none] Severity: [non-critical | serious | critical ] Priority: [low | medium | high ] Category: [mysqld] Class: [ sw-bug | doc-bug | change-request | support ] Release: mysql-4.0.1

Exectutable: [mysqld-max-nt] Environment: <machine description> System: <Linux> Compiler: VC++ 6.0 Architecture: i586

To request this thread, e-mail bugs...@lists.mysql.com To unsubscribe, e-mail <bugs...@lists.mysql.com>