Skip to content

Incorrect match query result(2) #5090

Closed
@nebula-bots

Description

@nebula-bots

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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions