ArcadeDB Version: ArcadeDB Server v23.1.1 (build aa687e4/1673895089679/main)

JDK Version: OpenJDK (zsrc11.54.25-jdk11.0.14.1) [I think]

OS: Windows 11 Home (21H2)

Expected behavior

2 rows are returned.
This can be seen when testing the same query in neo4j:

Actual behavior

1 row is returned

Steps to reproduce

1. Run create cypher query in ArcadeDB studio:

CREATE (bob:Dwarf)
CREATE (dave:Dwarf)
CREATE (galadriel:Elf)
CREATE (galadriel)-[:KNOWS]->(bob)
CREATE (galadriel)-[:KNOWS]->(dave)

2. Run read cypher query in ArcadeDB studio:

MATCH (elfs:Elf)-[:KNOWS]->(foo)
RETURN elfs;

Note

This is a serious fundamental inconsistency between what is expected from neo4j queries vs ArcadeDB. I've been trying to adapt an existing codebase to use ArcadeDB instead of neo4j, and this completes breaks a lot of queries - especially ones that are slightly more complex. It hurts my expectation that ArcadeDB is a well-tested system that will also work without bugs for other queries I have and that I should expect more such surprises.