This gives me wrong result, an unexpected behavior:
MATCH (n) WHERE id(n) = 123
OPTIONAL MATCH (a:A) -- (n)
WITH n, a, collect(a.actor) as actor
OPTIONAL MATCH (a) -- (n)
When I repeat the WHERE clause, it gives me the correct result:
MATCH (n) WHER...