Skip to content

Inconsistent results #2859

@YuanchengJiang

Description

@YuanchengJiang

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)

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions