HAVING is a DB construct which isn't often used, but is actually ANSI SQL. Unfortuntely, Drupal doesn't support it (read: It mutilates queries that use it) if one uses a node_access module (see http://drupal.org/node/157896).

The attached mini-patch solves the problem.

The patch is against D5 but also applies against D6-CVS (and even 4.7).

CommentFileSizeAuthor
having.patch610 byteskilles@www.drop.org

Comments

drumm’s picture

Version: 5.x-dev » 6.x-dev
Status: Needs review » Reviewed & tested by the community

Committed to 5.x.

gábor hojtsy’s picture

Status: Reviewed & tested by the community » Fixed

Look logical, committed!

Anonymous’s picture

Status: Fixed » Closed (fixed)