ArcadeData / arcadedb

ArcadeDB Multi-Model Database, one DBMS that supports SQL, Cypher, Gremlin, HTTP/JSON, MongoDB and Redis. ArcadeDB is a conceptual fork of OrientDB, the first Multi-Model DBMS. ArcadeDB supports Vector Embeddings.
https://arcadedb.com
Apache License 2.0
469 stars 57 forks source link

Returning the edges in the query duplicates them in the Studio graph display #1620

Open ExtReMLapin opened 1 month ago

ExtReMLapin commented 1 month ago

Hello, It's me again

ArcadeDB Version:

ArcadeDB Server v24.5.1-SNAPSHOT (build 71472c4c05ae9278d0d5d71a919b31883e1ea767/1713899543605/main) is starting up... creating nodes and reading nodes

OS and JDK Version:

Running on Linux 5.15.0-100-generic - OpenJDK 64-Bit Server VM 11.0.22 for creating nodes and reading nodes

Expected behavior

Edges should not be duplicated in the graph

Actual behavior

They are duplicated

Steps to reproduce

As you know, in Studio, if you only request of Nodes in your query, the graph display will also display edges between those nodes for the sake of simplicity.

At the bottom it returns the count of displayed Edges and Nodes.

For example :

MATCH (a)-[rel]-(b) return a, b

Displayed 29 vertices and 82 edges.

But if you return also the edges in your query, the count will be doubled :

MATCH (a)-[rel]-(b) return a, b, rel

Displayed 29 vertices and 164 edges.

It's a small bug but it might be misleading as when hiding a node with cytoscape.js, it actually hide both (by ID I guess).

image image