MySQL Bugs: #39626: Bad column case in a resultset of select from view

Bug #39626	Bad column case in a resultset of select from view
Submitted:	24 Sep 2008 11:17	Modified:	24 Sep 2008 12:40
Reporter:	Sagi Bashari	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Views	Severity:	S2 (Serious)
Version:	5.0.67, 5.0, 5.1, 6.0 bzr	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
When I issue a query that selects from a view, and specify column names in a case that is different from their original case in the table, then MySQL returns the original column names and not the ones I specified. 

This only happens when selecting from view. When selecting from a regular table the columns return in the same case as specified in the query.

How to repeat:
CREATE DATABASE Test_DB;
USE Test_DB;
CREATE TABLE Test_Tbl (ID int(10) PRIMARY KEY, Name varchar(32)) TYPE=InnoDB;
INSERT INTO Test_Tbl VALUES(123, 'Abc');

mysql> SELECT id, name FROM Test_Tbl;
+-----+------+
| id  | name |
+-----+------+
| 123 | Abc  |
+-----+------+

=> column names are identical to the ones specified in the query

CREATE VIEW Test_View AS SELECT * FROM Test_Tbl;

mysql> SELECT id, name FROM Test_View;
+-----+------+
| ID  | Name |
+-----+------+
| 123 | Abc  |
+-----+------+

=> column names do not match the ones specified in the query

Thank you for the report.

Verified as described.