[jira] [Commented] (ASTERIXDB-3006) InlineSubplanInputForNestedTupleSourceRule produces invalid query plan

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ASTERIXDB-3006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17477392#comment-17477392 ] 

ASF subversion and git services commented on ASTERIXDB-3006:
------------------------------------------------------------

Commit 7a0f99b85cddf3ac1a157bcfe3ef1045683f3f90 in asterixdb's branch refs/heads/master from Dmitry Lychagin
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=7a0f99b ]

[ASTERIXDB-3006][COMP] Change translation of inner joins in subplans

- user model changes: no
- storage format changes: no
- interface changes: no

Details:
- Translate inner join inside subplan into unnest/subplan
  operators instead of a join operator. The join will be
  introduced later by the optimizer
- This translation matches expectations of
  InlineSubplanInputForNestedTupleSourceRule
- Add testcase

Change-Id: I46d6ca1bfaa9f76012adaa21a2aeca56b4d93afb
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/14825
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Dmitry Lychagin <dm...@couchbase.com>
Reviewed-by: Ali Alsuliman <al...@gmail.com>


> InlineSubplanInputForNestedTupleSourceRule produces invalid query plan
> ----------------------------------------------------------------------
>
>                 Key: ASTERIXDB-3006
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3006
>             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.8
>
>
> The following query fails during optimizer sanity check.
> {noformat}
> select *
> from ds1
> where exists(
>    select 1
>    from ds1.a[*].b b
>    join ds2 on ds2.x[0].y = b
> )
> {noformat}
> Error:
> {noformat}
> HYR0126: Illegal state. Fired rule org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule produced illegal undefined used variables [$$ds1] in assign [$$46] <- [{"ds1": $$ds1}]
> {noformat}



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