Support indexing of properties contained in embedded documents (or maps) inside lists #2802
Description
Example:
CREATE VERTEX TYPE Photo;
CREATE PROPERTY Photo.id INTEGER;
CREATE DOCUMENT TYPE Tag;
CREATE PROPERTY Tag.id INTEGER;
CREATE PROPERTY Tag.name STRING;
CREATE PROPERTY Photo.tags LIST OF Tag;
CREATE INDEX ON Photo (id) UNIQUE;
CREATE INDEX ON Photo (tags.id BY ITEM) NOTUNIQUE;
The last command wouldn't work, because ArcadeDB doesn't support indexing of properties inside of documents inside a list:
CREATE INDEX ON Photo (tags.id BY ITEM) NOTUNIQUE;
TODO:
- Check if the existent SQL syntax already allows embedded indexing
- Manage the indexing of embedded properties inside objects (embedded document type or maps) inside lists
- Write test cases