[
https://issues.apache.org/jira/browse/CALCITE-7585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18086302#comment-18086302
]
Zhen Chen commented on CALCITE-7585:
------------------------------------
I think you should include a failure case in the description so others can
better understand what you're trying to do.
> MERGE may unparse EXISTS predicates in ON clause without parentheses
> --------------------------------------------------------------------
>
> Key: CALCITE-7585
> URL: https://issues.apache.org/jira/browse/CALCITE-7585
> Project: Calcite
> Issue Type: Bug
> Reporter: zzwqqq
> Assignee: zzwqqq
> Priority: Major
>
> https://github.com/apache/calcite/pull/4969 fixes unparsing of EXISTS
> subqueries in UPDATE and DELETE statements.
> During review, it was pointed out that MERGE may have a similar problem
> because EXISTS predicates can appear in the ON clause.
> This has not been fully confirmed yet. This issue is opened to track the
> potential MERGE case separately. If confirmed, MERGE should use the same
> parenthesized unparsing behavior and include regression tests.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
