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

Incorrect match query result(2) #5090

Closed
nebula-bots opened this issue Dec 22, 2022 · 0 comments · Fixed by #5091
Closed

Incorrect match query result(2) #5090

nebula-bots opened this issue Dec 22, 2022 · 0 comments · Fixed by #5091
Labels
affects/master PR/issue: this bug affects master version. auto-sync find/automation process/done Process of bug severity/major Severity of bug 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 queries below:

  1. The first query show that there are 24 rows in the result.
  2. In the second query we change the last where predicate in the first query into its return result, all evaluated to be false, which conflict to the first query
(root@nebula) [gdlancer]> MATCH (v0:Label_4)-[e0:Rel_2]->()<-[e1*1..2]-() WHERE (id(v0) == 17) AND (e0.Rel_2_3_Bool) WITH (e0.Rel_2_1_Double / 0.793772) AS pa0, (- ((- 0.302276) * ((- e0.Rel_2_0_Int) + ((- (e0.Rel_2_5_Int * e0.Rel_2_0_Int)) * 0.686817)))) AS pa1, e0.Rel_2_6_String AS pa2, e0, (e0.Rel_2_1_Double / e0.Rel_2_5_Int) AS pa3, e0.Rel_2_1_Double AS pa4, e0.Rel_2_1_Double AS pa5 WHERE (NOT ((NOT e0.Rel_2_4_Bool) XOR e0.Rel_2_4_Bool)) RETURN count(*) as totalRows
+-----------+
| totalRows |
+-----------+
| 24        |
+-----------+
Got 1 rows (time spent 2.27ms/18.484875ms)

Mon, 05 Dec 2022 16:51:25 CST

(root@nebula) [gdlancer]> MATCH (v0:Label_4)-[e0:Rel_2]->()<-[e1*1..2]-() WHERE (id(v0) == 17) AND (e0.Rel_2_3_Bool) WITH (e0.Rel_2_1_Double / 0.793772) AS pa0, (- ((- 0.302276) * ((- e0.Rel_2_0_Int) + ((- (e0.Rel_2_5_Int * e0.Rel_2_0_Int)) * 0.686817)))) AS pa1, e0.Rel_2_6_String AS pa2, e0, (e0.Rel_2_1_Double / e0.Rel_2_5_Int) AS pa3, e0.Rel_2_1_Double AS pa4, e0.Rel_2_1_Double AS pa5 return (NOT ((NOT e0.Rel_2_4_Bool) XOR e0.Rel_2_4_Bool))
+---------------------------------------------+
| !((!(e0.Rel_2_4_Bool) XOR e0.Rel_2_4_Bool)) |
+---------------------------------------------+
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
| false                                       |
+---------------------------------------------+
Got 24 rows (time spent 2.698ms/24.210666ms)

Mon, 05 Dec 2022 16:51:40 CST

(root@nebula) [gdlancer]>

Your Environments (required)

  • OS: uname -a
  • Compiler: g++ --version or clang++ --version
  • CPU: lscpu
  • Commit id (e.g. a3ffc7d8) ad34bcd (community edition)

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 find/automation severity/major Severity of bug type/bug Type: something is unexpected labels Dec 22, 2022
@Sophie-Xie Sophie-Xie added this to the v3.4.0 milestone Dec 22, 2022
@github-actions github-actions bot added the process/fixed Process of bug label Dec 26, 2022
@nebula-bots nebula-bots added process/done Process of bug and removed process/fixed Process of bug labels Jan 5, 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 find/automation process/done Process of bug severity/major Severity of bug type/bug Type: something is unexpected
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants