[#10419] missing non-aggregated column in GROUP BY
Summary missing non-aggregated column in GROUP BY
Queue Content
Queue Version 1.0.1
Type Bug
State Resolved
Priority 1. Low
Owners mrubinsk@horde.org
Requester thpo+horde@dotrc.de
Created 2011-08-09 (3257 days ago)
Updated 2011-08-11 (3255 days ago)
Resolved 2011-08-11 (3255 days ago)
Patch No

thpo+horde@dotrc.de 2011-08-09 16:55:18
2011-08-09T11:30:42+02:00 ERR: HORDE [ansel] SQL QUERY FAILED: 
SQLSTATE[42803]: Grouping error: 7 ERROR:  column "t.tag_name" must 
appear in the GROUP BY clause or be used in an aggregate function
         SELECT t.tag_id AS tag_id, tag_name, COUNT(*) AS count FROM
           "rampage_tagged" tagged INNER JOIN "rampage_objects" objects ON
           tagged.object_id = objects.object_id AND objects.type_id 
           JOIN "rampage_tags" t ON tagged.tag_id = t.tag_id GROUP BY t.tag_id
           ORDER BY count DESC LIMIT 20 [pid 31253 on line 808 of 

Git Commit <commits@lists.horde.org> 2011-08-11 05:08:36
Changes have been made in Git for this ticket:

Fix including all non-aggregate fields in group by clause, and other 
issues caught with unit testing.
Bug #10419

  1 files changed, 8 insertions(+), 8 deletions(-)

Michael Rubinsky <mrubinsk@horde.org> 2011-08-11 05:11:43
Fixed, along with some other issues caught by better unit tests.