You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Ruben Quesada Lopez (JIRA)" <ji...@apache.org> on 2019/02/21 16:23:00 UTC
[jira] [Commented] (CALCITE-1605) Wrong result/plan for correlated
subquery with windowing
[ https://issues.apache.org/jira/browse/CALCITE-1605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16774258#comment-16774258 ]
Ruben Quesada Lopez commented on CALCITE-1605:
----------------------------------------------
[~julianhyde], could this be the same problem as CALCITE-1583?
> Wrong result/plan for correlated subquery with windowing
> --------------------------------------------------------
>
> Key: CALCITE-1605
> URL: https://issues.apache.org/jira/browse/CALCITE-1605
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: Vineet Garg
> Assignee: Julian Hyde
> Priority: Major
> Labels: sub-query
>
> Calcite produces wrong plan, hence wrong results for correlated subquery which contains windowing function.
> Query
> {code}select * from emps where empid-1 IN (select min(e.empid) over () from emps e where e.empid =emps.empid); {code}
> Expected
> {code} 0 rows {code}
> Actual
> {noformat}
> +-------+------+--------+--------+------+-------+-----+---------+---------+----------+
> | EMPNO | NAME | DEPTNO | GENDER | CITY | EMPID | AGE | SLACKER | MANAGER | JOINEDAT |
> +-------+------+--------+--------+------+-------+-----+---------+---------+----------+
> | 110 | John | 40 | M | Vancouver | 2 | null | false | true | 2002-05-03 |
> | 130 | Alice | 40 | F | Vancouver | 2 | null | false | true | 2007-01-01 |
> +-------+------+--------+--------+------+-------+-----+---------+---------+----------+
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)