Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MATCH where condition doesn't work #4042

Closed
mizy opened this issue Mar 17, 2022 · 1 comment
Closed

MATCH where condition doesn't work #4042

mizy opened this issue Mar 17, 2022 · 1 comment
Assignees
Labels
community Source: who proposed the issue type/bug Type: something is unexpected
Milestone

Comments

@mizy
Copy link

mizy commented Mar 17, 2022

Describe the bug (required)

MATCH (v1:player)-[e0:`serve`{start_year:2011}]->()
RETURN e0 LIMIT 100

image

MATCH (v1:player)-[e0:`serve`{start_year}]->()
WHERE  ( e0.serve.start_year == 2011) 
RETURN e0 LIMIT 100 

has no result

Your Environments (required)
docker-compose

How To Reproduce(required)
https://github.com/vesoft-inc/nebula-docs/blob/master/docs-2.0/basketballplayer-2.X.ngql

indexes
截屏2022-03-17 上午11 36 02

Expected behavior

Additional context

profile MATCH (v1:player)-[e0:`serve`]->()
WHERE  ( e0.serve.start_year == 2011) 
RETURN e0 LIMIT 100

image

@mizy mizy added the type/bug Type: something is unexpected label Mar 17, 2022
@Sophie-Xie Sophie-Xie added this to the v3.1.0 milestone Mar 17, 2022
@Shylock-Hg
Copy link
Contributor

Shylock-Hg commented Mar 23, 2022

Hello mizy.
I think it's a mistake of usage.
You should try:

MATCH (v1:player)-[e0:`serve`]->() WHERE  ( e0.start_year == 2011) RETURN e0 LIMIT 100

Edge property should follow format like edge.prop, so e0.serve.start_year will get NULL value in you case, so after filter, there are no results. And this behavior is correct in open cypher.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
community Source: who proposed the issue type/bug Type: something is unexpected
Projects
None yet
Development

No branches or pull requests

4 participants