search

saschamcdonald / ch_06_kuzudb_tests

MIT License
0 stars 0 forks source link

Double-counting relationships #1

Open prrao87 opened 9 months ago

prrao87 commented 9 months ago

The current query that measures the relationship count shows 100M, which is double the number of rows in the relationship_0.parquet file.

It can be fixed by changing L202 to this instead:

        'MATCH (:Person)-[r:WorksAt]->(:Company) RETURN COUNT(r) AS RelationshipCount;').get_next()[0]

This would return 50M in the result table, as intended.

saschamcdonald commented 1 month ago

May thanks @prrao87 I am archiving this repo as the problem I was experiencing has been resolved by the KuzuDB team. I note that I have not fixed the issue you raised. A simple fix, However, as the version issue I was having is now resolved I have decided to archive this repo. Thanks for your help here. Kind regards from @saschamcdonald