Adding Index causes SELECT with OR condition to fail fetching any record (original) (raw)

ArcadeDB Version:

24.11.2-SNAPSHOT

OS and JDK Version:

docker container

Expected behavior

Record should be retrieved

Actual behavior

Record not retrieved

Steps to reproduce

A simple schema is as follows:

WITHOUT index, a query select fromAsset where id = '192.168.10.10' OR addresses CONTAINSTEXT '192.168.10.10' fetches correct record as shown:

After introducing a UNIQUE index on field id:

The exact same query failed to fetch any record: