PostgreSQL: invalid GROUP BY with use of DISTINCT
AlexisWilke - May 7, 2009 - 01:10
| Project: | Site map |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | frjo |
| Status: | closed |
| Issue tags: | patch, PostgreSQL |
Jump to:
Description
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 |
#1
Marked #269828: PostgreSQL patch as a duplicate of this issue.
#2
Has been fixed in the latest 6-dev version.
#3
Automatically closed -- issue fixed for 2 weeks with no activity.