RedisGraph
RedisGraph copied to clipboard
Query returns incorrect result when index is present
When I run the following queries
CREATE INDEX FOR (n:L) ON (n.t)
CREATE (:L {t:""})
MATCH (n:L) RETURN n.t < "*fo"
MATCH (n:L) WHERE n.t < "*fo" RETURN COUNT(n)
I get the following result
true
0
I would expect the last query to return a count of 1 because the condition evaluates to true.
This is also the behaviour that I'm seeing when using Neo4J. Note that this does not happen when the index is not present.
Redis Version: 6.2.5 RedisGraph Version: Self built from master branch (f82f95a84c8d5acd560ebdc4012df50bd69ac89b) Operating System: 5.18.2 Arch Linux