#31094: subquery uses ungrouped column "table.column" from outer query
-------------------------------------+-------------------------------------
Reporter: Johannes Hoppe | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 3.0
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Johannes Hoppe):
A quick diff of the query in both versions, shows a diff in the grouping
section:
{{{
< GROUP BY "camps_offer"."id", "camps_provider"."id"
---
> GROUP BY "camps_offer"."id",
> (SELECT U0."id"
> FROM "camps_servicepackage" U0
> INNER JOIN "camps_region" U2 ON (U0."region_id" =
U2."id")
> WHERE (U0."company_id" = 1 AND U0."option" =
("camps_offer"."activity_type") AND
> ST_Contains(U2."locations", (T4."position")))
> LIMIT 1), "camps_provider"."id"
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/31094#comment:5>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/067.ef11dac50bae2ee6ba0058b8bc74a62d%40djangoproject.com.
