[development] node_db_rewrite_sql implementation breaks on pgsql

Sammy Spets sammys-drupal at synerger.com
Wed Sep 27 08:14:55 UTC 2006

Hi everyone,

It appears there is a _very_ serious implementation flaw with 
node_db_rewrite_sql() in that it fails (very) miserably on pgsql. It 
occurs when fields in ORDER BY clauses aren't placed in the list of 
selected fields.

There is a patch available (posted by @smsimms - thanks!) to repair this 
problem. It uses a subquery to solve the problem cleanly. We need some 
input on the solution and some testing done on mysql.

See: http://drupal.org/node/76819


Sammy Spets
Synerger Pty Ltd

More information about the development mailing list