You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "kate (Jira)" <ji...@apache.org> on 2024/07/17 02:27:00 UTC

[jira] [Created] (CALCITE-6477) OracleDialect does not support CASE WHEN returning boolean

kate created CALCITE-6477:
-----------------------------

             Summary: OracleDialect does not support CASE WHEN returning boolean
                 Key: CALCITE-6477
                 URL: https://issues.apache.org/jira/browse/CALCITE-6477
             Project: Calcite
          Issue Type: Wish
          Components: core
            Reporter: kate


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)