GROUP BY clauses are invalid for Postgres

elyobo - November 1, 2009 - 01:51
Project:Community Tags
Version:6.x-1.0-beta2
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active
Description

Postgres is a little more strict when it comes to joins than MySQL is and the community tags module has some queries which are not valid in Postgres. The alterations are very simple; you just need to include all fields SELECTed in the JOIN clause.

I have attached a patch which changes the joins in the specified release; I think this is the standard syntax, so should work correctly under MySQL as well.

AttachmentSize
join-clause-fix.patch2.17 KB

#1

elyobo - November 1, 2009 - 08:03

Sorry, badly formatted patch the first time... This patch is in the correct format.

AttachmentSize
community_tags_postgres_group_by_fix.patch 2.75 KB

#2

elyobo - November 16, 2009 - 11:19

Bump. This is a pretty simple SQL fix, the patch is already attached, any takers?

#3

entrigan - December 1, 2009 - 01:20

This will not change the query functionality at all?

 
 

Drupal is a registered trademark of Dries Buytaert.