weihua zhang created CALCITE-7272:
-------------------------------------
Summary: Subqueries cannot be decorrelated if have set op
Key: CALCITE-7272
URL: https://issues.apache.org/jira/browse/CALCITE-7272
Project: Calcite
Issue Type: Improvement
Reporter: weihua zhang
case 1:
{code:sql}
SELECT ename,
(
SELECT sum(c)
FROM (
SELECT deptno AS c
FROM dept
WHERE dept.deptno = emp.deptno
UNION ALL
SELECT 2 AS c
FROM bonus
WHERE bonus.job = emp.job
) AS union_subquery
) AS correlated_sum FROM
emp;
{code}
case 2:
{code:sql}
SELECT *,
(SELECT COUNT(*)
FROM (
SELECT * FROM emp WHERE emp.deptno = dept.deptno
UNION ALL
SELECT * FROM emp
) AS sub
GROUP BY deptno
) AS num_dept_groups
FROM dept;
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
