[jira] [Created] (ASTERIXDB-2969) Failure in ArrayIndexRQGIT

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

Dmitry Lychagin created ASTERIXDB-2969:
------------------------------------------

             Summary: 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
             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)