murali krishna created ASTERIXDB-3613:
-----------------------------------------

             Summary: non deterministic wrong result in ch2 query 8 (depending 
on the load).
                 Key: ASTERIXDB-3613
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3613
             Project: Apache AsterixDB
          Issue Type: Bug
          Components: *DB - AsterixDB
            Reporter: murali krishna
         Attachments: ch2.ddl.sql, ch2.tar.gz

Start up  AsterixServerIntegrationUtil.

Load the data using the following ddl in the attachment. Change path names.
The data is also provided.

Then run this query (CBO will be used as all collections will have samples).

You may see one of two results.

 "results":  []

or

"results": [ {
        "l_year" : null,
        "mkt_share" : null           << correct result.... (rbo produces this 
result).
    } ]

You will have to load multiple times to see the two different results as the 
result somehow seems to depend on the load.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to