[CALCITE-97] Planner fails with correlated EXISTS sub-query

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Labels: github-import
• Assignee: Unassigned
• Reporter: GitHub Import
• Created: 18/Jun/14 08:06
• Updated: 18/Jun/14 08:07
• Resolved: 18/Jun/14 08:07

Description

Query with correlated EXISTS sub-query fails.

```sql
select * from emps where exists (
select * from depts where emps.deptno = depts.deptno)

org.eigenbase.relopt.RelOptPlanner$CannotPlanException: Node [rel(#32 | FLINK-32):Subset([#8|https://github.com/JulianHyde/optiq/issues/8] | FLINK-8).ENUMERABLE.[]] could not be implemented; planner state:
```

I believe that decorrelation is enabled, but no rule is enabled that can handle the resulting CorrelatorRel.

---------------- Imported from GitHub ----------------
Url: https://github.com/julianhyde/optiq/issues/97
Created by: julianhyde
Labels:
Created at: Tue Dec 03 01:44:52 CET 2013
State: closed