neo4j-contrib / rabbithole

Interactive, embeddable Neo4j-Console
http://rabbithole.heroku.com
79 stars 41 forks source link

MATCH (u:User)-[r]-(t) RETURN u.id isn't a superset of MATCH (u:User)-[r]-(t:Timeslip) RETURN u.id? #77

Closed whatSocks closed 10 years ago

whatSocks commented 10 years ago

I understand that

MATCH (u:User)-[r]-(t) RETURN DISTINCT u.id should return a superset of MATCH (u:User)-[r]-(t:Timeslip) RETURN DISTINCT u.id, but this seems to be not happening:

neo4j-sh (?)$ match (u:User)-[r]-(b) return distinct u.id;
==> +--------+
==> | u.id   |
==> +--------+
==> | 220192 |
==> | 256746 |
==> | 264374 |
==> +--------+
==> 3 rows
==> 18 ms
neo4j-sh (?)$ match (u:User)-[r]-(b:Timeslip) return distinct u.id;
==> +--------+
==> | u.id   |
==> +--------+
==> | 236985 |
==> | 283070 |
==> | 273840 |
==> | 208398 |
==> | 208401 |
==> | 262101 |
==> | 279178 |
==> | 235911 |
==> | 208400 |
==> | 268785 |
==> | 208399 |
==> | 264374 |
==> | 220192 |
==> | 256746 |
==> +--------+
==> 14 rows
==> 1010 ms

The first one stops working after 18 ms and returns too few Users, the second works for 1010 ms and returns 14 users.

Why the difference?

jexp commented 10 years ago

Where is your dataset? Do you have a shared link or graphgist?

jexp commented 10 years ago

Seems to be a broken label-scan-store, please copy this issue to http://github.com/neo4j/neo4j/issues