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

using EMPTY exception in match statement #1158

Closed
cooper-lzy opened this issue Jun 21, 2021 · 1 comment
Closed

using EMPTY exception in match statement #1158

cooper-lzy opened this issue Jun 21, 2021 · 1 comment

Comments

@cooper-lzy
Copy link

Judging by a nonexistent property, it is said that all points should be returned.
MATCH (v:player) WHERE v.nadsaesa IS EMPTY return v;
image

This is to determine whether V2 has an age property. Normally, the team point should be filtered out.
MATCH (v:player)--(v2) WHERE v2.age IS NOT EMPTY RETURN labels(v2)
image

@CPWstatic
Copy link
Contributor

IS NOT EMPTY in where clause is applied to the result. That means the result in the 2nd picture is within our expectations. We could use exists in such a situation.

MATCH ... WHERE exists(v2.age) RETURN labels(v2)

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants