Bug #8253 Select 'a', * from table causes syntax error
Submitted: 2 Feb 2005 4:28 Modified: 8 Feb 2005 19:47
Reporter: KimSeong Loh (Candidate Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:* OS:Any (*)
Assigned to: Assigned Account CPU Architecture:Any

[2 Feb 2005 4:28] KimSeong Loh

Select 'a' , * from tablename;   
gives a syntax error
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* from aa' at line 1

Select 'a' , tablename.* from tablename;  
Select * , 'a' from tablename;  
works fine.

How to repeat:
Select 'a' , * from tablename;
[2 Feb 2005 5:17] Aleksey Kishkin
tested on 4.0.23 and 4.1.9 on win xp sp 2
[2 Feb 2005 5:20] Aleksey Kishkin
tested also 3.23.58 on on linux
[8 Feb 2005 19:47] Sergei Golubchik
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

see http://bugs.mysql.com/bug.php?id=9