Cypher : isEmpty thinks null is empty #3447
Description
Hello,
Creation query :
CREATE (keanu:Person {name:'Keanu Reeves', age:58, nationality:'Canadian'}),
(carrie:Person {name:'Carrie Anne Moss', age:55, nationality:'American'}),
(liam:Person {name:'Liam Neeson', age:70, nationality:'Northern Irish'}),
(guy:Person {name:'Guy Pearce', age:55, nationality:'Australian'}),
(kathryn:Person {name:'Kathryn Bigelow', age:71, nationality:'American'}),
(jessica:Person {name:'Jessica Chastain', age:45, address:''}),
(theMatrix:Movie {title:'The Matrix'}),
(keanu)-[:KNOWS {since: 1999}]->(carrie),
(keanu)-[:KNOWS {since: 2005}]->(liam),
(keanu)-[:KNOWS {since: 2010}]->(kathryn),
(kathryn)-[:KNOWS {since: 2012}]->(jessica),
(carrie)-[:KNOWS {since: 2008}]->(guy),
(liam)-[:KNOWS {since: 2009}]->(guy),
(keanu)-[:ACTED_IN]->(theMatrix),
(carrie)-[:ACTED_IN]->(theMatrix)
Query to execute :
MATCH (p:Person) WHERE isEmpty(p.address) RETURN p.name AS result, p.addressneo4j returns :
╒══════════════════╤═════════╕
│result │p.address│
╞══════════════════╪═════════╡
│"Jessica Chastain"│"" │
└──────────────────┴─────────┘
arcadedb returns :
ArcadeDB - The Next Generation Multi-Model DBMS
result p.address
Keanu Reeves <null>
Carrie Anne Moss <null>
Liam Neeson <null>
Guy Pearce <null>
Kathryn Bigelow <null>
Jessica Chastain