Summary | missing non-aggregated column in GROUP BY |
Queue | Content |
Queue Version | 1.0.1 |
Type | Bug |
State | Resolved |
Priority | 1. Low |
Owners | mrubinsk (at) horde (dot) org |
Requester | thpo+horde (at) dotrc (dot) de |
Created | 08/09/2011 (5079 days ago) |
Due | |
Updated | 08/11/2011 (5077 days ago) |
Assigned | |
Resolved | 08/11/2011 (5077 days ago) |
Github Issue Link | |
Github Pull Request | |
Milestone | |
Patch | No |
Assigned to Michael Rubinsky
State ⇒ Resolved
Thanks!
Fix including all non-aggregate fields in group by clause, and other
issues caught with unit testing.
Bug #104191 files changed, 8 insertions(+), 8 deletions(-)
http://git.horde.org/horde-git/-/commit/2644a8bcaadeff77e52a5dfcc80c827b50167e79
Priority ⇒ 1. Low
New Attachment: content.diff
Patch ⇒ No
Milestone ⇒
Queue ⇒ Content
Summary ⇒ missing non-aggregated column in GROUP BY
Type ⇒ Bug
State ⇒ Unconfirmed
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
IN(3,4) INNER
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
"/usr/share/php/Horde/Db/Adapter/Base.php"]