[
https://issues.apache.org/jira/browse/CALCITE-1650?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15878781#comment-15878781
]
Remus Rusanu commented on CALCITE-1650:
---------------------------------------
I think the relevant snippet is 6.13 20) (SQL2011) which describes only the
string and boolean SD cases, so numeric source is not covered.
> Difference in BOOLEAN cast between Hive and Calcite
> ---------------------------------------------------
>
> Key: CALCITE-1650
> URL: https://issues.apache.org/jira/browse/CALCITE-1650
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: Remus Rusanu
> Assignee: Julian Hyde
>
> Hive {{CAST( ... AS BOOLEAN)}} gives true for anything 'not zero' (eg.
> {{CAST(1 as BOOLEAN)}} is {{true}}) while Calcite uses strict Java
> {{Boolean.valueOf(...)}} which yields true only for the string 'true'.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
