Hello, it's me again. TL;DR at the bottom

ArcadeDB Version:

ArcadeDB Server v24.5.1-SNAPSHOT (build 71472c4c05ae9278d0d5d71a919b31883e1ea767/1713899543605/main) is starting up... creating nodes and reading nodes

OS and JDK Version:

Running on Linux 5.15.0-100-generic - OpenJDK 64-Bit Server VM 11.0.22 for creating nodes and reading nodes

Expected behavior

ILIKE should match in any case not based on existence of \n inside the string

Actual behavior

ILIKE fails when there is any \n inside the string.

Steps to reproduce

Pick up this database :

test_db.zip

Try both :

SELECT *  FROM CHUNK"

SELECT *  FROM CHUNK where text ILIKE "%e%"

In theory, both request should output same result as all the CHUNK nodes have at least one e in the text field, however, here it fails to catch one of them.

TLDR :

All 4 have e, ILIKE should match all of them, but it doesn't.

This is the correct query to execute as a temp fix :

SELECT *  FROM CHUNK where text.replace('\n', '') ILIKE "%e%"

Thanks for the help.