Bug #9 select 1,* is not allowed while *,1 is ..
Submitted: 2 Dec 2002 18:37 Modified: 7 Jul 2003 4:32
Reporter: SINISA MILIVOJEVIC Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:all OS:Any (all)
Assigned to: Michael Widenius CPU Architecture:Any

[2 Dec 2002 18:37] SINISA MILIVOJEVIC

SELECT 1, * FROM test_17;
ERROR 1064: You have an error in your SQL syntax near '* from test_17 ....

These querys work fine:

SELECT *, 1 FROM test_17;
5 rows in set (0.00 sec)

SELECT 1, test_1.* FROM test_17;
5 rows in set (0.00 sec)

How to repeat:
[15 Feb 2003 23:36] Michael Widenius
This is not really a bug as on is not really allowed to have anything  
fields before or after '*' in a SELECT statement.  
(That we can handle *,1 is a side effect on the parser)  
It would be nice to also be able to handler 1,* but for now this is put on