[Django] #35744: Composite query support doesn't report nested correlated queries external references

[Django]

#35744: Composite query support doesn't report nested correlated queries external
references
-------------------------------------+-------------------------------------
Reporter: Simon | Owner: (none)
Charette |
Type: Bug | Status: assigned
Component: Database | Version: 4.1
layer (models, ORM) |
Severity: Normal | Keywords:
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
As I came to discover [https://forum.djangoproject.com/t/filtering-model-
instances-m2m-field-to-exactly-match-another-m2m-field-or-list/34533/6
trying to help someone on the forum] the support for correlated subqueries
(aka `OuterRef`) in composite queries (`union`, `intersection`,
`difference`) added in #29338 fails to re-point external references on
relabeling (an operation performed on subquery pushdown to prevent table
name collisions) causing nested outer query references to be orphaned.
--
Ticket URL: <https://code.djangoproject.com/ticket/35744>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#35744: Composite query support doesn't report nested correlated queries external
references
-------------------------------------+-------------------------------------

Reporter: Simon Charette | Owner: (none)
Type: Bug | Status: assigned
Component: Database layer | Version: 4.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Simon Charette):

* has_patch: 0 => 1

--
Ticket URL: <https://code.djangoproject.com/ticket/35744#comment:1>