RedisGraph icon indicating copy to clipboard operation
RedisGraph copied to clipboard

Query returns incorrect result when index is present

Open InverseIntegral opened this issue 3 years ago • 0 comments

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

InverseIntegral avatar Jul 26 '22 17:07 InverseIntegral