Hi, in the Play Movie Graph I've experimented few Cypher queries. One query was
MATCH (p)-[r1]-(m) , (p)-[r2]-(m) , (p2)-[]-(m) , (p2)-[]-(m1) , (p3)-[r3]-(m1) , (p3)-[r4]-(m1) where (r1<>r2 and m<>m1 and r3<>r4 and p3<>p and p2<>p and p3<>p2) RETURN p,p2,m1,m searching people that are related in at least two movie where both have a people that are related to it with two different properties. If I modify the query as: MATCH (p)-[r1]-(m) , (p)-[r2]-(m) , (p2)-[]-(m) , (p2)-[]-(m1) , (p3)-[r3]-(m1) , (p3)-[r4]-(m1) where (r1<>r2 and m<>m1 and r3<>r4 and p3<>p and p2<>p and p3<>p2) or (p2.name='Keanu Reeves') RETURN p,p2,m1,m searching why Keanu Reeves that is related to the Matrix trilogy is not listed (now I know why, it is not the problem here) I obtain the following error: key not found: Identifier(p3) I don't understand why this error only because I added an or clause in where statement on p2. It is a normal behavior? why? Thanks in advance. -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
