Julian Hyde created CALCITE-7429:
------------------------------------
Summary: Query with MINUS fails with "Unable to implement
EnumerableMinus(all=[false])"
Key: CALCITE-7429
URL: https://issues.apache.org/jira/browse/CALCITE-7429
Project: Calcite
Issue Type: Bug
Reporter: Julian Hyde
Query with MINUS fails with "Unable to implement EnumerableMinus(all=[false])".
The query and error are as follows.
{noformat}
SELECT deptno FROM emp WHERE deptno > 12
EXCEPT
SELECT deptno FROM dept WHERE deptno = 5
EXCEPT
SELECT deptno FROM emp e1 WHERE EXISTS (
SELECT 1 FROM emp e2
WHERE e2.comm = e1.comm)
EXCEPT
SELECT deptno FROM dept WHERE deptno = 10
EXCEPT
SELECT deptno FROM emp WHERE deptno > 20;
!ok {noformat}
throws
{noformat}
java.sql.SQLException: Error while executing SQL "SELECT deptno FROM emp WHERE
deptno > 12
...
SELECT deptno FROM emp WHERE deptno > 20": Unable to implement
EnumerableMinus(all=[false]): rowcount = 1.0, cumulative cost =
{119.56146802614614 rows, 955.4 cpu, 0.0 io}, id = 321233
at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
...
Caused by: java.lang.IllegalStateException: Unable to implement
EnumerableMinus{noformat}
This bug was discovered while trying to enable
testMinusToFilterNWayWithSubquery as part of CALCITE-7420. The query is not
necessarily minimal.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
