[
https://issues.apache.org/jira/browse/CALCITE-6917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17938660#comment-17938660
]
Julian Hyde commented on CALCITE-6917:
--------------------------------------
What you say is correct in Rex-land. But in AST-land, the IN operator
represents both subqueries and lists of values.
> Remove mention to "a list of values" from Javadoc of IN/NOT_IN operator
> -----------------------------------------------------------------------
>
> Key: CALCITE-6917
> URL: https://issues.apache.org/jira/browse/CALCITE-6917
> Project: Calcite
> Issue Type: Task
> Reporter: Stamatis Zampetakis
> Assignee: Stamatis Zampetakis
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.40.0
>
>
> The {{IN}} and {{NOT_IN}} operator in {{SqlStdOperatorTable}} are used
> exclusively for representing sub-queries and *NOT* a list of values. From
> CALCITE-4173 onward, the {{SEARCH}} operator is used to represent a list of
> values.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
