Bug #2066 SELECT syntax error
Submitted: 9 Dec 2003 19:28 Modified: 10 Dec 2003 0:22
Reporter: Mike Brock Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQLCC Severity:S3 (Non-critical)
Version:MySql 3.23.43 OS:Microsoft Windows (Windows)
Assigned to: CPU Architecture:Any

[9 Dec 2003 19:28] Mike Brock
Description:
For MySql 3.23.43, get syntax error for SELECT statements of
the form:

SELECT 'XXX' As CName, * FROM TName;
SELECT FName, * FROM TName;

Works OK for the following SELECT statements:

SELECT 'XXX' As CName, FName FROM TName;
SELECT 'XXX' As CName FROM TName;
SELECT * FROM TName;

Thanks...Mike

How to repeat:
Just use the above SELECT's as a model for any existing table on the DB.

Suggested fix:
I am new to MySql and loaded only the MsqlCC under GPL. I do not have the
source. But my thinking is the bug may be in the parse routines of MsqlCC
that does not handle the * correctly after any dummy columns with literal
text or real field names in the table. If U were to do any table JOINs, U
may want to do a SELECT of the form:

SELECT T1.F1, T2.*
       FROM T1
INNER  JOIN T2 ON T1.K1 = T2.K2;

Hope this may be of some help 4 the fix. Thanks...Mike
[10 Dec 2003 0:22] Georg Richter
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