[
https://issues.apache.org/jira/browse/CALCITE-1650?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Remus Rusanu updated CALCITE-1650:
----------------------------------
Description: 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'. (was:
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'.)
> 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)
