Test: variableLengthPatternComprehensionZeroLength (line 361)
Setup (create test data):
CREATE (alice:VarLengthTest {name:'Alice'}),
(bob:VarLengthTest {name:'Bob'}),
(charlie:VarLengthTest {name:'Charlie'}),
(alice)-[:KNOWS]->(bob),
(bob)-[:KNOWS]->(charlie),
(alice)-[:KNOWS]->(charlie)Cypher query to execute:
MATCH (a:VarLengthTest {name:'Alice'}) RETURN [(a)-[:KNOWS*0..0]->(f:VarLengthTest) | f.name] AS resultExpected behavior:
[(a)-[:KNOWS*0..0]->(f) | f.name] where a is 'Alice' should return ['Alice']
ArcadeDB result:
{"result": ["Charlie", "Bob"]}Neo4j result:
A zero-length variable-length pattern should return the anchor node itself, but it returns other nodes instead.
Test:
variableLengthPatternComprehensionZeroLength(line 361)Setup (create test data):
Cypher query to execute:
Expected behavior:
ArcadeDB result:
{"result": ["Charlie", "Bob"]}Neo4j result:
{"result": ["Alice"]}A zero-length variable-length pattern should return the anchor node itself, but it returns other nodes instead.