Bug #3251 case insensitive table aliases in --lower_case_table_names mode
Submitted: 22 Mar 2004 0:21 Modified: 22 Mar 2004 8:41
Reporter: Oleksandr Byelkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1 OS:Any (all)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[22 Mar 2004 0:21] Oleksandr Byelkin 
Description:
name resolving use case insensitive aliases, but it is not checked during 
tabvle list construction 

How to repeat:
run serever with --lower_case_table_names 
 
mysql> select C.a, c.a from B c, A C; 
ERROR 1052 (23000): Column: 'C.a' in field list is ambiguous 
mysql> select * from B c, A C; 
+------+------+ 
| a    | a    | 
+------+------+ 
|    2 |    1 | 
+------+------+ 
1 row in set (0.00 sec) 
 

Suggested fix:
fix comparasion in st_select_lex::add_table_to_list()
[22 Mar 2004 8:07] Oleksandr Byelkin 
ChangeSet 
  1.1710 04/03/22 15:43:13 bell@sanja.is.com.ua +8 -0 
  aliases should be compared with my_strcasecmp (BUG#3251) 
  some db comparison code cleupup 
  removed compiler warnings
[22 Mar 2004 8:41] Oleksandr Byelkin 
pushed