arcadedb
arcadedb copied to clipboard
SQL: Unexpected predicate results with empties
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 "")