Hi Michael, works for me with Neo4j 2.2
http://console.neo4j.org/?id=xy4fkl <http://console.neo4j.org/?id=xy4fkl> Which version are you using? Cheers, Michael > Am 17.04.2015 um 22:03 schrieb Michael Dougherty <[email protected]>: > > Im very confused with what's going wrong....here's my database > > CREATE (queen:Gliese { name : 'Queen'}),(eva:Human { name : > 'Eva'}),(lisha:Human { name : > 'Lisha'}),(queen)<-[:ENEMY_OF]-(eva),(queen)<-[:FRIEND_OF]-(eva),(queen)<-[:FRIEND_OF]-(lisha),(queen)<-[:ENEMY_OF]-(lisha),(lisha)-[:KILLED]->(eva); > > I wanted to return any friend of the queen who killed an enemy of the queen. > > So I wrote the following query > > > MATCH (queen:Gliese{name:'Queen'}) > WITH queen > MATCH (a)-[:FRIEND_OF]->(queen),(b)-[:ENEMY_OF]->(queen),(a)-[:KILLED]->(b) > RETURN a.name, count(*) as count; > > > > Instead of getting lisha, 1, as expected, I get (No rows). > > > > Strangely if I do > > MATCH (a)-[:FRIEND_OF]->(queen),(b)-[:ENEMY_OF]->(queen),(a)-[:KILLED]->(b) > RETURN a.name, count(*) as count; > > alone, I get the expected result. In addition if I do > > > > MATCH (queen:Gliese{name:'Queen'}) > WITH queen > MATCH (a)-[:FRIEND_OF]->(n),(b)-[:ENEMY_OF]->(n),(a)-[:KILLED]->(b) > RETURN a.name, count(*) as count; > > > > I get Lisha, 1 and Eva, 1! I don't really understand these differences! > > In older versions my code seems to work, unless there's some other problem I > don't get. > > > > What's going on here? > > > -- > 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] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- 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.
