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 #5063

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

Incorrect match query result #5063

nebula-bots opened this issue Dec 15, 2022 · 0 comments · Fixed by #5062
Assignees
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)

The following query return an error and @Shylock-Hg told me that this is beacause variables are no supported in match predicate:

(root@nebula) [testdb]> with [1, 2, 3] as coll unwind coll as vid match (v) where  id(v) == vid return v;
[ERROR (-1005)]: Scan vertices or edges need to specify a limit number, or limit number can not push down.

Thu, 27 Oct 2022 18:23:02 CST

but when I append an or expression, it did executed and return empty result:

(root@nebula) [testdb]> with [1, 2, 3] as coll unwind coll as vid match (v) where id(v) == 0 or id(v) == vid return v;
+---+
| v |
+---+
+---+
Empty set (time spent 1190/1476 us)

Thu, 27 Oct 2022 18:23:03 CST

while neo4j(same schema and dataset) return 3 vertexes as expected:

$ with [1, 2, 3] as coll unwind coll as vid match(v) where v.id = vid or v.id = 0 return v

╒══════════════════════════════════════════════════════════════════════╕
│"v"                                                                   │
╞══════════════════════════════════════════════════════════════════════╡
│{"labelProp_5_1":0.845833,"labelProp_3_3":true,"labelProp_4_2":2,"labe│
│lProp_5_0":0.026265,"labelProp_3_2":"Tracy McGrady","labelProp_4_1":12│
│6,"labelProp_3_1":"Tiago Splitter","labelProp_4_0":false,"labelProp_3_│
│0":97,"labelProp_2_1":false,"labelProp_2_0":"LaMarcus Aldridge","label│
│Prop_1_0":191,"id":1,"labelProp_7_3":true,"labelProp_7_2":0.592624,"la│
│belProp_7_1":"Dejounte Murray","labelProp_5_3":false,"labelProp_7_0":0│
│.247467,"labelProp_5_2":0.249693}                                     │
├──────────────────────────────────────────────────────────────────────┤
│{"labelProp_4_2":132,"labelProp_4_1":12,"labelProp_4_0":true,"labelPro│
│p_2_1":false,"labelProp_2_0":"Kyrie Irving","labelProp_1_0":184,"id":2│
│,"labelProp_7_3":false,"labelProp_7_2":0.589383,"labelProp_7_1":"Kyrie│
│ Irving","labelProp_7_0":0.025194}                                    │
├──────────────────────────────────────────────────────────────────────┤
│{"labelProp_6_0":false,"labelProp_5_1":0.190033,"labelProp_5_0":0.1304│
│14,"labelProp_1_0":90,"labelProp_0_0":true,"id":3,"labelProp_7_3":fals│
│e,"labelProp_6_3":23,"labelProp_7_2":0.159651,"labelProp_6_2":"LaMarcu│
│s Aldridge","labelProp_7_1":"Kobe Bryant","labelProp_5_3":true,"labelP│
│rop_6_1":"Joel Embiid","labelProp_5_2":0.739826,"labelProp_7_0":0.0761│
│9}                                                                    │
└──────────────────────────────────────────────────────────────────────┘

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 find/automation severity/major Severity of bug type/bug Type: something is unexpected labels Dec 15, 2022
@Sophie-Xie Sophie-Xie added this to the v3.4.0 milestone Dec 16, 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.

3 participants