[jira] [Commented] (ASTERIXDB-3099) Intersection of multiple array indexes throws error

["ASF subversion and git services (Jira)" <ji...@apache.org>]

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

ASF subversion and git services commented on ASTERIXDB-3099:
------------------------------------------------------------

Commit ffea04b53954b2cdd9f20b7871692f0c7e83589a in asterixdb's branch refs/heads/master from glennga
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=ffea04b539 ]

[ASTERIXDB-3099][COMP] Enable intersection of array indexes

- user model changes: no
- storage format changes: no
- interface changes: no

Details:

A small fix to allow array indexes to be intersected with other array
indexes when the same array is shared. This fix does **not** enable
array indexes to be intersected with atomic/column indexes, nor does
it allow array indexes to be intersected with other array indexes when
their arrays are not shared (these would involve a more significant
design change).

Change-Id: I0aa1c28298cb898fc512e908aa12fd8a896375a4
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17318
Reviewed-by: Ali Alsuliman <al...@gmail.com>
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>


> Intersection of multiple array indexes throws error
> ---------------------------------------------------
>
>                 Key: ASTERIXDB-3099
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3099
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: COMP - Compiler
>            Reporter: Glenn Justo Galvizo
>            Assignee: Glenn Justo Galvizo
>            Priority: Major
>
> A cast error is raised when trying to intersect multiple array indexes (that share the same array):
> {noformat}
> DROP DATAVERSE Test IF EXISTS;
> CREATE DATAVERSE Test;
> USE Test;
> CREATE TYPE GenericType AS { _id: uuid };
> CREATE DATASET KSI (GenericType) PRIMARY KEY _id AUTOGENERATED;
> CREATE INDEX KS1_array_index1 ON KSI ( UNNEST uarr_i SELECT a : bigint ) EXCLUDE UNKNOWN KEY;
> CREATE INDEX KS1_array_index2 ON KSI ( UNNEST uarr_i SELECT b : bigint ) EXCLUDE UNKNOWN KEY;
> FROM KSI k
> WHERE (ANY v IN k.uarr_i SATISFIES v.a = 284 AND v.b = 263)
> SELECT *;{noformat}



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