arcadedb icon indicating copy to clipboard operation
arcadedb copied to clipboard

SQL: Unexpected predicate results with empties

Open gramian opened this issue 1 year ago • 0 comments

ArcadeDB Version:

ArcadeDB Server v24.5.1-SNAPSHOT (build 11db1796a17bfccb23d22cfa73906fbae9f46338/1714568271787/main)

OS and JDK Version:

Running on Mac OS X 12.7.4 - OpenJDK 64-Bit Server VM 17.0.11 (Homebrew)

Predicate testing empty with empty behaves unexpected, see below: LIKE / ILIKE return true when comparing empty strings, but in absence of wildcards I think those should act as ==.

Expected behavior

true
true

Actual behavior

false
false

Steps to reproduce

SELECT ("" LIKE "")
SELECT ("" ILIKE "")

gramian avatar May 01 '24 13:05 gramian