[
https://issues.apache.org/jira/browse/CALCITE-3832?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Feng Zhu closed CALCITE-3832.
-----------------------------
Resolution: Duplicate
The root cause: failing to inline unsafe code.
It duplicates with CALCITE-3142.
> NPE when decimal cast double
> -----------------------------
>
> Key: CALCITE-3832
> URL: https://issues.apache.org/jira/browse/CALCITE-3832
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.16.0
> Reporter: Zhixiong Chen
> Priority: Major
>
> sql like:
> select
> cast(Column1 as DOUBLE) + cast(Column2 as DOUBLE) AS "COLUMN5",
> cast(Column3 as DOUBLE) + cast(Column4 as DOUBLE) AS "COLUMN6"
> from TABLE
> The Column1、Column2、Column3、Column4 type is decimal(19,4)
> But it throw npe in decimal cast to double
> then I find in calcite plan it doesn't deal with null
> /* 24 */ final java.math.BigDecimal inp14_ = current[14] == null ?
> (java.math.BigDecimal) null :
> org.apache.calcite.runtime.SqlFunctions.toBigDecimal(current[14]);
> /* 25 */ final double v = inp14_.doubleValue();
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
