vikramkakar / php-sql-parser

Automatically exported from code.google.com/p/php-sql-parser
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

Handle SELECT DISTINCT differently #91

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
Currently, SELECT DISTINCT statements are parsed as such:

SELECT is a node in the parse tree
DISTINCT ends up in the OPTIONS node

It would be better, if DISTINCT ends up in the SELECT node as a boolean flag 
characterizing the SELECT node.

Further, DISTINCT is not handled in the sql creator and should be added.

Original issue reported on code.google.com by adrian.p...@googlemail.com on 13 Mar 2013 at 7:45

GoogleCodeExporter commented 8 years ago

Original comment by greenlion@gmail.com on 5 May 2013 at 8:12

GoogleCodeExporter commented 8 years ago
I have enhanced the parser, the distinct statement is now classified as 
reserved keyword. The creator should create the keywords too.

Original comment by pho...@gmx.de on 1 Nov 2013 at 9:59

GoogleCodeExporter commented 8 years ago
Ooops, I forgot the release: r391

Original comment by pho...@gmx.de on 1 Nov 2013 at 10:04

GoogleCodeExporter commented 8 years ago

Original comment by pho...@gmx.de on 2 Nov 2013 at 12:51