[
https://issues.apache.org/jira/browse/KYLIN-5380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17652423#comment-17652423
]
ASF subversion and git services commented on KYLIN-5380:
--------------------------------------------------------
Commit 2bcfea7d782fead9360e005cb256216e21344200 in kylin's branch
refs/heads/kylin5 from Jiawei Li
[ https://gitbox.apache.org/repos/asf?p=kylin.git;h=2bcfea7d78 ]
KYLIN-5380 fix npe when sql filter having null <> 0 (#2057)
* KYLIN-5380 fix npe when sql filter having null <> 0
* minor fix license
Co-authored-by: fanshu.kong <[email protected]>
> Querying sql contain "null" or " <" or ">" or "0" at the end of where
> condition will case exception
> ---------------------------------------------------------------------------------------------------
>
> Key: KYLIN-5380
> URL: https://issues.apache.org/jira/browse/KYLIN-5380
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 5.0-alpha
> Reporter: leejaywei
> Assignee: leejaywei
> Priority: Major
> Fix For: 5.0-alpha
>
>
> 查询中过滤条件 ”null <> 0“ 不处于 where 语句结尾时, 发生异常的问题
> 问题:
> ”null <> 0“ 不处于 where 语句结尾时, 无法命中索引, 提示需要开启下压查询, 开启下压后可以查询成功
> 示例 sql :
> select * from SSB_YUGAN.LINEORDER
> where null <> 0 or LO_CUSTKEY != 0
> LIMIT 500
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
