Bug #9500 table names resolved wrongly for lower_case_table_names=2
Submitted: 30 Mar 2005 23:44 Modified: 14 Jun 2005 4:24
Reporter: Oleksandr Byelkin
Status: Closed
Category:Server Severity:S2 (Serious)
Version:4.1 OS:Mac OS X (Mac OS X)
Assigned to: Jim Winstead Target Version:

[30 Mar 2005 23: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 23:45] Oleksandr Byelkin 
Test suite mentioned in this bugreport

Attachment: test.test (text/plain), 122 bytes.
[30 Mar 2005 23:49] Jorge del Conde 
tested w/5.0 from bk
[8 Jun 2005 23: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 4:35] Jim Winstead 
Bug exists (and will be fixed) in 4.1, too.
[11 Jun 2005 8:35] Jim Winstead 
Fixed in 4.1.13 and 5.0.8.
[14 Jun 2005 4:24] Paul DuBois 
Noted in 4.1.13, 5.0.8 changelogs.