Posted by roderik on June 22, 2009 at 2:39pm
Jump to:
| Project: | Taxonomy Filter |
| Version: | 7.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | solotandem |
| Status: | closed (fixed) |
Issue Summary
The error which is seen so often:
for PostgreSQL (and the SQL92 standard AFAIK), all non-aggregated fields must be present in the GROUP BY clause.
In the case of the query below, this is the case for the vid & name fields, and also for the 'weight' field which is in the 'ORDER BY'.
This is a very standard bugreport/patch and should have zero effect on MySQL.
| Attachment | Size | Status | Test result | Operations |
|---|---|---|---|---|
| tf_psql.patch | 458 bytes | Ignored: Check issue status. | None | None |
Comments
#1
Forgot to set status. Though IMHO this patch should just be applied, not reviewed by 'the community'.
#2
Thanks for spotting this.
Fixed in next dev release created after this comment.
#3
Automatically closed -- issue fixed for 2 weeks with no activity.