[
https://issues.apache.org/jira/browse/KYLIN-5864?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17865880#comment-17865880
]
pengfei.zhan commented on KYLIN-5864:
-------------------------------------
h1. Dev Design
https://issues.apache.org/jira/browse/CALCITE-5430. The issue has been solved
in calcite, but kylin uses the old version. Therefore, at present, treating the
`ifnull` as a udf from spark, register this function to kylin udf.
https://issues.apache.org/jira/browse/CALCITE-5708. This issue solved this
problem, but kylin uses the old version. At present, we cherry-pick some code
to workaround. This issue will be handled in the later issue of upgrading
calcite 1.30 thoroughly.
> Fix function of `ifnull` and `substring`
> ----------------------------------------
>
> Key: KYLIN-5864
> URL: https://issues.apache.org/jira/browse/KYLIN-5864
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 5.0-alpha
> Reporter: pengfei.zhan
> Assignee: pengfei.zhan
> Priority: Major
> Fix For: 5.0.0
>
>
> Some of the following sql statements will be executed incorrectly in the
> current release.
> {code:sql}
> select ifnull(null, 'aaa');
> select substring(null, 1, 2);
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
