Glenn Justo Galvizo created ASTERIXDB-3065:
----------------------------------------------
Summary: Bug in correlated JOIN subquery with UNION ALL
Key: ASTERIXDB-3065
URL: https://issues.apache.org/jira/browse/ASTERIXDB-3065
Project: Apache AsterixDB
Issue Type: Bug
Components: COMP - Compiler
Reporter: Glenn Justo Galvizo
Assignee: Glenn Justo Galvizo
There's a bug in the InlineSubplanInputForNestedTupleSourceRule (improper
handling of UNION-ALL). We produce the bug as such:
{code:java}
DROP DATAVERSE Test IF EXISTS;
CREATE DATAVERSE Test;
USE Test;
CREATE TYPE TestType AS { _id : uuid };
CREATE DATASET TestDataset (TestType) PRIMARY KEY _id AUTOGENERATED;
FROM TestDataset P3
LET P12 = (
FROM TestDataset P1
WHERE P3.user_id = P1.user_id
SELECT VALUE P1
UNION ALL
FROM TestDataset P2
WHERE P3.user_id = P1.user_id
SELECT VALUE P2 )
SELECT VALUE P12;
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
