Skip to content

sql: allow casting subqueries to ENUMs in views and UDFs #108184

Open
Open
sql: allow casting subqueries to ENUMs in views and UDFs#108184
Labels
C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries Teamdocs-donedocs-known-limitation
@mgartner

Description

@mgartner
mgartner
opened on Aug 4, 2023

We currently do not allow view queries and UDF body statements to contain CAST expressions when their input contains a subquery and the target type is an ENUM. Prior to XXX this would cause internal errors. See this comment for an explanation of why this is not an easy limitation to lift, at the moment.

See issues #105259 and #107654.

See PRs #106868 and #108188.

Jira issue: CRDB-30355

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries Teamdocs-donedocs-known-limitation

    Type

    No type

    Projects

    SQL Queries

    Status

    Backlog

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions