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

Graph return incorrect query result on null value filter #5432

Closed
nebula-bots opened this issue Mar 23, 2023 · 1 comment · Fixed by #5433
Closed

Graph return incorrect query result on null value filter #5432

nebula-bots opened this issue Mar 23, 2023 · 1 comment · Fixed by #5433
Assignees
Labels
affects/master PR/issue: this bug affects master version. auto-sync process/done Process of bug severity/major Severity of bug source/automation type/bug Type: something is unexpected
Milestone

Comments

@nebula-bots
Copy link
Contributor

Please check the FAQ documentation before raising an issue

Describe the bug (required)

Look at the query below:

(root@nebula) [gdlancer]> MATCH (v0:Label_0)-[e0]->()-[e1*1..1]->(v1) WHERE (id(v0) == 15) AND ((v1.Label_6.Label_6_4_Int == v1.Label_6.Label_6_5_Int)) return labels(v1),  v1.Label_6.Label_6_4_Int, v1.Label_6.Label_6_5_Int, ((v1.Label_6.Label_6_4_Int == v1.Label_6.Label_6_5_Int))
+-------------+--------------------------+--------------------------+------------------------------------------------------+
| labels(v1)  | v1.Label_6.Label_6_4_Int | v1.Label_6.Label_6_5_Int | (v1.Label_6.Label_6_4_Int==v1.Label_6.Label_6_5_Int) |
+-------------+--------------------------+--------------------------+------------------------------------------------------+
| ["Label_2"] | __NULL__                 | __NULL__                 | __NULL__                                             |
| ["Label_2"] | __NULL__                 | __NULL__                 | __NULL__                                             |
| ["Label_2"] | __NULL__                 | __NULL__                 | __NULL__                                             |
+-------------+--------------------------+--------------------------+------------------------------------------------------+
Got 3 rows (time spent 3.693ms/17.584958ms)

Thu, 12 Jan 2023 17:38:19 CST

(root@nebula) [gdlancer]>

((v1.Label_6.Label_6_4_Int == v1.Label_6.Label_6_5_Int)) evaluate to null but the filter in WHERE (id(v0) == 15) AND ((v1.Label_6.Label_6_4_Int == v1.Label_6.Label_6_5_Int)) did not work and return three wrong result.

Your Environments (required)

How To Reproduce(required)

Steps to reproduce the behavior:

  1. Step 1
  2. Step 2
  3. Step 3

Expected behavior

Additional context

@nebula-bots nebula-bots added affects/master PR/issue: this bug affects master version. auto-sync severity/major Severity of bug source/automation type/bug Type: something is unexpected labels Mar 23, 2023
@xtcyclist xtcyclist self-assigned this Mar 23, 2023
@Sophie-Xie Sophie-Xie added this to the v3.5.0 milestone Mar 24, 2023
@github-actions github-actions bot added the process/fixed Process of bug label Mar 27, 2023
@jinyingsunny jinyingsunny reopened this Apr 11, 2023
@github-actions github-actions bot removed the process/fixed Process of bug label Apr 11, 2023
@jinyingsunny
Copy link

暂时关闭吧

@github-actions github-actions bot added the process/fixed Process of bug label Apr 11, 2023
@nebula-bots nebula-bots removed the process/fixed Process of bug label Apr 11, 2023
@vesoft-inc vesoft-inc deleted a comment from jinyingsunny Apr 11, 2023
@vesoft-inc vesoft-inc deleted a comment from jinyingsunny Apr 11, 2023
@nebula-bots nebula-bots added the process/done Process of bug label Apr 17, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects/master PR/issue: this bug affects master version. auto-sync process/done Process of bug severity/major Severity of bug source/automation type/bug Type: something is unexpected
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants