Skip to content

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

Closed
@yixinglu

Description

@yixinglu

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

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

affects/nonePR/issue: this bug affects none version.process/fixedProcess of bugseverity/noneSeverity of bugtype/bugType: something is unexpected

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions