[KYLIN-5380] Querying sql contain "null" or " <" or ">" or "0" at the end of where condition will case exception

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.0-alpha
• Fix Version/s: 5.0-alpha
• Component/s: Query Engine
• Assignee: leejaywei
• Reporter: leejaywei
• Created: 20/Dec/22 02:31
• Updated: 29/Dec/22 02:54
• Resolved: 29/Dec/22 02:54

Description

查询中过滤条件 ”null <> 0“ 不处于 where 语句结尾时, 发生异常的问题

问题:

”null <> 0“ 不处于 where 语句结尾时, 无法命中索引, 提示需要开启下压查询, 开启下压后可以查询成功

示例 sql :

select * from SSB_YUGAN.LINEORDER
where null <> 0 or LO_CUSTKEY != 0
LIMIT 500