[
https://issues.apache.org/jira/browse/ASTERIXDB-2969?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17418786#comment-17418786
]
ASF subversion and git services commented on ASTERIXDB-2969:
------------------------------------------------------------
Commit 48cea4fd5f941f69790b6e6cfa59b40bda624fda in asterixdb's branch
refs/heads/master from ggalvizo
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=48cea4f ]
[ASTERIXDB-2969][TEST] Fix duplicate alias bug in array index RQG query-gen
- user model changes: no
- storage format changes: no
- interface changes: no
There was an issue with the query generation portion of the array index
RQG test. This has been fixed by only generating unique endpoint indexed
field names.
Change-Id: I9109210690439fe332b14e7bd79f1b09aa4096bf
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/13343
Reviewed-by: Ian Maxon <[email protected]>
Tested-by: Jenkins <[email protected]>
Integration-Tests: Jenkins <[email protected]>
> Failure in ArrayIndexRQGIT
> --------------------------
>
> Key: ASTERIXDB-2969
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2969
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Affects Versions: 0.9.7
> Reporter: Dmitry Lychagin
> Assignee: Glenn Justo Galvizo
> Priority: Major
> Fix For: 0.9.7
>
>
> Failure in SqlppArrayIndexRQGTest.
> https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-asterix-app-openjdk11/org.apache.asterix$asterix-app/5173/testReport/junit/org.apache.asterix.test.array/SqlppArrayIndexRQGTest/test_ArrayIndexRQGIT_21___3__/
> {noformat}
> Error Message
> Index testIndex is not being used.
> Stacktrace
> java.lang.AssertionError: Index testIndex is not being used.
> at
> org.apache.asterix.test.array.SqlppArrayIndexRQGTest.test(SqlppArrayIndexRQGTest.java:336)
> Standard Output
> 17:02:39.130 [main] SqlppArrayIndexRQGTest -
> -------------------------------------------------------
> Test Case Name: #21
> Test Type: JOIN
> Test Order: INSERT -> CREATE INDEX -> QUERY
> Indexed Elements:
> Element #0:
> Kind: UNNEST_OBJECT
> UNNEST Field: container_object_1.nesting_1 [NONE]
> PROJECT Field:
> container_object_1.string_rand_26_b.contained_object_1 [string_rand_26_b]
> PROJECT Field:
> container_object_2.double_rand_10.contained_object_1 [double_rand_10]
> Indexed Query:
> Starting FROM Expr:
> Dataset Name: ProbeDataset1
> As Alias: D2
> Join Step:
> Subquery FROM Expr:
> Dataset Name: IndexedDataset
> As Alias: D1
> Subquery UNNEST Step:
> Source Alias: D1
> Array Field: container_object_1.nesting_1
> As Alias: G1
> Select Expr:
> Expr: D2._id
> As Alias: PK2
> -------------------------------------------------------
> 17:02:39.457 [main] SqlppArrayIndexRQGTest - Optimized query plan:
> distribute result [$$70]
> -- DISTRIBUTE_RESULT |UNPARTITIONED|
> exchange
> -- ONE_TO_ONE_EXCHANGE |UNPARTITIONED|
> limit 100
> -- STREAM_LIMIT |UNPARTITIONED|
> project ([$$70])
> -- STREAM_PROJECT |PARTITIONED|
> assign [$$70] <- [{"PK2": $$73}]
> -- ASSIGN |PARTITIONED|
> exchange
> -- SORT_MERGE_EXCHANGE [$$73(ASC) ] |PARTITIONED|
> limit 100
> -- STREAM_LIMIT |PARTITIONED|
> exchange
> -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
> order (topK: 100) (ASC, $$73)
> -- STABLE_SORT [topK: 100] [$$73(ASC)] |PARTITIONED|
> exchange
> -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
> project ([$$73])
> -- STREAM_PROJECT |PARTITIONED|
> exchange
> -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
> left outer join (and(eq($$80, $$75), eq($$80, $$76)))
> -- NESTED_LOOP |PARTITIONED|
> exchange
> -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
> project ([$$73, $$75, $$76])
> -- STREAM_PROJECT |PARTITIONED|
> assign [$$76, $$75] <-
> [numeric-add(to-double($$D2.getField("integer_rand_10")), 0.5),
> codepoint-to-string(ordered-list-constructor(numeric-add(100,
> $$D2.getField("string_rand_26_b"))))]
> -- ASSIGN |PARTITIONED|
> exchange
> -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
> data-scan []<-[$$73, $$D2] <-
> TestDataverse.ProbeDataset1
> -- DATASOURCE_SCAN |PARTITIONED|
> exchange
> -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
> empty-tuple-source
> -- EMPTY_TUPLE_SOURCE |PARTITIONED|
> exchange
> -- BROADCAST_EXCHANGE |PARTITIONED|
> project ([$$80])
> -- STREAM_PROJECT |PARTITIONED|
> assign [$$80] <-
> [$$G1.getField("container_object_1").getField("string_rand_26_b").getField("contained_object_1")]
> -- ASSIGN |PARTITIONED|
> project ([$$G1])
> -- STREAM_PROJECT |PARTITIONED|
> unnest $$G1 <- scan-collection($$79)
> -- UNNEST |PARTITIONED|
> project ([$$79])
> -- STREAM_PROJECT |PARTITIONED|
> assign [$$79] <-
> [$$D1.getField("container_object_1").getField("nesting_1")]
> -- ASSIGN |PARTITIONED|
> project ([$$D1])
> -- STREAM_PROJECT |PARTITIONED|
> exchange
> -- ONE_TO_ONE_EXCHANGE
> |PARTITIONED|
> data-scan []<-[$$74, $$D1] <-
> TestDataverse.IndexedDataset
> -- DATASOURCE_SCAN |PARTITIONED|
> exchange
> -- ONE_TO_ONE_EXCHANGE
> |PARTITIONED|
> empty-tuple-source
> -- EMPTY_TUPLE_SOURCE
> |PARTITIONED|
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
