[
https://issues.apache.org/jira/browse/ASTERIXDB-3145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17718361#comment-17718361
]
ASF subversion and git services commented on ASTERIXDB-3145:
------------------------------------------------------------
Commit b9d33f87388e3ec5712c0daca3c809410e3b5666 in asterixdb's branch
refs/heads/master from glennga
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=b9d33f8738 ]
[ASTERIXDB-3145][COMP] Fix for subplan-JOIN rewrite type bug
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
A small change: issue was that JoinFromSubplanRewrite was incorrectly
modifying the original SELECT predicate (used for the JOIN), meaning
that we would leave the plan in an inconsistent state if we didn't
apply INLJ (for array indexes).
Change-Id: I134ac050dad5a9d9b1956caba1457778cb77f33e
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17438
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: Ali Alsuliman <[email protected]>
> Query w/ Composite array index fails to compile with samples present
> --------------------------------------------------------------------
>
> Key: ASTERIXDB-3145
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3145
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler, IDX - Indexes
> Affects Versions: 0.9.8.1
> Reporter: Ian Maxon
> Assignee: Glenn Justo Galvizo
> Priority: Major
> Labels: triaged
> Fix For: 0.9.8.1
>
>
> If you run ANALYZE DATASET on the datasets in the test-suite
> array-index/composite-index-queries, the 9th query in the suite:
> {code:java}FROM Dataset2 D2,
> Dataset1 D1
> WHERE D1.field1 /* +indexnl */ = TO_BIGINT(D2.field1) AND
> ( SOME D1I IN D1.items
> SATISFIES D1I.field2 /* +indexnl */ = TO_BIGINT(D2.field2) AND
> D1I.field3 /* +indexnl */ = TO_BIGINT(D2.field3) ) AND
> D1.field4 /* +indexnl */ = TO_BIGINT(D2.field4)
> SELECT D2.field1, D2.field2, D2.field3, D2.field4
> ORDER BY D2.field1, D2.field2, D2.field3, D2.field4;{code}
> Will fail to compile with the following message:
> {code:java}ASX1079: Compilation error: Could not infer type for variable
> '$$85'. {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
