Description: ------------ Using PostgreSQL window functions (available since PostgreSQL 8.4) breaks the general ORDER BY check, since there's an internal "window" ORDER BY clause which comes even before the FROM clause of the query. So, the query doesn't have an ORDER BY at the end, but such is detected and it is omitted when composing the final query sent to the server, hence the entire query breaks. Test script: --------------- $query = "SELECT ROW_NUMBER() OVER (ORDER BY id) AS row_num, id FROM xxx"; $this->bind($query, array('dbc' => Database::getInstance())); Expected result: ---------------- Normal execution of the query, with a proper ORDER BY added at the end with a column specified by setDefaultSort(). Actual result: -------------- SQL error, since only a comma is added, instead of an entire ORDER BY. A work-around is to add "ORDER BY TRUE" every time a window function is used and no other ORDER BY is present.

Added patch DataSource.patch.

Thanks for the patch Kouber

This bug has been fixed in SVN. 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.