[KYLIN-5152] Support boolean expression on where clause

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: v4.0.1
• Component/s: Query Engine
• Assignee: Unassigned
• Reporter: hujiahua
• Created: 10/Jan/22 11:51
• Updated: 19/Apr/22 02:29

Description

Current the following SQL will fail because true expressions was not supportted on where clause.

select SELLER_ID,sum(PRICE) from KYLIN_SALES where TURE and PART_DT = '2012-01-01'  GROUP BY SELLER_ID 

In some case, calcite will converts the filter expression of the where clause into a true expression. So I think we better support this.