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:
None 
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 
Description:

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  
hold.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.