You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "rebey (Jira)" <ji...@apache.org> on 2023/03/14 11:45:00 UTC

[jira] [Created] (CALCITE-5582) Not in or not exist subquery can't work with Oracle db

rebey created CALCITE-5582:
------------------------------

             Summary: Not in or not exist subquery can't work with Oracle db
                 Key: CALCITE-5582
                 URL: https://issues.apache.org/jira/browse/CALCITE-5582
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.33.0
            Reporter: rebey
         Attachments: image-2023-03-14-19-39-39-320.png

a subquery sql with "not in" or "not exists " be change to a left join sql by calcite,but it generated "TRUE" keyword which is not work in ORACLE.How to deal with?

!image-2023-03-14-19-39-39-320.png!



--
This message was sent by Atlassian Jira
(v8.20.10#820010)