[
https://issues.apache.org/jira/browse/ASTERIXDB-2966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17416985#comment-17416985
]
Glenn Justo Galvizo commented on ASTERIXDB-2966:
------------------------------------------------
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)
