ArcadeDB Server v25.10.1-SNAPSHOT (build 732d083c3c4693ce82a70815d25299d43895f3be/1761068948468/main)

Running on Mac OS X 15.6 - OpenJDK 64-Bit Server VM 25 (Homebrew)

The new list indexes (via BY ITEM) allow indexing a list property element by element. For now this works only for UNIQUE and NOTUNIQUE indexes, and not for FULL_TEXT indexes. However, a BY ITEM-FULL_TEXT index is rather useful, for example to index keywords.

Setting up a database like:

CREATE DOCUMENT TYPE doc;
CREATE PROPERTY doc.txt LIST OF STRING;
CREATE INDEX ON doc (txt BY ITEM) FULL_TEXT;
INSERT INTO doc SET txt = ['one','two','three'];
INSERT INTO doc SET txt = ['four','five','six'];

These currently does not return any results but should:

SELECT FROM doc WHERE txt LIKE '%two%';

SELECT FROM doc WHERE txt CONTAINSTEXT 'two';

SELECT FROM doc WHERE txt MATCHES '(?i)two';

Thanks ahead!