tree 303c83c5bb8208a1510fbb44e0b5ea1cc8357a46
parent 84dc6b64d27a882b06bc94456a69c2ebf5a6ca3c
author Glenn <ggalvizo@uci.edu> 1614297889 -0800
committer Dmitry Lychagin <dmitry.lychagin@couchbase.com> 1614813776 +0000

[NO-ISSUE][IDX] Adding support for array-indexes.

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

details:
- Users can now create indexes on array-valued fields, of the general
form "CREATE INDEX ... ON Dataset (UNNEST arrayField SELECT atomicField)".
- Metadata tuples for indexes has been updated to support a list
of "complex search keys", as well as multiple types for one key.
In the presence of a complex search key, all keys (even simple SKs)
will be placed inside this new list.
- Queries involving membership, UNNESTs, quantification
(existential and partially supported universal) will utilize an
applicable array index. Users must set the compiler option "arrayindex"
to true to enable this.
- SIDX maintenance operations now allow the use of nested plans, which
the aforementioned maintenance op will operate on from the end of the
nested plan(s).
- Indexes are now classified by different types in metadata, with a new
"array" index type.

Change-Id: Id0e9eee940cc94819e169a74ed180387b7a3093b
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/7684
Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Reviewed-by: Dmitry Lychagin <dmitry.lychagin@couchbase.com>