Opened 2 months ago
Last modified 6 weeks ago
#35744 closed Bug
Composite query support doesn't report nested correlated queries external references — at Initial Version
| Reported by: | Simon Charette | Owned by: | |
|---|---|---|---|
| Component: | Database layer (models, ORM) | Version: | 4.1 |
| Severity: | Normal | Keywords: | |
| Cc: | Triage Stage: | Ready for checkin | |
| Has patch: | yes | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
As I came to discover 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.
Note:
See TracTickets
for help on using tickets.