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

CommentFileSizeAuthor
site_map-6.x-1.x.patch451 bytesAlexisWilke

Comments

dave reid’s picture

Status: Patch (to be ported) » Needs review

Marked #269828: PostgreSQL patch as a duplicate of this issue.

frjo’s picture

Assigned: AlexisWilke » frjo
Status: Needs review » Fixed

Has been fixed in the latest 6-dev version.

Status: Fixed » Closed (fixed)
Issue tags: -PostgreSQL, -patch

Automatically closed -- issue fixed for 2 weeks with no activity.