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