Bug #5154 Views: SHOW CREATE shows mixed case
Submitted: 23 Aug 2004 1:28 Modified: 10 Sep 2004 11:02
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.2-alpha-debug OS:Linux (SuSE 8.2)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[23 Aug 2004 1:28] Peter Gulutzan 
Description:
I started the MySQL Server with --lower_case_table_names=1. 
Then I made a view, using an upper case letter T. 
When I SHOW CREATE VIEW, I see both `T` and `t` in the display. 
 

How to repeat:
(server started with /usr/local/mysql/libexec/mysqld --user=root 
--lower_case_table_names=1) 
 
... 
 
 
mysql> create table T (s1 int); 
Query OK, 0 rows affected (0.29 sec) 
 
mysql> create view V as select * from T; 
Query OK, 0 rows affected (0.01 sec) 
 
mysql> show create table V; 
+-------+-------------------------------------------------------------------+ 
| Table | Create Table                                                      | 
+-------+-------------------------------------------------------------------+ 
| v     | CREATE VIEW db5.v AS select `db5`.`T`.`s1` AS `s1` from `db5`.`t` | 
+-------+-------------------------------------------------------------------+ 
1 row in set (0.00 sec)
[7 Sep 2004 16:58] Oleksandr Byelkin 
ChangeSet 
  1.1751 04/09/07 19:58:02 bell@sanja.is.com.ua +4 -0 
  ixed table and db name of fields incase of lower_case_table_names (BUG#5154)
[10 Sep 2004 11:02] Oleksandr Byelkin 
Thank you for bugreport! Bugfixed is pushed in source repository!