Opened 2 months ago

Last modified 6 weeks ago

#35744 closed Bug

Combine query support doesn't repoint nested external references — at Version 2

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 (last modified by Simon Charette)

As I came to discover trying to help someone on the forum the support for correlated subqueries (aka OuterRef) in combined 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.

Change History (2)

comment:1 by Simon Charette, 2 months ago

Has patch: set

comment:2 by Simon Charette, 2 months ago

Description: modified (diff)
Summary: Composite query support doesn't report nested correlated queries external referencesCombine query support doesn't repoint nested external references
Note: See TracTickets for help on using tickets.
Back to Top