You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
SQL: CONTAINSTEXT and BY ITEM-Full-Text Index do not return results #3484
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;
CREATEINDEXON doc(`lst.txt` BY ITEM) FULL_TEXT;
INSERT INTO doc SET lst = [{"txt":"This is"},{"txt":"a test"}]
CREATE DOCUMENT TYPE ctr;
CREATE PROPERTY ctr.txt STRING;
CREATE DOCUMENT TYPE doc;
CREATE PROPERTY doc.lst LIST OF ctr;
CREATEINDEXON doc(`lst.txt` BY ITEM) FULL_TEXT;
INSERT INTO doc SET lst = [{"@type":"ctr","txt":"This is"},{"@type":"ctr","txt":"a test"}]
Activity
fix: CONTAINSTEXT with FULL_TEXT BY ITEM and compound
lvca commentedon Feb 20, 2026
Fixed
gramian commentedon Feb 20, 2026
Works for me. Superb, Thank you.
chore(deps): bump the github-actions group with 3 updates [skip ci]
fix: CONTAINSTEXT with FULL_TEXT BY ITEM and compound
chore(deps): bump the github-actions group with 5 updates [skip ci]
fix: CONTAINSTEXT with FULL_TEXT BY ITEM and compound
chore(deps): bump the github-actions group with 3 updates [skip ci]
chore(deps): bump the github-actions group with 5 updates [skip ci]