[CYPHER] String concatenation with || and null returns string instead of null (original) (raw)

Test: stringConcatenationWithPipeAndNull (line 310)

Cypher query to execute:

RETURN 'Hello' || null AS result

Expected behavior:

'Hello' || null should return null

ArcadeDB result:

{"result": "Hello"}

Neo4j result:

{"result": null}

When concatenating a string with null using the || operator, the result should be null, not the original string.