[
https://issues.apache.org/jira/browse/CALCITE-5582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700126#comment-17700126
]
Zou commented on CALCITE-5582:
------------------------------
[~rebey] could you please add a test in Calcite to reproduce this case? In
addition, we tend to use text rather than pictures in jira, as the latter
cannot be searched, could you please rewrite the description?
> 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
> Priority: Major
> 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)
