Two below match queries get different results

[yixinglu]

following queries get the same results in sf100 dataset:

MATCH (person:Person)-[:KNOWS]-(friend)
WHERE id(person) == "p-65504"
WITH person, collect(id(friend)) AS friends
MATCH (person:Person)-[:KNOWS*2]-(friend)-[:IS_LOCATED_IN]->(city:Place)
WHERE id(friend) != "p-65504" AND id(friend) NOT IN friends
WITH person, city, friend, datetime(friend.Person.birthday) as birthday
WHERE (birthday.month==5 AND birthday.day>=21) OR
        (birthday.month==(5%12)+1 AND birthday.day<22)
RETURN DISTINCT friend, city, person
//-------
MATCH (person:Person)-[:KNOWS*2]-(friend)-[:IS_LOCATED_IN]->(city:Place)
WHERE id(person) == "p-65504" AND id(friend) != "p-65504" AND NOT (person)-[:KNOWS]-(friend)
WITH person, city, friend, datetime(friend.Person.birthday) as birthday
WHERE (birthday.month==5 AND birthday.day>=21) OR
        (birthday.month==(5%12)+1 AND birthday.day<22)
RETURN DISTINCT friend, city, person

But I get different results in below match statements:

MATCH (person:Person)-[:KNOWS]-(friend)
WHERE id(person) == "p-65504"
WITH person, collect(id(friend)) AS friends
MATCH (person:Person)-[:KNOWS*2]-(friend)-[:IS_LOCATED_IN]->(city:Place)
WHERE id(friend) != "p-65504" AND id(friend) NOT IN friends
WITH person, city, friend, datetime(friend.Person.birthday) as birthday
WHERE (birthday.month==5 AND birthday.day>=21) OR
        (birthday.month==(5%12)+1 AND birthday.day<22)
WITH DISTINCT friend, city, person
OPTIONAL MATCH (friend)<-[:POST_HAS_CREATOR]-(post:Post)
OPTIONAL MATCH (person)-[:HAS_INTEREST]->()<-[:HAS_TAG]-(post)
RETURN friend, city
//--------
MATCH (person:Person)-[:KNOWS*2]-(friend)-[:IS_LOCATED_IN]->(city:Place)
WHERE id(person) == "p-65504" AND id(friend) != "p-65504" AND NOT (person)-[:KNOWS]-(friend)
WITH person, city, friend, datetime(friend.Person.birthday) as birthday
WHERE (birthday.month==5 AND birthday.day>=21) OR
        (birthday.month==(5%12)+1 AND birthday.day<22)
WITH DISTINCT friend, city, person
OPTIONAL MATCH (friend)<-[:POST_HAS_CREATOR]-(post:Post)
OPTIONAL MATCH (person)-[:HAS_INTEREST]->()<-[:HAS_TAG]-(post)
RETURN friend, city

[yixinglu]

I think we could NOT only allow the vertex output result as argument node reference variable. The right way to reference the variable in argument node is like the above image, the argument only concern the variable depended on.

[yixinglu]

I update the query in following format, the execution plan become expected, the difference is only aliases in with clause.

MATCH (person:Person)-[:KNOWS]-(friend)
WHERE id(person) == "p-65504"
WITH person, collect(id(friend)) AS friends
MATCH (person:Person)-[:KNOWS*2]-(friend)-[:IS_LOCATED_IN]->(city:Place)
WHERE id(friend) != "p-65504" AND id(friend) NOT IN friends
WITH person, city, friend, datetime(friend.Person.birthday) as birthday
WHERE (birthday.month==5 AND birthday.day>=21) OR
        (birthday.month==(5%12)+1 AND birthday.day<22)
WITH DISTINCT friend AS f, city AS c, person AS p
OPTIONAL MATCH (f)<-[:POST_HAS_CREATOR]-(post:Post)
OPTIONAL MATCH (p)-[:HAS_INTEREST]->()<-[:HAS_TAG]-(post)
RETURN f, c