kuzudb / explorer

Browser-based user interface for Kùzu graph database
https://hub.docker.com/r/kuzudb/explorer
MIT License
29 stars 5 forks source link

Multi-edge not being shown correctly #169

Closed prrao87 closed 1 month ago

prrao87 commented 1 month ago

I'm running this query to calculate the number of incoming transactions to a person's account:

MATCH (a0:Account)-[t:Transfer]->(a1:Account)<-[:Owns]-(p:Person)
WHERE p.name = "Amanda"
RETURN p.name, a0.id, a1.id, COUNT(t)

image

It shows there's a multi-edge between two accounts with the same primary keys (hence the COUNT(t) is 2 for the last row). However, when I try to display the nodes with the following query, the multi-edge isn't displayed, giving me the wrong impression that there's only 3 incoming transactions.

MATCH (a0:Account)-[t:Transfer]->(a1:Account)<-[:Owns]-(p:Person)
WHERE p.name = "Amanda"
RETURN *;

image

Can we update it so that the multi-edge is displayed?