Parser Problem when union contains ORDER BY

greenlion / PHP-SQL-Parser

A pure PHP SQL (non validating) parser w/ focus on MySQL dialect of SQL

BSD 3-Clause "New" or "Revised" License

609 stars 159 forks source link

Parser Problem when union contains ORDER BY #122

Open witchi opened 9 years ago

witchi commented 9 years ago

From hith2...@gmail.com on August 03, 2013 20:39:27

What steps will reproduce the problem? Please help, i have problem when i run this query $sql="(SELECT 1 AS ID) UNION (SELECT 2 AS ID) ORDER BY ID"; $parser=new PHPSQLParser($sql);

Original issue: http://code.google.com/p/php-sql-parser/issues/detail?id=96

witchi commented 9 years ago

From pho...@gmx.de on March 05, 2014 02:19:59

I have to write a new processor for UNION statements.

Status: Accepted
Owner: pho...@gmx.de
Labels: -Type-Defect Type-Enhancement