Support indexing of properties contained in embedded documents (or maps) inside lists (original) (raw)

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