Closed (fixed)
Project:
Site map
Version:
6.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Issue tags:
Reporter:
Created:
7 May 2009 at 01:10 UTC
Updated:
3 Jan 2014 at 00:29 UTC
Jump to comment: Most recent
Whenever you use a field in DISTINCT, it has to appear in the GROUP BY as well. That's a limit of SQL.
I've attached the patch for this little problem, but it looks bad and some things are missing when not correct.
Thank you.
Alexis Wilke
| Comment | File | Size | Author |
|---|---|---|---|
| site_map-6.x-1.x.patch | 451 bytes | AlexisWilke |
Comments
Comment #1
dave reidMarked #269828: PostgreSQL patch as a duplicate of this issue.
Comment #2
frjo commentedHas been fixed in the latest 6-dev version.