Bug #9500 table names resolved wrongly for lower_case_table_names=2
Submitted: 30 Mar 2005 21:44 Modified: 14 Jun 2005 2:24
Reporter: Oleksandr Byelkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1 OS:Mac OS X (Mac OS X)
Assigned to: Jim Winstead CPU Architecture:Any

[30 Mar 2005 21:44] Oleksandr Byelkin
Description:
with lower_case_table_names=2 (default mode for Mac & windows)
following test suite fails (with lower_case_table_names=1 it pass):
TEST                            RESULT
-------------------------------------------------------
test                           [ fail ]

Errors are (from /Users/bell/mysql/bk/work-5.0/mysql-test/var/log/mysqltest-time) :
/Users/bell/mysql/bk/work-5.0/client/.libs/mysqltest: At line 3: query 'select t1Aa.col1 from t1aA,t2Aa where t1Aa.col1 = t2aA.col1' failed: 1109: Unknown table 't1Aa' in field list
(the last lines may be the most important ones)

(BTW, note that table name in error message have exactly the same case in which table was created, so error message is wrong even if resolving is correct)

How to repeat:
create table t2aA (col1 int);
create table t1Aa (col1 int);
select t1Aa.col1 from t1aA,t2Aa where t1Aa.col1 = t2aA.col1;
[30 Mar 2005 21:45] Oleksandr Byelkin
Test suite mentioned in this bugreport

Attachment: test.test (text/plain), 122 bytes.

[30 Mar 2005 21:49] Jorge del Conde
tested w/5.0 from bk
[8 Jun 2005 21:37] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/25784
[10 Jun 2005 2:35] Jim Winstead
Bug exists (and will be fixed) in 4.1, too.
[11 Jun 2005 6:35] Jim Winstead
Fixed in 4.1.13 and 5.0.8.
[14 Jun 2005 2:24] Paul Dubois
Noted in 4.1.13, 5.0.8 changelogs.