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
• Status: Closed
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 4.1
• OS: MacOS (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.