SQL: CONTAINSTEXT and BY ITEM-Full-Text Index do not return results

[gramian]

ArcadeDB Server v26.2.1 (build ced6531188602179fef91d7f831373e7ff47284c/1771258648678/UNKNOWN)

Running on Linux 6.17.0-14-generic - OpenJDK 64-Bit Server VM 21.0.10

The CONTAINSTEXT operator seems not to work on list-of-map (or list-of-embedded) BY-ITEM-Full-text indexes, not even using the fall-back variant of CONTAINSTEXT.

Example

Given:

CREATE DOCUMENT TYPE doc;
CREATE PROPERTY doc.lst LIST OF MAP;
CREATE INDEX ON doc(`lst.txt` BY ITEM) FULL_TEXT;
INSERT INTO doc SET lst = [{"txt":"This is"},{"txt":"a test"}]

The following queries do not return results:

SELECT FROM doc WHERE lst.txt CONTAINSTEXT 'is' -- 0 results
SELECT FROM doc WHERE lst.txt CONTAINSTEXT 'IS' -- 0 results

Also, EXPLAIN does not report use of the index.

---

An example for EMBEDDED looks similar:

CREATE DOCUMENT TYPE ctr;
CREATE PROPERTY ctr.txt STRING;
CREATE DOCUMENT TYPE doc;
CREATE PROPERTY doc.lst LIST OF ctr;
CREATE INDEX ON doc(`lst.txt` BY ITEM) FULL_TEXT;
INSERT INTO doc SET lst = [{"@type":"ctr","txt":"This is"},{"@type":"ctr","txt":"a test"}]

where the above queries return no results either.

[lvca]

Fixed

[gramian]

Works for me. Superb, Thank you.