[jira] [Reopened] (CALCITE-1387) CAST(ITEM() as INTEGER) throws RuntimeException in Runtime when return value of ITEM() is null

["Jungtaek Lim (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-1387?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jungtaek Lim reopened CALCITE-1387:
-----------------------------------

Reopening to close as duplicate.

> CAST(ITEM() as INTEGER) throws RuntimeException in Runtime when return value of ITEM() is null
> ----------------------------------------------------------------------------------------------
>
>                 Key: CALCITE-1387
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1387
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.9.0
>            Reporter: Jungtaek Lim
>            Assignee: Julian Hyde
>             Fix For: 1.10.0
>
>
> Suppose we're defining the following table:
> {code}
> .field("ID", SqlTypeName.INTEGER)
> .field("MAPFIELD", SqlTypeName.ANY)
> .field("NESTEDMAPFIELD", SqlTypeName.ANY)
> .field("ARRAYFIELD", SqlTypeName.ANY)
> {code}
> and query like this:
> {code}
> SELECT * FROM <TBL> WHERE CAST(MAPFIELD['a'] AS INTEGER) = 1
> {code}
> When ITEM returns null (because MAPFIELD\['a'] is really null, or there's no key 'a'), CAST throws RuntimeException, saying "cannot convert null to int".
> Generated code block is here:
> {code}
> outputValues[0] = inp1_ == null ? (Boolean) null : Boolean.valueOf(org.apache.calcite.runtime.SqlFunctions.toInt(org.apache.calcite.runtime.SqlFunctions.item(inp1_, "a")) == 2);
> {code}
> Btw, CAST(COALESCE(MAPFIELD\['a'], -1) AS INTEGER) throws
> java.lang.RuntimeException: org.codehaus.commons.compiler.CompileException: Incompatible expression types "java.lang.Object" and "int".
> Code for where expression is below:
> {code}
>   final Object inp1_ = (context.values)[1];
>   outputValues[0] = inp1_ != null && inp1_ == null ? (Boolean) null : Boolean.valueOf(org.apache.calcite.runtime.SqlFunctions.toInt(inp1_ != null ? org.apache.calcite.runtime.SqlFunctions.item(inp1_, "a") : -1) == 2);
> {code}
> CAST(COALESCE(MAPFIELD\['a'], CAST(-1 AS ANY)) AS INTEGER) is generating same code block and also throws same Exception above.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)