[
https://issues.apache.org/jira/browse/OPTIQ-313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14055403#comment-14055403
]
Julian Hyde commented on OPTIQ-313:
-----------------------------------
Minimal test case:
{code:sql}
select *
from "hr"."depts" as d
where "deptno" in (
select d2."deptno"
from "hr"."depts" as d2
join "hr"."emps" as e2 using ("deptno")
where d."deptno" = d2."deptno")
{code}
Necessary factors seem to be a filter on top of a join, all inside the
sub-query.
> Query decorrelation fails
> -------------------------
>
> Key: OPTIQ-313
> URL: https://issues.apache.org/jira/browse/OPTIQ-313
> Project: Optiq
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
>
> TPC-H query 2 fails during preparation because even after decorrelation there
> is a CorrelatorRel present.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
