Pewarta Proxy

📋 Server Request & Proxy Logs

Loading active proxy settings...
Developed by Khairul Adha (adhexa.id)
Mengambil log server...

⚙️ Pengaturan Proxy Target

Skip to content

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

Closed

Description

@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.

Activity

  1. self-assigned this
    on Feb 19, 2026
  2. added theissue type on Feb 19, 2026
  3. added this to the 26.3.1 milestone on Feb 19, 2026
  4. lvca commented on Feb 20, 2026

    @lvca
    Member

    Fixed

  5. gramian commented on Feb 20, 2026

    @gramian
    CollaboratorAuthor

    Works for me. Superb, Thank you.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

Projects

No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions