ArcadeDB Server v26.4.2 (build 96a306bed54479737b22243d9fabbae68bae01cf/1776998135905/UNKNOWN)
Running on Linux 6.17.0-22-generic - OpenJDK 64-Bit Server VM 25.0.3-ea
The wildcards *, ?, ~ do not work (it seems regex via / / doesn't either).
With this setup:
CREATE DOCUMENT TYPE Doc;
CREATE PROPERTY Doc.txt STRING;
CREATE INDEX ON Doc (txt) FULL_TEXT;
INSERT INTO Doc SET txt = 'Hello World';
These queries yield no results:
SELECT FROM Doc WHERE SEARCH_FIELDS(['txt'],'Hell*') = true
SELECT FROM Doc WHERE SEARCH_FIELDS(['txt'],'Hell?') = true
SELECT FROM Doc WHERE SEARCH_FIELDS(['txt'],'Hell~') = true
SELECT FROM Doc WHERE SEARCH_FIELDS(['txt'],'hell*') = true
SELECT FROM Doc WHERE SEARCH_FIELDS(['txt'],'hell?') = true
SELECT FROM Doc WHERE SEARCH_FIELDS(['txt'],'hell~') = true
ArcadeDB Server v26.4.2 (build 96a306bed54479737b22243d9fabbae68bae01cf/1776998135905/UNKNOWN)Running on Linux 6.17.0-22-generic - OpenJDK 64-Bit Server VM 25.0.3-eaThe wildcards
*,?,~do not work (it seems regex via/ /doesn't either).With this setup:
These queries yield no results: