Using http://console.neo4j.org as a sandbox, I came across the following unexpected behavior:
Statement 1 - returns 1 row with a collection containing Neo Node
MATCH (n:Crew)
WHERE n.name="Neo"
WITH COLLECT(n) AS c1
WITH c1+[] AS c2
RETURN c2
Operator 2 - returns 0 rows (unexpectedly)
MATCH (n:Crew)
WHERE n.name="Neo"
WITH COLLECT(n) AS c1
MATCH (n:Crew)
WHERE n.name="NoOne"
WITH c1+COLLECT(n) AS c2
RETURN c2
Statement 3 - Returns 1 row containing an empty collection
MATCH (n:Crew)
WHERE n.name="NoOne"
WITH COLLECT(n) AS c1
RETURN c1
I do not understand why Statement 2 does not return the same result as Statement 1 , because it must return a collection containing Neo node, as in Statement 1 .
Statement 3 shows that the second MATCHin Statement 2 should result in an empty collection.
Cypher? , , .