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

• Type: Wish
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.38.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: suibianwanwan
• Created: 17/Jul/24 02:29
• Updated: 17/Oct/24 22:41
• Resolved: 17/Oct/24 22:41

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

• Blocked: CALCITE-6482 Oracle dialect convert boolean literal when version < 23
• is duplicated by: CALCITE-6476 OracleDialect does not support CASE WHEN returning boolean
• is duplicated by: CALCITE-6477 OracleDialect does not support CASE WHEN returning boolean
• is duplicated by: CALCITE-6479 OracleDialect does not support CASE WHEN returning boolean
• relates to: CALCITE-6583 Case Statement reformulation in JdbcAdapter
• links to: GitHub Pull Request #3897