[ https://issues.apache.org/jira/browse/CALCITE-6479?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Francis Chuang closed CALCITE-6479. ----------------------------------- Resolution: Duplicate > OracleDialect does not support CASE WHEN returning boolean > ---------------------------------------------------------- > > Key: CALCITE-6479 > URL: https://issues.apache.org/jira/browse/CALCITE-6479 > Project: Calcite > Issue Type: Wish > Components: core > Reporter: kate > Priority: Minor > > 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 > {{}} > {code:java} > SELECT * FROM xxx > WHERE CASE WHEN a > 10 THEN b < 5 ELSE c > 0 END;{code} > {{}} > Therefore, we hope to remove such predicates at the dialect like Oracle. > > -- This message was sent by Atlassian Jira (v8.20.10#820010)