You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@asterixdb.apache.org by "Glenn Justo Galvizo (Jira)" <ji...@apache.org> on 2021/09/15 16:37:00 UTC

[jira] [Created] (ASTERIXDB-2966) Cross product w/ array index gives different result

Glenn Justo Galvizo created ASTERIXDB-2966:
----------------------------------------------

             Summary: Cross product w/ array index gives different result
                 Key: ASTERIXDB-2966
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2966
             Project: Apache AsterixDB
          Issue Type: Bug
          Components: IDX - Indexes
            Reporter: Glenn Justo Galvizo
            Assignee: Glenn Justo Galvizo


*Found with RQG

The following query gives different results when the array index compiler flag is raised.
{code:java}
FROM ProbeDataset1 AS D2,
ProbeDataset2 AS D3,
IndexedDataset AS D1
WHERE ( SOME AND EVERY V1 IN D1.container_object_2.nesting_1.contained_object_1 SATISFIES ( V1.double_rand_4.contained_object_1 /* +indexnl */ >= (TO_DOUBLE(D3.integer_rand_4) + 0.5) ) )
SELECT COUNT(*);{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)