[jira] [Commented] (KYLIN-4638) NPE in org.apache.calcite.runtime.SqlFunctions.toXXX

["QiangZhang (Jira)" <ji...@apache.org>]

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

QiangZhang commented on KYLIN-4638:
-----------------------------------

Additional information：

You can reproduce this bug using the SQL above

> NPE in org.apache.calcite.runtime.SqlFunctions.toXXX
> ----------------------------------------------------
>
>                 Key: KYLIN-4638
>                 URL: https://issues.apache.org/jira/browse/KYLIN-4638
>             Project: Kylin
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: all
>            Reporter: QiangZhang
>            Priority: Major
>         Attachments: image-2020-07-14-16-38-41-173.png
>
>
> I will show two cases：
> *1.when I execute the following sql，throw NPE*
> {code:java}
> with
> t1 as
> (
> select '1' as os
> union
> select '2' as os
> ),
> t2 as
> (
> select '1' as os, '123' as pay, '456' as money
> )
> select t1.os,
> round(cast(t2.pay as double),2),
> round(cast(t2.pay as double),3)
> from t1 left join t2 on t1.os=t2.os
> {code}
> *log：*
> Exception while executing query
>  java.lang.NullPointerException
>  at org.apache.calcite.runtime.SqlFunctions.toDouble(SqlFunctions.java:1759)
>  at Baz$7$1.current(Unknown Source)
>  at org.apache.calcite.linq4j.EnumerableDefaults$TakeWhileEnumerator.moveNext(EnumerableDefaults.java:2950)
>  at org.apache.calcite.linq4j.Linq4j$EnumeratorIterator.next(Linq4j.java:689)
>  at org.apache.calcite.avatica.util.IteratorCursor.next(IteratorCursor.java:46)
>  at org.apache.calcite.avatica.AvaticaResultSet.next(AvaticaResultSet.java:239)
>  at org.apache.kylin.rest.service.QueryService.createResponseFromResultSet(QueryService.java:1015)
>  at org.apache.kylin.rest.service.QueryService.executeRequest(QueryService.java:940)
>  at org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:641)
>  at org.apache.kylin.rest.service.QueryService.query(QueryService.java:208)
> *2.* *but when I comment out some line，query is success，why？These two lines are almost identical ，this is strange。I debug the source code about calcite，haven't found the problem yet。*
> !image-2020-07-14-16-38-41-173.png!
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)