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

["Glenn Justo Galvizo (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ASTERIXDB-2966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17416985#comment-17416985 ] 

Glenn Justo Galvizo edited comment on ASTERIXDB-2966 at 9/18/21, 1:36 AM:
--------------------------------------------------------------------------

It seems to be an issue with nested-loop-joins in the probe. The following query also fails:
{code:java}
SET       `compiler.arrayindex` "false";
USE       TestDataverse;
FROM      ProbeDataset1   P1,
          ProbeDataset2   P2,
          IndexedDataset  D1,
          D1.items        DII
WHERE     P1._id < P2._id AND DII.item /* +indexnl */ = TO_BIGINT(P1.probe_value)
SELECT    P1._id AS P1ID, P2._id AS P2ID, D1._id AS D1ID
ORDER BY  P1ID, P2ID, D1ID;
{code}


was (Author: ggalvizo):
It seems to be an issue with nested-loop-joins in the probe. The following queries also fail:
{code:java}
SET       `compiler.arrayindex` "false";
USE       TestDataverse;
FROM      ProbeDataset1   P1,
          ProbeDataset2   P2,
          IndexedDataset  D1,
          D1.items        DII
WHERE     P1._id < P2._id AND DII.item /* +indexnl */ = TO_BIGINT(P1.probe_value)
SELECT    P1._id AS P1ID, P2._id AS P2ID, D1._id AS D1ID
ORDER BY  P1ID, P2ID, D1ID;
{code}

> 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
>            Priority: Major
>
> *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)