Re: [Neo4j] Re: Unique constraint not getting respected

2015-10-05 Thread varun kumar
Will surely bring up the old checkpoint and do exact steps to repro. Will be back in a day or so. Thanks a lot for the interest and the response. Thanks On Mon, Oct 5, 2015 at 3:34 AM, Mattias Persson wrote: > Hi, > > That definitely sounds worrying and unexpected. If you could make > available

[Neo4j] Re: Unique constraint not getting respected

2015-10-05 Thread Mattias Persson
Hi, That definitely sounds worrying and unexpected. If you could make available code to reproduce this it would be most helpful. On Sunday, October 4, 2015 at 7:17:06 AM UTC+2, varun kumar wrote: > > I have created a neo4j DB locally and assigned some indices and unique > constraint. > > Here i

Re: [Neo4j] CTE Queries

2015-10-05 Thread Michael Hunger
This query spans up a lot of paths, did you run it with PROFILE on your dataset? Some suggestions: * you don't do anything with the first :SalesRelation is that intentional? if yes then move it to a where clause so it doesn't span up paths * your second match is NOT bound at all? is it is potent

[Neo4j] CTE Queries

2015-10-05 Thread Ryan John Velasco
How do you do CTE queries in neo4j? SAMPLE QUERY: MATCH (rootTopic:Company)-[:Seller|Buyer]->(:SalesRelation) WHERE rootTopic.ID = 172096 MATCH (sellerCompanyTopic:Company)-[rel:Seller]->(sr:SalesRelation)-[rel2:Buyer]-(buyer:Company), sr<-[:PriceAgreement]-(contract:Contract) OPTIONAL MATCH