Hi Richard, I'm forwarding this message on to our Google Group, they should be able to address it there.
Best, Hank On Tue, Mar 10, 2015 at 5:45 AM, Richard George < [email protected]> wrote: > > > Odd, your UK address is bouncing > > > > *From:* Richard George > *Sent:* 10 March 2015 12:37 > *To:* '[email protected]' > *Subject:* Bug in Neo4j collection > > > > Hi > > > > I think I have found a bug with NEO4J, or at least behaviour that I do not > understand. I have nodes for both Authors and Articles. Authors can have > multiple articles using the :WROTE relationship, and articles can have > multiple authors with the inverse of the same relationship. When I run the > first command below, simply finding the top ten articles by number of > authors, I get the correct answer. If I run the second command which just > takes the MATCH, puts it into a collection, then extracts from the > collection, I get the articles in the wrong order and some missing. I also > notice that the number of row returned is 9, even though there are 10 rows. > I would appreciate it if you could take a look and let me know if I am > doing anything wrong or if there is a problem with the product. > > > > Regards, Richard > > > > > > MATCH (article:Article)<-[:WROTE]-(author:Author) > > RETURN article.title, count(author) AS numberofauthors ORDER BY > numberofauthors DESC LIMIT 10 > > > > *article.title* > > *numberofauthors* > > Identification of heart rate-associated loci and their effects on cardiac > conduction and rhythm disorders. > > 274 > > Genetic association study of QT interval highlights role for calcium > signaling pathways in myocardial repolarization. > > 235 > > [Brazilian guidelines on platelet antiaggregants and anticoagulants in > cardiology]. > > 101 > > Dabigatran in patients with mechanical heart valves. > > 96 > > Updated standardized endpoint definitions for transcatheter aortic valve > implantation: the Valve Academic Research Consortium-2 consensus document. > > 90 > > Meta-analysis identifies six new susceptibility loci for atrial > fibrillation. > > 89 > > 2011 ACCF/AHA/HRS focused update on the management of patients with atrial > fibrillation (Updating the 2006 Guideline): a report of the American > College of Cardiology Foundation/American Heart Association Task Force on > Practice Guidelines. > > 83 > > 2013 ESC Guidelines on cardiac pacing and cardiac resynchronization > therapy: the Task Force on cardiac pacing and resynchronization therapy of > the European Society of Cardiology (ESC). Developed in collaboration with > the European Heart Rhythm Association (EHRA). > > 72 > > 2012 ACCF/AHA/HRS focused update of the 2008 guidelines for device-based > therapy of cardiac rhythm abnormalities: a report of the American College > of Cardiology Foundation/American Heart Association Task Force on Practice > Guidelines. > > 72 > > Personalized management of atrial fibrillation: Proceedings from the > fourth Atrial Fibrillation competence NETwork/European Heart Rhythm > Association consensus conference. > > 72 > > Returned 10 rows in 924 ms > > > > MATCH (article:Article)<-[:WROTE]-(author:Author) > > WITH article, count(author) AS numberofauthors ORDER BY numberofauthors > DESC LIMIT 10 > > WITH numberofauthors, collect(article)[0..9] AS top_10_articles > > RETURN EXTRACT(n in top_10_articles | n.title) AS title, numberofauthors > > > > *title* > > *numberofauthors* > > Genetic association study of QT interval highlights role for calcium > signaling pathways in myocardial repolarization. > > 235 > > Personalized management of atrial fibrillation: Proceedings from the > fourth Atrial Fibrillation competence NETwork/European Heart Rhythm > Association consensus conference., 2013 ESC Guidelines on cardiac pacing > and cardiac resynchronization therapy: the Task Force on cardiac pacing and > resynchronization therapy of the European Society of Cardiology (ESC). > Developed in collaboration with the European Heart Rhythm Association > (EHRA). > > 72 > > Third universal definition of myocardial infarction. > > 60 > > [Brazilian guidelines on platelet antiaggregants and anticoagulants in > cardiology]. > > 101 > > Novel genetic markers associate with atrial fibrillation risk in Europeans > and Japanese. > > 62 > > Meta-analysis identifies six new susceptibility loci for atrial > fibrillation. > > 89 > > Common variants at SCN5A-SCN10A and HEY2 are associated with Brugada > syndrome, a rare disease with high risk of sudden cardiac death. > > 65 > > Common genetic variation near the connexin-43 gene is associated with > resting heart rate in African Americans: a genome-wide association study of > 13,372 participants. > > 59 > > Identification of heart rate-associated loci and their effects on cardiac > conduction and rhythm disorders. > > 274 > > Returned 9 rows in 704 ms > > > > > > > > > > > > Richard George > > Software manager > > www.agcpartners.co.uk > > Unit 41 Pall Mall Deposit, 124-128 Barlby Road, London W10 6BL, UK > > > > [image: cid:7B31677A-84B9-4D54-939C-4AD0CF0ABC48] > > > > Company registration number: 08113167 Place of Registration: England > > Registered Address: Winnington House, 2 Woodberry Grove, North > Finchley, London, N12 0DR > > > > *This message is private and confidential. If you have received this > message in error, please notify us and remove it from your system.* > > > -- 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.
