Hi,
I am going though cypher learning exercises.
I ran a below query and was expecting a single return row.
MATCH (p:Person)-[ACTED_IN]->(m:Movie)
WHERE p.name = 'Tom Hanks' and m.title = 'That Thing You Do'
RETURN m.title
RESULT
โโโโโโโโโโโโโโโโโโโโโ
โ"m.title" โ
โโโโโโโโโโโโโโโโโโโโโก
โ"That Thing You Do"โ
โโโโโโโโโโโโโโโโโโโโโค
โ"That Thing You Do"โ
โโโโโโโโโโโโโโโโโโโโโ
wherein below query brings single movie node only
MATCH (p:Person)-[ACTED_IN]->(m:Movie)
WHERE p.name = 'Tom Hanks' and m.title = 'That Thing You Do'
RETURN m
is my expectation or understanding wrong? Can someone help me understand this behavior with some pointers?
Thanks in advance.
-Puneet