[CALCITE-6479] OracleDialect does not support CASE WHEN returning boolean

• Type: Wish
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Component/s: core
• Assignee: Unassigned
• Reporter: suibianwanwan
• Created: 17/Jul/24 02:27
• Updated: 17/Jul/24 02:58
• Resolved: 17/Jul/24 02:36

Description

Our requirement is to use Calcite to translate queries into different dialects. During validation in the TPC-DS scenario, we found that Oracle does not support SQL statements like

{{}}

SELECT * FROM xxx
WHERE CASE WHEN a > 10 THEN b < 5 ELSE c > 0 END;

{{}}

Therefore, we hope to remove such predicates at the dialect like Oracle.

 

 

Issue Links

• duplicates: CALCITE-6480 OracleDialect does not support CASE WHEN returning boolean