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

["Julian Hyde (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-1387?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15563748#comment-15563748 ] 

Julian Hyde commented on CALCITE-1387:
--------------------------------------

[~kabhwan], Is this issue fixed by the fix to CALCITE-1386? If so please close as a 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
>
> 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)