[CALCITE-3832] NPE when decimal cast double

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.16.0
• Component/s: core
• Assignee: Unassigned
• Reporter: Zhixiong Chen
• Created: 27/Feb/20 05:53
• Updated: 27/Feb/20 14:19
• Resolved: 27/Feb/20 14:19

Description

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();

 

Issue Links

• duplicates: CALCITE-3142 NullPointerException when rounding a nullable numeric
• relates to: CALCITE-3142 NullPointerException when rounding a nullable numeric