cockroachdb / cockroachdb/cockroach
sql: allow casting subqueries to ENUMs in views and UDFs
Open
C-enhancement
docs-done
docs-known-limitation
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
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](https://github.com/cockroachdb/cockroach/issues/107654#issuecomment-1652752619) 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
Contributor guide
Assessment
This issue has not been assessed yet.