Redis version: redis-7.2.4
RedisGraph version: redisgraph-2.12.10
Operating system: Ubuntu 20.04
Q1:MATCH (n0 :L1) UNWIND [475660910, (n0.k9), (n0.k7)] AS a0 MATCH (n0) WHERE ((n0.k8) < 'tX') UNWIND [(n0.k7), (n0.k9)] AS a1 OPTIONAL MATCH (n0) WHERE (true AND ('Y' ENDS WITH 'LY')) RETURN count(*);
return --102
Q2:MATCH (n0 :L1) UNWIND [475660910, (n0.k9), (n0.k7)] AS a0 MATCH (n0) WHERE ((n0.k8) < 'tX') UNWIND [(n0.k7), (n0.k9)] AS a1 OPTIONAL MATCH (n0) WHERE (true AND ('Y' ENDS WITH 'LY')) RETURN count(*); (CREATE INDEX ON:L1(k8))
return --114
The results of Q1 and Q2 should be the same, as Q2 only adds an extra index CREATE INDEX ON:L1(k8). However, the results of the two queries are now inconsistent.
database:
database.log
Redis version: redis-7.2.4
RedisGraph version: redisgraph-2.12.10
Operating system: Ubuntu 20.04
Q1:
MATCH (n0 :L1) UNWIND [475660910, (n0.k9), (n0.k7)] AS a0 MATCH (n0) WHERE ((n0.k8) < 'tX') UNWIND [(n0.k7), (n0.k9)] AS a1 OPTIONAL MATCH (n0) WHERE (true AND ('Y' ENDS WITH 'LY')) RETURN count(*);return --102
Q2:
MATCH (n0 :L1) UNWIND [475660910, (n0.k9), (n0.k7)] AS a0 MATCH (n0) WHERE ((n0.k8) < 'tX') UNWIND [(n0.k7), (n0.k9)] AS a1 OPTIONAL MATCH (n0) WHERE (true AND ('Y' ENDS WITH 'LY')) RETURN count(*); (CREATE INDEX ON:L1(k8))return --114
The results of Q1 and Q2 should be the same, as Q2 only adds an extra index
CREATE INDEX ON:L1(k8). However, the results of the two queries are now inconsistent.database:
database.log