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

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

     [ https://issues.apache.org/jira/browse/ASTERIXDB-3099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Glenn Justo Galvizo resolved ASTERIXDB-3099.
--------------------------------------------
    Resolution: Fixed

> 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)