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.
| Attachment | Size |
|---|---|
| join-clause-fix.patch | 2.17 KB |
#1
Sorry, badly formatted patch the first time... This patch is in the correct format.
#2
Bump. This is a pretty simple SQL fix, the patch is already attached, any takers?
#3
This will not change the query functionality at all?