parser bug

I'm not sure if it's a parser bug or expected behaviour (cause it's too
simple), or I missed something in the docs.

affected: all versions


How-to-repeat:

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)



Regards

Georg

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13180@lists.mysql.com
To unsubscribe, e-mail

parser bug

Hi!

>>>>> "Georg" == Georg Richter writes:

Georg> I'm not sure if it's a parser bug or expected behaviour (cause it's too
Georg> simple), or I missed something in the docs.

Georg> affected: all versions

Georg> How-to-repeat:

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

Georg> These querys work fine:

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


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

The above is a problem in how we implemented '*' in our yacc parser.

We will look into fixing this in the future.
(This is however not that urgent as this is not a common problem and
according to ANSI SQL 99, one is not allowed to have specify anything
other select expressions if one uses '*')

Regards,
Monty

--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Michael Widenius
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13250@lists.mysql.com
To unsubscribe, e-mail