Zhixiong Chen created CALCITE-3832:
--------------------------------------
Summary: decimal cast double throws npe
Key: CALCITE-3832
URL: https://issues.apache.org/jira/browse/CALCITE-3832
Project: Calcite
Issue Type: Bug
Components: core
Reporter: Zhixiong Chen
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)
