Cypher : RETURN p.age, p.age - max(f.age) as result returns null in result #3421
Description
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 resultneo4j returns :
╒═════╤══════╕
│p.age│result│
╞═════╪══════╡
│58 │-12 │
└─────┴──────┘
arcadedb returns :
ArcadeDB - The Next Generation Multi-Model DBMS
result p.age
<null> 58