You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2022/02/11 02:31:00 UTC
[jira] [Commented] (ASTERIXDB-3006) InlineSubplanInputForNestedTupleSourceRule produces invalid query plan
[ https://issues.apache.org/jira/browse/ASTERIXDB-3006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17490637#comment-17490637 ]
ASF subversion and git services commented on ASTERIXDB-3006:
------------------------------------------------------------
Commit 5588b7974f4b5d25025aa80ed44b0608fe08b312 in asterixdb's branch refs/heads/master from Dmitry Lychagin
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=5588b79 ]
[ASTERIXDB-3008][COMP] Improve translation of inner joins in subplans
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
- Fix performance regression caused by ASTERIXDB-3006
- Fix incorrect free variable computation by
FreeVariableVisitor for join clauses
Change-Id: I1f9d0f453202ec79673f2f66b9034fbc6047212b
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/15127
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Integration-Tests: 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)