# Match vs comma separated values **URL:** \ **Category:** Cypher\ **Created:** [September 16, 2018, 5:47pm UTC](https://community.neo4j.com/t/match-vs-comma-separated-values/1559 "2018-09-16T17:47:43Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![rcfro2](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/rcfro2/32/706_2.png) [@rcfro2](https://community.neo4j.com/u/rcfro2)\ **Post date:** [September 16, 2018, 5:47pm UTC](https://community.neo4j.com/t/match-vs-comma-separated-values/1559/1 "2018-09-16T17:47:43Z")
Why do these two queries produce different results? I thought having the comma separated statements in the match clause were equivalent to using another match statement. And yet the former returns actors with Keanu Reeves in the mix while the latter does not. Is that coincidence? match (k:Person{name:"Keanu Reeves"})- [:KNOWS] -(friends) match (friends)-[:KNOWS]-(friendsOFfriends) return distinct friendsOFfriends.name limit 5 vs match (k:Person{name:"Keanu Reeves"})- [:KNOWS] -(friends), (friends)-[:KNOWS]-(friendsOFfriends) return distinct friendsOFfriends.name limit 5 ---
**Author:** ![andrew\_bowman](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/andrew_bowman/32/73_2.png) [@andrew\_bowman](https://community.neo4j.com/u/andrew_bowman)\ **Post date:** [September 17, 2018, 2:04am UTC](https://community.neo4j.com/t/match-vs-comma-separated-values/1559/2 "2018-09-17T02:04:54Z")
This is a consequence to the uniqueness of matching used within a single MATCH pattern. Cypher uses a type of uniqueness called 'RELATIONSHIP\_PATH', meaning that within a single path, the same relationship will only ever be traversed once (this is useful for many things, notably to prevent infinite loops in traversal by taking the same relationships over and over). This uniqueness applies for the entire pattern in a single MATCH (or OPTIONAL MATCH), so it does apply to comma-separated parts of the pattern. Since you're using two separate MATCHes in the first query, the :KNOWS relationship you traversed to get from `k` to `friends` can be reused to get from `friends` to `friendsOFfriends`, so Keanu Reeves is able to be returned in those results. In the second query, since it's the same pattern being used (just comma-separated), that KNOWS relationships from `k` cannot be traversed again to get `friendsOFfriends`, so Keanu Reeves cannot be reached or returned in the results. ---
**Author:** ![rcfro2](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/rcfro2/32/706_2.png) [@rcfro2](https://community.neo4j.com/u/rcfro2)\ **Post date:** [September 17, 2018, 2:08am UTC](https://community.neo4j.com/t/match-vs-comma-separated-values/1559/3 "2018-09-17T02:08:38Z")
Thank you @andrew_bowman. Do you mind showing me where this is in the documentation? I may have misread, so I would much appreciate being able to see it. ---
**Author:** ![andrew\_bowman](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/andrew_bowman/32/73_2.png) [@andrew\_bowman](https://community.neo4j.com/u/andrew_bowman)\ **Post date:** [September 17, 2018, 2:12am UTC](https://community.neo4j.com/t/match-vs-comma-separated-values/1559/4 "2018-09-17T02:12:07Z")
Sure, this is described in the [Uniqueness](https://neo4j.com/docs/developer-manual/current/cypher/introduction/uniqueness/) section of the docs, tucked away in the Cypher introduction section. ---
**Author:** ![rcfro2](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/rcfro2/32/706_2.png) [@rcfro2](https://community.neo4j.com/u/rcfro2)\ **Post date:** [February 6, 2019, 11:27pm UTC](https://community.neo4j.com/t/match-vs-comma-separated-values/1559/5 "2019-02-06T23:27:59Z")
Hi Andrew, I know this is a bit old. But just wanted to confirm the following: This only happens in the case when the relationship is not explicitly given a direction, correct? In other words, this would also solve the double MATCH clause: match (n:Person {name:"Keanu Reeves"})-[:KNOWS]-(f) match (f)-[:KNOWS]-\>(contact2) return contact2.name limit 5 Why does it make a difference? ---
**Author:** ![andrew\_bowman](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/andrew_bowman/32/73_2.png) [@andrew\_bowman](https://community.neo4j.com/u/andrew_bowman)\ **Post date:** [February 7, 2019, 10:09am UTC](https://community.neo4j.com/t/match-vs-comma-separated-values/1559/6 "2019-02-07T10:09:56Z")
In your example, the thing that makes this a non-issue is that you have the :KNOWS relationships in two different patterns (two separate MATCH clauses), so the uniqueness issue never comes into play. If you had both patterns on a single line: ```auto match (n:Person {name:"Keanu Reeves"})-[:KNOWS]-(f), (f)-[:KNOWS]->(contact2) ... ``` then the issue is very much in play, but would only manifest if the :KNOWS relationship is incoming to Keanu Reeves (and thus matching the direction of your second pattern, the KNOWS relationships outgoing from `f`) (and if there is ONLY a single :KNOWS relationship between Keanu and `f`)...and in that case Keanu would never appear in the `contact2` results, since the :KNOWS relationship would have been traversed once already for the given MATCH, and would not be able to be traversed a second time in order to match the desired pattern. Remember that relationships ALWAYS have a direction, even if you aren't specifying it in your pattern. ---
**Author:** ![rcfro2](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/rcfro2/32/706_2.png) [@rcfro2](https://community.neo4j.com/u/rcfro2)\ **Post date:** [February 7, 2019, 3:14pm UTC](https://community.neo4j.com/t/match-vs-comma-separated-values/1559/7 "2019-02-07T15:14:22Z")
Ok. There is a single outgoing from Keanu -\> to f, so if ( f ) -\> to contac2, then it can't be Keanu. But the case in which Keanu could reappear in the results is in one of the following cases: 1 - Keanu -\> (f ), but there also exists a relationship ( f ) -\> (Keanu) 2 - When a direction is not specified in the pattern, regardless of the direction between the two nodes, so long as a relationship exists, Keanu can be returned in the results Is that correct? ---
**Author:** ![andrew\_bowman](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/andrew_bowman/32/73_2.png) [@andrew\_bowman](https://community.neo4j.com/u/andrew_bowman)\ **Post date:** [February 7, 2019, 7:10pm UTC](https://community.neo4j.com/t/match-vs-comma-separated-values/1559/8 "2019-02-07T19:10:49Z")
Correct that if the only connection between Keanu and f is outgoing toward f, that pattern will never match since it's explicitly looking for the relationship incoming toward Keanu. 1. If two relationships existed between them in opposite directions, you're correct that the pattern could be matched successfully within a single MATCH clause, since both relationships would only need to be traversed once each. 2. If this was within a single MATCH, it depends on both what the query is looking for and also on the actual number/direction of the relationships. If you still only had a single relationship between them and you had the following: ```auto match (n:Person {name:"Keanu Reeves"})-[:KNOWS]-(f), (f)-[:KNOWS]-(contact2) ``` You would still not get Keanu Reeves as a result for contact2. The single :KNOWS relationship between them would be traversed once by one of these, and thus not be available to be traversed for the other :KNOWS in the pattern. Ultimately what this comes down to is the limitation that a specific relationship may only be traversed once within the context of a pattern in a single MATCH (or OPTIONAL MATCH). ---
**Author:** ![rcfro2](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/rcfro2/32/706_2.png) [@rcfro2](https://community.neo4j.com/u/rcfro2)\ **Post date:** [February 7, 2019, 7:22pm UTC](https://community.neo4j.com/t/match-vs-comma-separated-values/1559/9 "2019-02-07T19:22:40Z")
And with 2), is what guarantees the relationship\_path uniqueness, correct? However, if there was a relationship going from (f)-\>(keanu), then the below: ```auto match (n:Person {name:"Keanu Reeves"})-[:KNOWS]-(f), (f)-[:KNOWS]-(contact2) ``` could return Keanu Reeves, correct? ---
**Author:** ![andrew\_bowman](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/andrew_bowman/32/73_2.png) [@andrew\_bowman](https://community.neo4j.com/u/andrew_bowman)\ **Post date:** [February 7, 2019, 7:27pm UTC](https://community.neo4j.com/t/match-vs-comma-separated-values/1559/10 "2019-02-07T19:27:30Z")
Yes, that's the behavior of RELATIONSHIP\_PATH uniqueness. If you meant that there was an ADDITIONAL relationship going from (f)-\>(keanu) (so there would then be two :KNOWS relationships between them) then not only would this query return Keanu for contact2, you would actually see two occurrences of him in the results, because there would be two unique paths that meet this pattern, switching up the order of which :KNOWS relationship fulfills which part of the pattern. ---
**Author:** ![rcfro2](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/rcfro2/32/706_2.png) [@rcfro2](https://community.neo4j.com/u/rcfro2)\ **Post date:** [February 7, 2019, 7:32pm UTC](https://community.neo4j.com/t/match-vs-comma-separated-values/1559/11 "2019-02-07T19:32:16Z")
Yes, I meant there's an additional. So if the nodes had the following relationships: ```auto (keanu) - [:HAS_CONTACT]->(f) (f) - [:HAS_CONTACT]->(keanu) ``` So the question was - ```auto match (n:Person {name:"Keanu Reeves"})-[:KNOWS]-(f), (f)-[:KNOWS]-(contact2) ``` would definitely return Keanu. But why would this now return Keanu twice here? ---
**Author:** ![andrew\_bowman](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/andrew_bowman/32/73_2.png) [@andrew\_bowman](https://community.neo4j.com/u/andrew_bowman)\ **Post date:** [February 7, 2019, 7:36pm UTC](https://community.neo4j.com/t/match-vs-comma-separated-values/1559/12 "2019-02-07T19:36:00Z")
Remember the Cypher is interested in finding all possible paths that match the pattern. It helps to understand if you have a means to differentiate the relationships. Let's say for the sake of example that one of the :KNOWS relationships has its internal id() = 1, and the second has its internal id()=2. There would be two possible paths that match the pattern. The first path uses relationship 1 between `n` and `f` (the first part of the pattern), and relationship 2 between `f` and `contact2` (the second part of the pattern. The second possible path switches the relationships used, so relationship 2 in the first part, relationship 1 in the second part. If you wanted distinct `contact2` results, you can use the DISTINCT keyword for that in your WITH or RETURN. ---
**Author:** ![rcfro2](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/rcfro2/32/706_2.png) [@rcfro2](https://community.neo4j.com/u/rcfro2)\ **Post date:** [February 7, 2019, 8:00pm UTC](https://community.neo4j.com/t/match-vs-comma-separated-values/1559/13 "2019-02-07T20:00:48Z")
ah ok. Yes, i think the simplest explanation is the Cypher query looks for any path match. I generally end up focusing on the structure of how it is in the database and not the query itself. ---
**Author:** ![rcfro2](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/rcfro2/32/706_2.png) [@rcfro2](https://community.neo4j.com/u/rcfro2)\ **Post date:** [February 9, 2019, 7:54pm UTC](https://community.neo4j.com/t/match-vs-comma-separated-values/1559/14 "2019-02-09T19:54:38Z")
Ok, I apologize for the constant ask on this, but this query returned an unexpected result where I would have expected uniqueness. ```auto match (n:Person {name:"Al Pacino"})-[:KNOWS]-(f), (f)-[:KNOWS]-(contact2) where contact2.name = "Al Pacino" return contact2.name ``` Return Al Pacino, twice. I asume this means there must be a path actually going from (f)-[:HAS\_CONTACT]-\>(Al Pacino). That's the only possibility, correct? ```auto match (n:Person {name:"Keanu Reeves"})-[:KNOWS]-(f), (f)-[:KNOWS]-(contact2) where contact2.name = "Keanu Reeves" return contact2.name ``` Where the above doesnt return Keanu Reeves, as expected. I checked the graph, and there is only one Al Pacino node, and one Keanu reeves node. Why do I get this unexpected outcome with Al Pacino node? ---
**Author:** ![andrew\_bowman](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/andrew_bowman/32/73_2.png) [@andrew\_bowman](https://community.neo4j.com/u/andrew_bowman)\ **Post date:** [February 10, 2019, 1:27am UTC](https://community.neo4j.com/t/match-vs-comma-separated-values/1559/15 "2019-02-10T01:27:24Z")
The most likely explanation is that there is a node `f` that has two :KNOWS relationships to Al Pacino. It doesn't matter what direction those relationships are in (since your pattern doesn't have any restrictions on direction). Because there are two :KNOWS relationships, there are two distinct paths that fit the pattern, using the same relationships but in a different order of use.