[
https://issues.apache.org/jira/browse/CALCITE-6169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mihai Budiu updated CALCITE-6169:
---------------------------------
Fix Version/s: 1.37.0
> EnumUtils.convert does not implement the correct SQL cast semantics
> -------------------------------------------------------------------
>
> Key: CALCITE-6169
> URL: https://issues.apache.org/jira/browse/CALCITE-6169
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.36.0
> Reporter: Mihai Budiu
> Assignee: Mihai Budiu
> Priority: Major
> Fix For: 1.37.0
>
>
> The code generated by EnumUtil for casts uses the Java semantics, where casts
> just truncate values. The SQL semantics requires a runtime exception if the
> value does not fit in the target datatype.
> Some of the bugs in this code generator are masked by the BlockBuilder
> optimizer which attempts to optimize the generated code using the SQL
> semantics... But if the code is not optimized and is executed in Java it
> generates wrong results for most conversions that overflow.
> One additional wrinkle is that it is not entirely clear whether the bug is in
> EnumUtils or in the code that invokes EnumUtils. It is not specified which of
> the two semantics for casts EnumUtils are supposed to implement: Java or SQL?
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
