[drupal-devel] [bug] book.module needs ORDER BY columns in SELECT portion of queries

[Daniel Lyons]

Issue status update for 
http://drupal.org/node/27108
Post a follow up: 
http://drupal.org/project/comments/add/27108

 Project:      Drupal
 Version:      4.6.2
 Component:    book.module
 Category:     bug reports
 Priority:     normal
 Assigned to:  Anonymous
 Reported by:  Daniel Lyons
 Updated by:   Daniel Lyons
 Status:       patch
 Attachment:   http://drupal.org/files/issues/book.module_4.patch (2.71 KB)

Hi,


I'm running Drupal on PostgreSQL 8.0.1 and had to modify the book
module a little bit to make it work on my system. It's pretty
minor--you just have to ensure that you are also SELECTing all the
columns you're using in your ORDER BY expression, otherwise PostgreSQL
will reject the query.


These changes should have zero ramifications for MySQL installations.


Here is a patch against 4.6.2 which makes these changes.




Daniel Lyons