Dmitry Lychagin created ASTERIXDB-2886:
------------------------------------------
Summary: Invalid plan produced by
RemoveUnusedAssignAndAggregateRule
Key: ASTERIXDB-2886
URL: https://issues.apache.org/jira/browse/ASTERIXDB-2886
Project: Apache AsterixDB
Issue Type: Bug
Components: COMP - Compiler
Affects Versions: 0.9.6
Reporter: Dmitry Lychagin
Assignee: Dmitry Lychagin
Fix For: 0.9.7
The following query fails optimizer sanity check
{noformat}
SELECT ds.DataverseName, ds.DatasetName, indexes
FROM Metadata.`Dataset` AS ds LEFT JOIN Metadata.`Datatype` dt
ON ds.DataverseName = dt.DataverseName AND ds.DatatypeName = dt.DatatypeName
LET indexes = (
SELECT idx.IndexName
FROM Metadata.`Index` AS idx
WHERE idx.DataverseName = ds.DataverseName AND idx.DatasetName =
ds.DatasetName
)
ORDER BY ds.DataverseName, ds.DatasetName;
{noformat}
Exception
{noformat}
java.lang.Exception: HYR0126: Illegal state. Fired rule
org.apache.hyracks.algebricks.rewriter.rules.RemoveUnusedAssignAndAggregateRule
produced illegal undefined used variables [$$91, $$92] in assign [$$67] <-
[{"DataverseName": $$91, "DatasetName": $$92, "indexes": $$63}] --
|UNPARTITIONED|
{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
