Skip to content

Create UNION plan node with correct schema #14380

Open
@findepi

Description

@findepi

Is your feature request related to a problem or challenge?

When building a query plan union() behavior doesn't type-coerce the expressions and it takes the left node's schema.
This creates an invalid plan which later needs to be fixed. It would be better to create a valid plan from the start.

Note: #14356 moves the code around, but doesn't change the behavior. See @alamb's #14356 (comment)

Describe the solution you'd like

Create correctly coerced plan if possible

Describe alternatives you've considered

Keep creating incorrect plan. Rely on some later logic to fix it some time later.

Additional context

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions