how many paths does this return? MATCH (n:Contact)--(:ActivityContact)--(ar:ActivityReport) RETURN count(*)
the second query causes cypher to use a different pattern matcher (which is suboptimal) but it should not run forever. you can see this if you prefix your queries with PROFILE or EXPLAIN > Am 04.07.2015 um 23:24 schrieb Markus Hofer <[email protected]>: > > The following query works and inserts 8000 nodes in 3 seconds > > > MATCH (n:Contact)--(:ActivityContact)--(ar:ActivityReport) > WHERE ar.StartDateTime > timestamp() > > WITH DISTINCT n, COUNT(ar) AS val > CREATE (s:ScoreFactor { > name: "ContactActivities", > value: val > }) > CREATE (n)-[:HasScoreFactor]->(s) > > > However, if I define ANY variable like, the query runs unlimited and does not > insert any node at all. > I think this is a bug. > > WITH timestamp() AS cutoff > MATCH (n:Contact)--(:ActivityContact)--(ar:ActivityReport) > WHERE ar.StartDateTime > cutoff > > WITH DISTINCT n, COUNT(ar) AS val > CREATE (s:ScoreFactor { > name: "ContactActivities", > value: val > }) > CREATE (n)-[:HasScoreFactor]->(s) > > -- > 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.
