Can you run it with PROFILE and share the result picture? Then you'll see where it stops finding data.
On Fri, Apr 28, 2017 at 4:52 PM, Igor Azarny <[email protected]> wrote: > Hi All > > I've to migrate solution from neo4j 2nd version to 3rd. The query below > works ok in 2nd version, but does not return any result in 3rd version on > the same data. > MATCH (p:Partner{active: true})-[relation:ADDRESS_RELATION{active: > true}]->(:Address{active: true}) > WHERE id(p) = {partnerId} > RETURN relation > > Even simple query like this one > MATCH ()-[r0:`ADDRESS_RELATION`]-() RETURN r0 > stop working. > > However more complex form like this one > MATCH ()-[r0:`ADDRESS_RELATION`]-() > WITH r0,startnode(r0) AS n, endnode(r0) AS m > MATCH p1 = (n)-[*0..1]-() > WITH r0, COLLECT(DISTINCT p1) AS startPaths, m MATCH p2 = (m)-[*0..1]-() > WITH r0, startPaths, COLLECT(DISTINCT p2) AS endPaths > WITH ID(r0) AS rId,startPaths + endPaths AS paths UNWIND paths AS p > RETURN DISTINCT p, rId > work as expected in 3rd version. > > Any ideas ? Did I miss something during migration ? Any help will be > appreciated. > > Thanks ! > > > > -- > 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. > -- 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.
