[jira] [Resolved] (ASTERIXDB-2886) Query fails optimizer sanity check

["Dmitry Lychagin (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-2886?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dmitry Lychagin resolved ASTERIXDB-2886.
----------------------------------------
    Resolution: Fixed

Fixed by https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/11863

> Query fails optimizer sanity check
> ----------------------------------
>
>                 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
>            Priority: Major
>             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.20.1#820001)