[
https://issues.apache.org/jira/browse/CALCITE-4758?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17426549#comment-17426549
]
duan xiong edited comment on CALCITE-4758 at 10/9/21, 8:48 AM:
---------------------------------------------------------------
The CALCITE-4843 will implement optimize this sub-query. This ISSUE will
support
{code:java}
select * from "scott".emp where sal > some (4000, 2000){code}
make sure to return the right result.
was (Author: nobigo):
The CALCITE-4843 will implement optimize this sub-query. This ISSUE will
support
select * from "scott".emp
where sal > some (4000, 2000)
make sure to return the right result.
> When SOME 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
> Labels: pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
> As discussed in the comments: The SQL
> {code:java}
> select * from "scott".emp where sal > some (4000, 2000)
> {code}
> is illegal SQL. So we should throw an exception instead of return a wrong
> result.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
