Skip to content
This repository has been archived by the owner on Dec 1, 2022. It is now read-only.

Exist doesn't work for NULL value #1215

Closed
HarrisChu opened this issue Jul 7, 2021 · 0 comments · Fixed by #1226
Closed

Exist doesn't work for NULL value #1215

HarrisChu opened this issue Jul 7, 2021 · 0 comments · Fixed by #1226
Assignees
Labels
incompatible PR: incompatible with the master branches in the storage or common repos

Comments

@HarrisChu
Copy link
Contributor

(root@nebula) [nba]> match (n:player) WHERE not exists(n.name) return n
Empty set (time spent 7844/11330 us)

Wed, 07 Jul 2021 14:04:24 CST

(root@nebula) [nba]>
(root@nebula) [nba]>
(root@nebula) [nba]>
(root@nebula) [nba]> match (n:player) WHERE n.name is null return n
+--------------------------------------------+
| n                                          |
+--------------------------------------------+
| ("Null4" :player{age: -4, name: __NULL__}) |
+--------------------------------------------+
| ("Null3" :player{age: -3, name: __NULL__}) |
+--------------------------------------------+
| ("Null2" :player{age: -2, name: __NULL__}) |
+--------------------------------------------+
| ("Null1" :player{age: -1, name: __NULL__}) |
+--------------------------------------------+
Got 4 rows (time spent 6591/10193 us)

Wed, 07 Jul 2021 14:04:27 CST

in neo4j
image

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
incompatible PR: incompatible with the master branches in the storage or common repos
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants