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.