Cypher : RETURN p.age, p.age - max(f.age) as result returns null in result (original) (raw)

Hello,

Creation query :

        CREATE (k:Person {name: 'Keanu Reeves', age: 58})-[:KNOWS]->(:Person {age: 70}),
               (k)-[:KNOWS]->(:Person {age: 55})

Query to execute :

        MATCH (p:Person {name:'Keanu Reeves'})-[:KNOWS]-(f:Person)
        RETURN p.age, p.age - max(f.age) as result

neo4j returns :

╒═════╤══════╕
│p.age│result│
╞═════╪══════╡
│58   │-12   │
└─────┴──────┘

arcadedb returns :

ArcadeDB - The Next Generation Multi-Model DBMS

result	p.age
<null>	58