Mihai Budiu created CALCITE-7887:
------------------------------------
Summary: SubQueryRemoveRule fails for a sub-query inside a window
function
Key: CALCITE-7887
URL: https://issues.apache.org/jira/browse/CALCITE-7887
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.42.0
Reporter: Mihai Budiu
The following quidem test fails:
{code:java}
SELECT empno,
SUM(CASE WHEN deptno IN (SELECT deptno FROM dept WHERE deptno < 30) THEN 1
ELSE 0 END)
OVER (ORDER BY empno) AS s
FROM emp
WHERE empno < 7600;{code}
The stack trace is:
{code:java}
java.lang.IllegalArgumentException: not found: IN($1, {
LogicalProject(DEPTNO=[$0])
LogicalFilter(condition=[<(CAST($0):INTEGER NOT NULL, 30)])
LogicalTableScan(table=[[scott, DEPT]])
})
at org.apache.calcite.rex.LogicVisitor.find(LogicVisitor.java:84)
at
org.apache.calcite.rel.rules.SubQueryRemoveRule.matchProject(SubQueryRemoveRule.java:973)
{code}
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
