[ https://issues.apache.org/jira/browse/CALCITE-6480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17866593#comment-17866593 ]
kate commented on CALCITE-6480: ------------------------------- I forgot to mention that we would like to be able to optimise bool case when to and and or expressions, as in the example above. convert to {code:java} SELECT * FROM xxx WHERE a > 10 and b < 5 or NOT(a>10) and c > 0 ;{code} I think there are two possible solutions, one is to talk about this optimisation as a fixed optimisation to be put into RexSimplify, and the other is to do it in RelToSqlConverter as a pre-processor for some of the source > OracleDialect does not support CASE WHEN returning boolean > ---------------------------------------------------------- > > Key: CALCITE-6480 > URL: https://issues.apache.org/jira/browse/CALCITE-6480 > 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)