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

Return duplicate columns when all columns are requested in match query #5282

Closed
yixinglu opened this issue Jan 29, 2023 · 0 comments · Fixed by #5443
Closed

Return duplicate columns when all columns are requested in match query #5282

yixinglu opened this issue Jan 29, 2023 · 0 comments · Fixed by #5443
Assignees
Labels
affects/none PR/issue: this bug affects none version. process/fixed Process of bug severity/none Severity of bug type/bug Type: something is unexpected
Milestone

Comments

@yixinglu
Copy link
Contributor

Please check the FAQ documentation before raising an issue

Describe the bug (required)

Your Environments (required)

  • OS: uname -a
  • Compiler: g++ --version or clang++ --version
  • CPU: lscpu
  • Commit id (e.g. a3ffc7d8)
(root@nebula) [nba]> show hosts graph;
+----------------+------+----------+---------+--------------+--------------------------+
| Host           | Port | Status   | Role    | Git Info Sha | Version                  |
+----------------+------+----------+---------+--------------+--------------------------+
| "192.168.15.2" | 4503 | "ONLINE" | "GRAPH" | "66d60b60f"  | "2023.01.13-nightly-ent" |
| "192.168.15.3" | 4503 | "ONLINE" | "GRAPH" | "66d60b60f"  | "2023.01.13-nightly-ent" |
| "192.168.15.4" | 4503 | "ONLINE" | "GRAPH" | "66d60b60f"  | "2023.01.13-nightly-ent" |
+----------------+------+----------+---------+--------------+--------------------------+
Got 3 rows (time spent 722µs/1.219422ms)

How To Reproduce(required)

Steps to reproduce the behavior:

nebula:

(root@nebula) [nba]> match (v:player{name:"Tim Duncan"})-[e:like]-(v2) with v2, sum(e.likeness) as likeness match (v2)-[:serve]-(v3) return *;
+-------------------------------------------------------------------+----------+-------------------------------------------------------------------+------------------------------------------------+
| v2                                                                | likeness | v2                                                                | v3                                             |
+-------------------------------------------------------------------+----------+-------------------------------------------------------------------+------------------------------------------------+
| ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | 55       | ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | ("76ers" :team{name: "76ers"})                 |
| ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | 55       | ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | ("Bulls" :team{name: "Bulls"})                 |
| ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | 55       | ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | ("Hawks" :team{name: "Hawks"})                 |
| ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | 55       | ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | ("Hornets" :team{name: "Hornets"})             |
| ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | 55       | ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | ("Kings" :team{name: "Kings"})                 |
| ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | 55       | ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | ("Raptors" :team{name: "Raptors"})             |
| ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | 55       | ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | ("Spurs" :team{name: "Spurs"})                 |
| ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | 55       | ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | ("Warriors" :team{name: "Warriors"})           |
| ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | 55       | ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | ("Hornets" :team{name: "Hornets"})             |
| ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | 55       | ("Marco Belinelli" :player{age: 32, name: "Marco Belinelli"})     | ("Spurs" :team{name: "Spurs"})                 |
| ("Manu Ginobili" :player{age: 41, name: "Manu Ginobili"})         | 185      | ("Manu Ginobili" :player{age: 41, name: "Manu Ginobili"})         | ("Spurs" :team{name: "Spurs"})                 |
| ("Boris Diaw" :player{age: 36, name: "Boris Diaw"})               | 80       | ("Boris Diaw" :player{age: 36, name: "Boris Diaw"})               | ("Hawks" :team{name: "Hawks"})                 |
| ("Boris Diaw" :player{age: 36, name: "Boris Diaw"})               | 80       | ("Boris Diaw" :player{age: 36, name: "Boris Diaw"})               | ("Hornets" :team{name: "Hornets"})             |
| ("Boris Diaw" :player{age: 36, name: "Boris Diaw"})               | 80       | ("Boris Diaw" :player{age: 36, name: "Boris Diaw"})               | ("Jazz" :team{name: "Jazz"})                   |
| ("Boris Diaw" :player{age: 36, name: "Boris Diaw"})               | 80       | ("Boris Diaw" :player{age: 36, name: "Boris Diaw"})               | ("Spurs" :team{name: "Spurs"})                 |
| ("Boris Diaw" :player{age: 36, name: "Boris Diaw"})               | 80       | ("Boris Diaw" :player{age: 36, name: "Boris Diaw"})               | ("Suns" :team{name: "Suns"})                   |
| ("Shaquile O'Neal" :player{age: 47, name: "Shaquile O'Neal"})     | 80       | ("Shaquile O'Neal" :player{age: 47, name: "Shaquile O'Neal"})     | ("Cavaliers" :team{name: "Cavaliers"})         |
| ("Shaquile O'Neal" :player{age: 47, name: "Shaquile O'Neal"})     | 80       | ("Shaquile O'Neal" :player{age: 47, name: "Shaquile O'Neal"})     | ("Celtics" :team{name: "Celtics"})             |
| ("Shaquile O'Neal" :player{age: 47, name: "Shaquile O'Neal"})     | 80       | ("Shaquile O'Neal" :player{age: 47, name: "Shaquile O'Neal"})     | ("Heat" :team{name: "Heat"})                   |
| ("Shaquile O'Neal" :player{age: 47, name: "Shaquile O'Neal"})     | 80       | ("Shaquile O'Neal" :player{age: 47, name: "Shaquile O'Neal"})     | ("Lakers" :team{name: "Lakers"})               |
| ("Shaquile O'Neal" :player{age: 47, name: "Shaquile O'Neal"})     | 80       | ("Shaquile O'Neal" :player{age: 47, name: "Shaquile O'Neal"})     | ("Magic" :team{name: "Magic"})                 |
| ("Shaquile O'Neal" :player{age: 47, name: "Shaquile O'Neal"})     | 80       | ("Shaquile O'Neal" :player{age: 47, name: "Shaquile O'Neal"})     | ("Suns" :team{name: "Suns"})                   |
| ("Danny Green" :player{age: 31, name: "Danny Green"})             | 70       | ("Danny Green" :player{age: 31, name: "Danny Green"})             | ("Cavaliers" :team{name: "Cavaliers"})         |
| ("Danny Green" :player{age: 31, name: "Danny Green"})             | 70       | ("Danny Green" :player{age: 31, name: "Danny Green"})             | ("Raptors" :team{name: "Raptors"})             |
| ("Danny Green" :player{age: 31, name: "Danny Green"})             | 70       | ("Danny Green" :player{age: 31, name: "Danny Green"})             | ("Spurs" :team{name: "Spurs"})                 |
| ("Dejounte Murray" :player{age: 29, name: "Dejounte Murray"})     | 99       | ("Dejounte Murray" :player{age: 29, name: "Dejounte Murray"})     | ("Spurs" :team{name: "Spurs"})                 |
| ("Tiago Splitter" :player{age: 34, name: "Tiago Splitter"})       | 80       | ("Tiago Splitter" :player{age: 34, name: "Tiago Splitter"})       | ("76ers" :team{name: "76ers"})                 |
| ("Tiago Splitter" :player{age: 34, name: "Tiago Splitter"})       | 80       | ("Tiago Splitter" :player{age: 34, name: "Tiago Splitter"})       | ("Hawks" :team{name: "Hawks"})                 |
| ("Tiago Splitter" :player{age: 34, name: "Tiago Splitter"})       | 80       | ("Tiago Splitter" :player{age: 34, name: "Tiago Splitter"})       | ("Spurs" :team{name: "Spurs"})                 |
| ("Aron Baynes" :player{age: 32, name: "Aron Baynes"})             | 80       | ("Aron Baynes" :player{age: 32, name: "Aron Baynes"})             | ("Celtics" :team{name: "Celtics"})             |
| ("Aron Baynes" :player{age: 32, name: "Aron Baynes"})             | 80       | ("Aron Baynes" :player{age: 32, name: "Aron Baynes"})             | ("Pistons" :team{name: "Pistons"})             |
| ("Aron Baynes" :player{age: 32, name: "Aron Baynes"})             | 80       | ("Aron Baynes" :player{age: 32, name: "Aron Baynes"})             | ("Spurs" :team{name: "Spurs"})                 |
| ("Tony Parker" :player{age: 36, name: "Tony Parker"})             | 190      | ("Tony Parker" :player{age: 36, name: "Tony Parker"})             | ("Hornets" :team{name: "Hornets"})             |
| ("Tony Parker" :player{age: 36, name: "Tony Parker"})             | 190      | ("Tony Parker" :player{age: 36, name: "Tony Parker"})             | ("Spurs" :team{name: "Spurs"})                 |
| ("LaMarcus Aldridge" :player{age: 33, name: "LaMarcus Aldridge"}) | 75       | ("LaMarcus Aldridge" :player{age: 33, name: "LaMarcus Aldridge"}) | ("Spurs" :team{name: "Spurs"})                 |
| ("LaMarcus Aldridge" :player{age: 33, name: "LaMarcus Aldridge"}) | 75       | ("LaMarcus Aldridge" :player{age: 33, name: "LaMarcus Aldridge"}) | ("Trail Blazers" :team{name: "Trail Blazers"}) |
+-------------------------------------------------------------------+----------+-------------------------------------------------------------------+------------------------------------------------+
Got 36 rows (time spent 5.08ms/6.431308ms)

Sun, 29 Jan 2023 14:01:04 CST

neo4j:

╒══════════╤══════════════════════════════════════════════════════════════════╤═══════════════════════════════════════════════╕
│"likeness"│"v2"                                                              │"v3"                                           │
╞══════════╪══════════════════════════════════════════════════════════════════╪═══════════════════════════════════════════════╡
│80        │{"name":"Shaquile O'Neal","age":47,"player":"Shaquile O'Neal"}    │{"name":"Celtics","team":"Celtics"}            │
├──────────┼──────────────────────────────────────────────────────────────────┼───────────────────────────────────────────────┤
│80        │{"name":"Shaquile O'Neal","age":47,"player":"Shaquile O'Neal"}    │{"name":"Cavaliers","team":"Cavaliers"}        │
├──────────┼──────────────────────────────────────────────────────────────────┼───────────────────────────────────────────────┤
│80        │{"name":"Shaquile O'Neal","age":47,"player":"Shaquile O'Neal"}    │{"name":"Lakers","team":"Lakers"}              │
├──────────┼──────────────────────────────────────────────────────────────────┼───────────────────────────────────────────────┤
│80        │{"name":"Shaquile O'Neal","age":47,"player":"Shaquile O'Neal"}    │{"name":"Magic","team":"Magic"}                │
├──────────┼──────────────────────────────────────────────────────────────────┼───────────────────────────────────────────────┤
│80        │{"name":"Shaquile O'Neal","age":47,"player":"Shaquile O'Neal"}    │{"name":"Suns","team":"Suns"}                  │
├──────────┼──────────────────────────────────────────────────────────────────┼───────────────────────────────────────────────┤
│80        │{"name":"Shaquile O'Neal","age":47,"player":"Shaquile O'Neal"}    │{"name":"Heat","team":"Heat"}                  │
├──────────┼──────────────────────────────────────────────────────────────────┼───────────────────────────────────────────────┤

Expected behavior

the column v2 is duplicated in response results for above query.

Additional context

@yixinglu yixinglu added the type/bug Type: something is unexpected label Jan 29, 2023
@github-actions github-actions bot added affects/none PR/issue: this bug affects none version. severity/none Severity of bug labels Jan 29, 2023
@xtcyclist xtcyclist self-assigned this Feb 27, 2023
@Sophie-Xie Sophie-Xie added this to the v3.5.0 milestone Feb 27, 2023
@github-actions github-actions bot added the process/fixed Process of bug label Mar 28, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects/none PR/issue: this bug affects none version. process/fixed Process of bug severity/none Severity of bug type/bug Type: something is unexpected
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants