[jira] [Resolved] (ASTERIXDB-2988) Left outer join query fails when indexnl hint is specified.

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

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

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

> Left outer join query fails when indexnl hint is specified.
> -----------------------------------------------------------
>
>                 Key: ASTERIXDB-2988
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2988
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: COMP - Compiler
>    Affects Versions: 0.9.7
>            Reporter: Dmitry Lychagin
>            Assignee: Dmitry Lychagin
>            Priority: Major
>             Fix For: 0.9.7
>
>
> The following query fails at compile time if indexnl is specified.
> {noformat}
> DROP dataverse test if exists;
> CREATE dataverse test;
> USE test;
> CREATE DATASET ds1(x int, y int) PRIMARY KEY x;
> CREATE INDEX idx_y ON ds1(y) TYPE BTREE;
> insert into ds1 ([ {"x":1, "y":3 }, {"x":2, "y":4 } ]);
> select r1, ds1.x, ds1.y
> from range(0, 4) r1 left outer join ds1 on r1 /* +indexnl */ = ds1.y
> order by r1
> {noformat}
> Exception:
> {noformat}
> org.apache.asterix.common.exceptions.CompilationException: ASX1030: The subtree does not have any data source (in line 25, at column 6)
>         at org.apache.asterix.optimizer.rules.am.OptimizableOperatorSubTree.getPrimaryKeyVars(OptimizableOperatorSubTree.java:437) ~[classes/:?]
>         at org.apache.asterix.optimizer.rules.am.AccessMethodUtils.finalizeJoinPlanTransformation(AccessMethodUtils.java:859) ~[classes/:?]
>         at org.apache.asterix.optimizer.rules.am.BTreeAccessMethod.applyJoinPlanTransformation(BTreeAccessMethod.java:300) ~[classes/:?]
>         at org.apache.asterix.optimizer.rules.am.IntroduceJoinAccessMethodRule.checkAndApplyJoinTransformation(IntroduceJoinAccessMethodRule.java:423) ~[classes/:?]
> {noformat}
> If index join rewriting cannot be performed then the hint should be ignored instead.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)