[
https://issues.apache.org/jira/browse/CALCITE-4758?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17409191#comment-17409191
]
duan xiong commented on CALCITE-4758:
-------------------------------------
This SQL is valid just in Oracle. And I don't test this SQL in other databases
before(PostgreSQL/MySQL is not valid).
So maybe it is not valid. But In calcite, It treats this SQL as a sub-query
now. It converts this subquery to IN or NOT IN sub-query, So it returns the
wrong result. If this SQL is not valid, maybe we should test this and throw the
error information before to remind the user, replace run success, and return
the wrong answer.
> When sub-query is SqlNodeList, Calcite returns wrong result
> ------------------------------------------------------------
>
> Key: CALCITE-4758
> URL: https://issues.apache.org/jira/browse/CALCITE-4758
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.27.0
> Reporter: duan xiong
> Assignee: duan xiong
> Priority: Major
>
> When inSubQueryThreshold is less than the SqlNodeList Size, The SqlNodeList
> can't convert to OR condition. Then the result is wrong sometimes.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
