Closed
Description
Please check the FAQ documentation before raising an issue
Describe the bug (required)
Look at the queries below:
- The first query show that there are 24 rows in the result.
- 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
orclang++ --version
- CPU:
lscpu
- Commit id (e.g.
a3ffc7d8
) ad34bcd (community edition)
How To Reproduce(required)
Steps to reproduce the behavior:
- Step 1
- Step 2
- Step 3
Expected behavior
Additional context