Skip to content

Incorrect query result #5147

Closed
Closed
@nebula-bots

Description

@nebula-bots

Please check the FAQ documentation before raising an issue

Describe the bug (required)

Look at the queries below,

the first query pa2 is correctly returned:

(root@nebula) [gdlancer]> MATCH (v0)-[e0]->()<-[e1]-(:Label_2) WHERE (id(v0) in [16, 8, 10, 4, 3, 1, 23, 15, 5, 6, 29]) AND (e0.Rel_0_0_Bool) MATCH (v1:Label_6:Label_3)<-[e2:Rel_1]-(:Label_5)-[e3]->(v2) WHERE (id(v1) in [20, 28, 31, 6, 4, 18, 15, 25, 9, 19, 21]) AND (e0.Rel_0_0_Bool) MATCH p0 = (v2)<-[e4]-()-[e5]->(v3:Label_6) WHERE (e5.Rel_0_0_Bool) WITH min(e3.Rel_2_1_Double) AS pa0, ((- ((((e3.Rel_2_1_Double - e3.Rel_2_1_Double) / (79 / v2.Label_0.Label_0_5_Int)) + e4.Rel_3_3_Int) + (e5.Rel_0_3_Int * e1.Rel_3_3_Int))) / e5.Rel_0_3_Int) AS pa1, e3, v3.Label_6.Label_6_1_Bool AS pa2, (v2.Label_0.Label_0_5_Int / e5.Rel_0_4_Double) AS pa3, 0.089742 AS pa4, ((- 0.756717) == ((- (- e4.Rel_2_1_Double)) - (- v2.Label_0.Label_0_4_Int))) AS pa5, e2 WHERE true RETURN pa2
+------+
| pa2  |
+------+
| true |
| true |
| true |
| true |
| true |
| true |
| true |
| true |
| true |
| true |
| true |
| true |
| true |
| true |
+------+
Got 14 rows (time spent 7.652ms/21.0935ms)

Tue, 27 Dec 2022 17:02:25 CST

and if add pa2 as a filter, graphd complained about BAD_TYPE and the total rows is alow wrong:

(root@nebula) [gdlancer]> MATCH (v0)-[e0]->()<-[e1]-(:Label_2) WHERE (id(v0) in [16, 8, 10, 4, 3, 1, 23, 15, 5, 6, 29]) AND (e0.Rel_0_0_Bool) MATCH (v1:Label_6:Label_3)<-[e2:Rel_1]-(:Label_5)-[e3]->(v2) WHERE (id(v1) in [20, 28, 31, 6, 4, 18, 15, 25, 9, 19, 21]) AND (e0.Rel_0_0_Bool) MATCH p0 = (v2)<-[e4]-()-[e5]->(v3:Label_6) WHERE (e5.Rel_0_0_Bool) WITH min(e3.Rel_2_1_Double) AS pa0, ((- ((((e3.Rel_2_1_Double - e3.Rel_2_1_Double) / (79 / v2.Label_0.Label_0_5_Int)) + e4.Rel_3_3_Int) + (e5.Rel_0_3_Int * e1.Rel_3_3_Int))) / e5.Rel_0_3_Int) AS pa1, e3, v3.Label_6.Label_6_1_Bool AS pa2, (v2.Label_0.Label_0_5_Int / e5.Rel_0_4_Double) AS pa3, 0.089742 AS pa4, ((- 0.756717) == ((- (- e4.Rel_2_1_Double)) - (- v2.Label_0.Label_0_4_Int))) AS pa5, e2 WHERE pa2 RETURN pa2
+----------+
| pa2      |
+----------+
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
| BAD_TYPE |
+----------+
Got 48 rows (time spent 7.91ms/21.079958ms)

Tue, 27 Dec 2022 17:03:58 CST

Your Environments (required)

  • OS: uname -a
  • Compiler: g++ --version or clang++ --version
  • CPU: lscpu
  • Commit id (e.g. a3ffc7d8) 9863ff0 (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