PostgreSQL: invalid GROUP BY with use of DISTINCT

Posted by AlexisWilke on May 7, 2009 at 1:10am

Issue Summary

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

Attachment	Size
site_map-6.x-1.x.patch	451 bytes

Posted by Dave Reid on July 1, 2009 at 1:23pm

Status:

patch (to be ported)

» needs review

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

Posted by frjo on July 2, 2009 at 7:54am

Assigned to:	AlexisWilke	» frjo
Status:	needs review	» fixed

Has been fixed in the latest 6-dev version.

Posted by System Message on July 16, 2009 at 8:00am

Status:

fixed

» closed (fixed)

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