Closed
Description
Please check the FAQ documentation before raising an issue
Describe the bug (required)
Your Environments (required)
- OS:
uname -a
- Compiler:
g++ --version
orclang++ --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