Several issues with php-sql-creator.php

[GoogleCodeExporter]

Several issues recreating a SQL from parsed array.

What steps will reproduce the problem?
1. (SELECT) GROUP BY colref fails.
Example unparsed query: SELECT col FROM table1 GROUP BY col

2. (SELECT) ORDER BY <alias> fails
Example unparsed query: SELECT col AS somealias FROM table ORDER BY somealias 
LIMIT 1

3. (SELECT) LIMIT is ignored in output
Example unparsed query: SELECT * FROM table LIMIT 1

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?
Downloaded from Trunk, Rev. r274

Please provide any additional information below.

I have fixed these 3 issues in the attached file. Please use a diff to see the 
changes.

Regards,
Marco

Original issue reported on code.google.com by Marco6...@gmail.com on 21 Jun 2012 at 5:00

Attachments:

• php-sql-creator.php

[GoogleCodeExporter]

Thank you for your bugfixes, I have added some code to REV 290 (/trunk). Some 
tests have been added.

Original comment by pho...@gmx.de on 2 Jul 2012 at 8:11

• Changed state: Started

[GoogleCodeExporter]

Original comment by pho...@gmx.de on 2 Jul 2012 at 8:12

[GoogleCodeExporter]

Original comment by pho...@gmx.de on 3 Jul 2012 at 8:29

• Changed state: Fixed