MATCH query gets different results with neo4j when checking circular path

[yixinglu]

Query

MATCH path=(x:player{name: "Tim Duncan"})-[:like*..2]-(y) 
UNWIND nodes(path) as n 
WITH path, size(collect(distinct n)) AS testLength 
WHERE testLength == length(path) + 1 
RETURN path

Neo4j response:

+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| path                                                                                                                                                                                                                                                              |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 80}]-(:player {name: "Boris Diaw", age: 36, player: "Boris Diaw"})                                                                                                               |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 80}]-(:player {name: "Boris Diaw", age: 36, player: "Boris Diaw"})-[:like {likeness: 80}]->(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})                       |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 55}]-(:player {name: "Marco Belinelli", age: 32, player: "Marco Belinelli"})                                                                                                     |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 55}]-(:player {name: "Marco Belinelli", age: 32, player: "Marco Belinelli"})-[:like {likeness: 50}]->(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})             |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 55}]-(:player {name: "Marco Belinelli", age: 32, player: "Marco Belinelli"})-[:like {likeness: 60}]->(:player {name: "Danny Green", age: 31, player: "Danny Green"})             |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 55}]-(:player {name: "Marco Belinelli", age: 32, player: "Marco Belinelli"})<-[:like {likeness: 83}]-(:player {name: "Danny Green", age: 31, player: "Danny Green"})             |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 55}]-(:player {name: "Marco Belinelli", age: 32, player: "Marco Belinelli"})<-[:like {likeness: 99}]-(:player {name: "Dejounte Murray", age: 29, player: "Dejounte Murray"})     |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 95}]-(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})                                                                                                             |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 95}]-(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})<-[:like {likeness: 80}]-(:player {name: "Boris Diaw", age: 36, player: "Boris Diaw"})                       |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 95}]-(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})<-[:like {likeness: 50}]-(:player {name: "Marco Belinelli", age: 32, player: "Marco Belinelli"})             |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 95}]-(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})-[:like {likeness: 95}]->(:player {name: "Manu Ginobili", age: 41, player: "Manu Ginobili"})                 |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 95}]-(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})-[:like {likeness: 90}]->(:player {name: "LaMarcus Aldridge", age: 33, player: "LaMarcus Aldridge"})         |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 95}]-(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})<-[:like {likeness: 75}]-(:player {name: "LaMarcus Aldridge", age: 33, player: "LaMarcus Aldridge"})         |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 95}]-(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})<-[:like {likeness: 99}]-(:player {name: "Dejounte Murray", age: 29, player: "Dejounte Murray"})             |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 70}]-(:player {name: "Danny Green", age: 31, player: "Danny Green"})                                                                                                             |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 70}]-(:player {name: "Danny Green", age: 31, player: "Danny Green"})<-[:like {likeness: 60}]-(:player {name: "Marco Belinelli", age: 32, player: "Marco Belinelli"})             |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 70}]-(:player {name: "Danny Green", age: 31, player: "Danny Green"})-[:like {likeness: 83}]->(:player {name: "Marco Belinelli", age: 32, player: "Marco Belinelli"})             |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 70}]-(:player {name: "Danny Green", age: 31, player: "Danny Green"})-[:like {likeness: 80}]->(:player {name: "LeBron James", age: 34, player: "LeBron James"})                   |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 70}]-(:player {name: "Danny Green", age: 31, player: "Danny Green"})<-[:like {likeness: 99}]-(:player {name: "Dejounte Murray", age: 29, player: "Dejounte Murray"})             |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 75}]-(:player {name: "LaMarcus Aldridge", age: 33, player: "LaMarcus Aldridge"})                                                                                                 |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 75}]-(:player {name: "LaMarcus Aldridge", age: 33, player: "LaMarcus Aldridge"})<-[:like {likeness: 90}]-(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})         |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 75}]-(:player {name: "LaMarcus Aldridge", age: 33, player: "LaMarcus Aldridge"})<-[:like {likeness: 70}]-(:player {name: "Rudy Gay", age: 32, player: "Rudy Gay"})               |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 75}]-(:player {name: "LaMarcus Aldridge", age: 33, player: "LaMarcus Aldridge"})-[:like {likeness: 75}]->(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})         |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 75}]-(:player {name: "LaMarcus Aldridge", age: 33, player: "LaMarcus Aldridge"})<-[:like {likeness: 80}]-(:player {name: "Damian Lillard", age: 28, player: "Damian Lillard"})   |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})-[:like {likeness: 95}]->(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})                                                                                                             |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})-[:like {likeness: 95}]->(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})<-[:like {likeness: 80}]-(:player {name: "Boris Diaw", age: 36, player: "Boris Diaw"})                       |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})-[:like {likeness: 95}]->(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})<-[:like {likeness: 50}]-(:player {name: "Marco Belinelli", age: 32, player: "Marco Belinelli"})             |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})-[:like {likeness: 95}]->(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})-[:like {likeness: 95}]->(:player {name: "Manu Ginobili", age: 41, player: "Manu Ginobili"})                 |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})-[:like {likeness: 95}]->(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})-[:like {likeness: 90}]->(:player {name: "LaMarcus Aldridge", age: 33, player: "LaMarcus Aldridge"})         |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})-[:like {likeness: 95}]->(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})<-[:like {likeness: 75}]-(:player {name: "LaMarcus Aldridge", age: 33, player: "LaMarcus Aldridge"})         |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})-[:like {likeness: 95}]->(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})<-[:like {likeness: 99}]-(:player {name: "Dejounte Murray", age: 29, player: "Dejounte Murray"})             |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})-[:like {likeness: 95}]->(:player {name: "Manu Ginobili", age: 41, player: "Manu Ginobili"})                                                                                                         |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})-[:like {likeness: 95}]->(:player {name: "Manu Ginobili", age: 41, player: "Manu Ginobili"})<-[:like {likeness: 95}]-(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})                 |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})-[:like {likeness: 95}]->(:player {name: "Manu Ginobili", age: 41, player: "Manu Ginobili"})<-[:like {likeness: 99}]-(:player {name: "Dejounte Murray", age: 29, player: "Dejounte Murray"})         |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})-[:like {likeness: 95}]->(:player {name: "Manu Ginobili", age: 41, player: "Manu Ginobili"})<-[:like {likeness: 90}]-(:player {name: "Tiago Splitter", age: 34, player: "Tiago Splitter"})           |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 90}]-(:player {name: "Manu Ginobili", age: 41, player: "Manu Ginobili"})                                                                                                         |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 90}]-(:player {name: "Manu Ginobili", age: 41, player: "Manu Ginobili"})<-[:like {likeness: 95}]-(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})                 |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 90}]-(:player {name: "Manu Ginobili", age: 41, player: "Manu Ginobili"})<-[:like {likeness: 99}]-(:player {name: "Dejounte Murray", age: 29, player: "Dejounte Murray"})         |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 90}]-(:player {name: "Manu Ginobili", age: 41, player: "Manu Ginobili"})<-[:like {likeness: 90}]-(:player {name: "Tiago Splitter", age: 34, player: "Tiago Splitter"})           |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 99}]-(:player {name: "Dejounte Murray", age: 29, player: "Dejounte Murray"})                                                                                                     |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 99}]-(:player {name: "Dejounte Murray", age: 29, player: "Dejounte Murray"})-[:like {likeness: 99}]->(:player {name: "Kevin Durant", age: 30, player: "Kevin Durant"})           |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 99}]-(:player {name: "Dejounte Murray", age: 29, player: "Dejounte Murray"})-[:like {likeness: 99}]->(:player {name: "Tony Parker", age: 36, player: "Tony Parker"})             |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 99}]-(:player {name: "Dejounte Murray", age: 29, player: "Dejounte Murray"})-[:like {likeness: 99}]->(:player {name: "Manu Ginobili", age: 41, player: "Manu Ginobili"})         |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 99}]-(:player {name: "Dejounte Murray", age: 29, player: "Dejounte Murray"})-[:like {likeness: 99}]->(:player {name: "Kyle Anderson", age: 25, player: "Kyle Anderson"})         |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 99}]-(:player {name: "Dejounte Murray", age: 29, player: "Dejounte Murray"})-[:like {likeness: 99}]->(:player {name: "Danny Green", age: 31, player: "Danny Green"})             |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 99}]-(:player {name: "Dejounte Murray", age: 29, player: "Dejounte Murray"})-[:like {likeness: 99}]->(:player {name: "Marco Belinelli", age: 32, player: "Marco Belinelli"})     |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 99}]-(:player {name: "Dejounte Murray", age: 29, player: "Dejounte Murray"})-[:like {likeness: 99}]->(:player {name: "Russell Westbrook", age: 30, player: "Russell Westbrook"}) |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 99}]-(:player {name: "Dejounte Murray", age: 29, player: "Dejounte Murray"})-[:like {likeness: 99}]->(:player {name: "James Harden", age: 29, player: "James Harden"})           |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 99}]-(:player {name: "Dejounte Murray", age: 29, player: "Dejounte Murray"})-[:like {likeness: 99}]->(:player {name: "LeBron James", age: 34, player: "LeBron James"})           |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 99}]-(:player {name: "Dejounte Murray", age: 29, player: "Dejounte Murray"})-[:like {likeness: 99}]->(:player {name: "Chris Paul", age: 33, player: "Chris Paul"})               |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 80}]-(:player {name: "Aron Baynes", age: 32, player: "Aron Baynes"})                                                                                                             |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 80}]-(:player {name: "Tiago Splitter", age: 34, player: "Tiago Splitter"})                                                                                                       |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 80}]-(:player {name: "Tiago Splitter", age: 34, player: "Tiago Splitter"})-[:like {likeness: 90}]->(:player {name: "Manu Ginobili", age: 41, player: "Manu Ginobili"})           |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 80}]-(:player {name: "Shaquile O'Neal", age: 47, player: "Shaquile O'Neal"})                                                                                                     |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 80}]-(:player {name: "Shaquile O'Neal", age: 47, player: "Shaquile O'Neal"})-[:like {likeness: 100}]->(:player {name: "JaVale McGee", age: 31, player: "JaVale McGee"})          |
| (:player {name: "Tim Duncan", age: 42, player: "Tim Duncan"})<-[:like {likeness: 80}]-(:player {name: "Shaquile O'Neal", age: 47, player: "Shaquile O'Neal"})<-[:like {likeness: 90}]-(:player {name: "Yao Ming", age: 38, player: "Yao Ming"})                   |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

Nebula Graph response

Empty set (time spent 25004/25801 us)