RedisGraph icon indicating copy to clipboard operation
RedisGraph copied to clipboard

Query with where condition equal to null returns incorrect result

Open InverseIntegral opened this issue 3 years ago • 0 comments

When I run the following queries

CREATE (:L)
RETURN (null <> false) XOR true
MATCH (n:L) WHERE (null <> false) XOR true RETURN COUNT(n)

I get the following result

null
1

I would expect the last query to return a count of 0 because the condition evaluates to null. This is also the behaviour that I'm seeing when using Neo4J.

Redis Version: 6.2.5 RedisGraph Version: Self built from master branch (f82f95a84c8d5acd560ebdc4012df50bd69ac89b) Operating System: 5.18.2 Arch Linux

InverseIntegral avatar Jul 26 '22 17:07 InverseIntegral