Skip to content

[CYPHER] CASE null WHEN null returns matched instead of not_matched #3922

@ExtReMLapin

Description

@ExtReMLapin

Test: caseNullWhenNullDoesNotMatch (line 201)

Cypher query to execute:

RETURN CASE null WHEN null THEN 'matched' ELSE 'not_matched' END AS result

Expected behavior:

CASE null WHEN null THEN 'matched' ELSE 'not_matched' END should return 'not_matched'

ArcadeDB result:

{"result": "matched"}

Neo4j result:

{"result": "not_matched"}

In a simple CASE expression, null should never equal null. The comparison null = null yields null, not true, so the ELSE branch should be taken.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions