Skip to content

[CYPHER] Variable-length pattern *2..2 in list comprehension includes nodes at distance 1 #3931

@ExtReMLapin

Description

@ExtReMLapin

Test: variableLengthPatternComprehensionTwoLength (line 400)

Setup (create test data):

CREATE (alice:VarLengthTest3 {name:'Alice'}), 
       (bob:VarLengthTest3 {name:'Bob'}), 
       (charlie:VarLengthTest3 {name:'Charlie'}), 
       (alice)-[:KNOWS]->(bob), 
       (bob)-[:KNOWS]->(charlie), 
       (alice)-[:KNOWS]->(charlie)

Cypher query to execute:

MATCH (a:VarLengthTest3 {name:'Alice'}) RETURN [(a)-[:KNOWS*2..2]->(f:VarLengthTest3) | f.name] AS result

Expected behavior:

[(a)-[:KNOWS*2..2]->(f) | f.name] should return ['Charlie']

ArcadeDB result:

{"result": ["Charlie", "Bob"]}

Neo4j result:

{"result": ["Charlie"]}

The variable-length pattern *2..2 should only return nodes at exactly distance 2, but it includes nodes at distance 1.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions