Hello, I have a sample graph generated by the following command CREATE p = (:x {name: 'a'}) -[:next]-> (:y {name: 'b'})-[:next]-> (:x {name: 'c'})-[:next]-> (:y {name: 'd'}), q = (:y {name: 'b'})-[:next]-> (:x {name: 'c'})-[:next]-> (:y {name: 'd'}), r = (:x {name: 'a'}) -[:next]-> (:y {name: 'b'}…

In looking at this a bit, I tried two separate MATCH statements and get a different answer which led me to this post, which explains a bit about what is going on [image] Match vs comma separated values Cypher Why do these two queries produce different results? I thought h…

Cartesian Product of Paths Produces Unexpected Result

Neo4j Graph Platform Cypher

Joel (Joel D.) December 22, 2020, 5:17pm 2

In looking at this a bit, I tried two separate MATCH statements and get a different answer which led me to this post, which explains a bit about what is going on

but personally I agree, it feels like inconsistent behavior (unexpected, unnatural) in fact we are warned that the MATCH is a cartesian product.

"This query builds a cartesian product between disconnected patterns."

1 Like

Topic		Replies	Views
Results discrepancies! Cypher operations	2	204	June 7, 2021
Hello, how can I return the Path without repetitive results? Cypher cypher	15	296	May 30, 2022
Cypher to display all connections to nodes Neo4j Graph Platform migrated	2	193	August 28, 2022
Cypher Query in not traversing backwards Cypher cypher , knowledge-base	3	215	February 7, 2022
“Query Optimization” : Neo4j Query builds a cartesian product between disconnected patterns - Cypher performance , cypher , relationship	3	1623	October 5, 2020

Cartesian Product of Paths Produces Unexpected Result

Related Topics