Description: ------------ A minimal example is: "SELECT x FROM y INNER JOIN z ON y.a + 1 = z.a" which is legal MySQL but gives: "Parse error: Expected an operator on line 1 ... [SQL here] ... found '+'". Test script: --------------- $sql = "SELECT x FROM y INNER JOIN z ON y.a + 1 = z.a"; $p = new SQL_Parser(null, "MySQL"); print_r($p->parse("SELECT x FROM y INNER JOIN z ON y.a + 1 = z.a")); if (isset($p->error)) { print "\n\n" . $p->error_message; } Expected result: ---------------- Parsed query. Actual result: -------------- Parse error: Expected an operator on line 1 SELECT x FROM y INNER JOIN z ON y.a + 1 = z.a ^ found: "+"

The code that needs to change to accommodate this is around line 659 in Parser.php but I can't quite work out how to do it.

This bug has been fixed in CVS. If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET). If this was a problem with the pear.php.net website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better.