-
Notifications
You must be signed in to change notification settings - Fork 233
Open
Labels
Description
RedisGraph 2.4.14, 2.8.24, 2.10.7
I would expect all the following queries to return the same result. But they output differently.
127.0.0.1:6379> GRAPH.QUERY Test "MATCH (s1:A)--(s0:B)--(s2:A)<--()<--(s3:A)<--(s4:A)--(s5:A) WHERE s2=s5 RETURN count(s1)"
1) 1) "count(s1)"
2) 1) 1) (integer) 25
3) 1) "Cached execution: 0"
2) "Query internal execution time: 4.076223 milliseconds"
127.0.0.1:6379> GRAPH.QUERY Test "MATCH (s1:A)--(s0:B)--(s2:A)<--()<--(s3:A)<--(s4:A)--(s5:A) WHERE s2=s5 AND id(s0)>=0 RETURN count(s1)"
1) 1) "count(s1)"
2) 1) 1) (integer) 61
3) 1) "Cached execution: 0"
2) "Query internal execution time: 5.504205 milliseconds"
127.0.0.1:6379> GRAPH.QUERY Test "MATCH (s1:A)--(s0:B)--(s2:A)<--()<--(s3:A)<--(s4:A)--(s5:A) WHERE s2=s5 AND id(s1)>=0 RETURN count(s1)"
1) 1) "count(s1)"
2) 1) 1) (integer) 25
3) 1) "Cached execution: 0"
2) "Query internal execution time: 5.203735 milliseconds"
127.0.0.1:6379> GRAPH.QUERY Test "MATCH (s1:A)--(s0:B)--(s2:A)<--()<--(s3:A)<--(s4:A)--(s5:A) WHERE s2=s5 AND id(s2)>=0 RETURN count(s1)"
1) 1) "count(s1)"
2) 1) 1) (integer) 25
3) 1) "Cached execution: 0"
2) "Query internal execution time: 4.092785 milliseconds"
127.0.0.1:6379> GRAPH.QUERY Test "MATCH (s1:A)--(s0:B)--(s2:A)<--()<--(s3:A)<--(s4:A)--(s5:A) WHERE s2=s5 AND id(s3)>=0 RETURN count(s1)"
1) 1) "count(s1)"
2) 1) 1) (integer) 95
3) 1) "Cached execution: 0"
2) "Query internal execution time: 5.273596 milliseconds"
127.0.0.1:6379> GRAPH.QUERY Test "MATCH (s1:A)--(s0:B)--(s2:A)<--()<--(s3:A)<--(s4:A)--(s5:A) WHERE s2=s5 AND id(s4)>=0 RETURN count(s1)"
1) 1) "count(s1)"
2) 1) 1) (integer) 85
3) 1) "Cached execution: 0"
2) "Query internal execution time: 5.726224 milliseconds"
127.0.0.1:6379> GRAPH.QUERY Test "MATCH (s1:A)--(s0:B)--(s2:A)<--()<--(s3:A)<--(s4:A)--(s5:A) WHERE s2=s5 AND id(s5)>=0 RETURN count(s1)"
1) 1) "count(s1)"
2) 1) 1) (integer) 25
3) 1) "Cached execution: 0"
2) "Query internal execution time: 4.010374 milliseconds"
Data:
//CREATING NODES
CREATE (n1: A{name:56,id:2,undefined:18}),
(n2: A{name:61,id:61}),
(n3: A{name:49,id:92,undefined:16}),
(n4: B{name:79,id:47}),
(n5: B{name:22,id:17,undefined:74}),
(n6: A{name:99,id:95}),
(n7: B{name:29,id:25,undefined:1}),
(n8: A{name:65,id:62}),
(n9: B{name:34,id:83,undefined:24}),
(n10: B{name:91,id:74})
//CREATING RELATIONSHIPS
CREATE (n1)-[r1:x]->(n8)
CREATE (n2)-[r2:y]->(n9)
CREATE (n3)-[r3:x]->(n3)
CREATE (n4)-[r4:y]->(n1)
CREATE (n5)-[r5:x]->(n5)
CREATE (n6)-[r6:y]->(n5)
CREATE (n7)-[r7:x]->(n6)
CREATE (n8)-[r8:y]->(n7)
CREATE (n9)-[r9:x]->(n5)
CREATE (n10)-[r10:y]->(n5)
CREATE (n1)-[r11:x]->(n5)
CREATE (n2)-[r12:y]->(n8)
CREATE (n3)-[r13:x]->(n2)
CREATE (n4)-[r14:y]->(n3)
CREATE (n5)-[r15:x]->(n6)
CREATE (n6)-[r16:y]->(n10)
CREATE (n7)-[r17:x]->(n7)
CREATE (n8)-[r18:y]->(n8)
CREATE (n9)-[r19:x]->(n9)
CREATE (n10)-[r20:y]->(n9)
CREATE (n1)-[r21:x]->(n8)
CREATE (n2)-[r22:y]->(n3)
CREATE (n3)-[r23:x]->(n1)
CREATE (n4)-[r24:y]->(n6)
CREATE (n5)-[r25:x]->(n9)
CREATE (n6)-[r26:y]->(n6)
CREATE (n7)-[r27:x]->(n5)
CREATE (n8)-[r28:y]->(n5)
CREATE (n9)-[r29:x]->(n10)
CREATE (n10)-[r30:y]->(n3)
CREATE (n1)-[r31:x]->(n10)
CREATE (n2)-[r32:y]->(n6)
CREATE (n3)-[r33:x]->(n2)
CREATE (n4)-[r34:y]->(n4)
CREATE (n5)-[r35:x]->(n3)
CREATE (n6)-[r36:y]->(n8)
CREATE (n7)-[r37:x]->(n4)
CREATE (n8)-[r38:y]->(n3)
CREATE (n9)-[r39:x]->(n8)
CREATE (n10)-[r40:y]->(n9)
CREATE (n1)-[r41:x]->(n9)
CREATE (n2)-[r42:y]->(n5)
CREATE (n3)-[r43:x]->(n7)
CREATE (n4)-[r44:y]->(n9)
CREATE (n5)-[r45:x]->(n5)
CREATE (n6)-[r46:y]->(n5)
CREATE (n7)-[r47:x]->(n7)
CREATE (n8)-[r48:y]->(n7)
CREATE (n9)-[r49:x]->(n9)
CREATE (n10)-[r50:y]->(n5)