nebula icon indicating copy to clipboard operation
nebula copied to clipboard

Match statement hanging edge problem

Open czpmango opened this issue 3 years ago • 0 comments
trafficstars

Inconsistent handling of dangling edges leads to incorrect results.

Environments nebula 3.x

How To Reproduce

(root@nebula) [nba]> insert edge like() values "Tim Duncan"->"emptyPoint":()
Execution succeeded (time spent 2049/2361 us)

(root@nebula) [nba]> go from "Tim Duncan" over like yield like._dst,$$.player.age
+-----------------+---------------+
| like._dst       | $$.player.age |
+-----------------+---------------+
| "Manu Ginobili" | 41            |
| "Tony Parker"   | 36            |
| "emptyPoint"    | __NULL__      |
+-----------------+---------------+
Got 3 rows (time spent 3504/3903 us)

(root@nebula) [nba]> match (v)-[:like]->(n) where id(v)=="Tim Duncan" return v
+-------------------------------------------------------------------------------------------------------------+
| v                                                                                                           |
+-------------------------------------------------------------------------------------------------------------+
| ("Tim Duncan" :player{age: 42, name: "Tim Duncan"} :bachelor{name: "Tim Duncan", speciality: "psychology"}) |
| ("Tim Duncan" :player{age: 42, name: "Tim Duncan"} :bachelor{name: "Tim Duncan", speciality: "psychology"}) |
+-------------------------------------------------------------------------------------------------------------+
Got 2 rows (time spent 5232/5640 us)

(root@nebula) [nba]> match (v)-[:like]->() where id(v)=="Tim Duncan" return v
+-------------------------------------------------------------------------------------------------------------+
| v                                                                                                           |
+-------------------------------------------------------------------------------------------------------------+
| ("Tim Duncan" :player{age: 42, name: "Tim Duncan"} :bachelor{name: "Tim Duncan", speciality: "psychology"}) |
| ("Tim Duncan" :player{age: 42, name: "Tim Duncan"} :bachelor{name: "Tim Duncan", speciality: "psychology"}) |
| ("Tim Duncan" :player{age: 42, name: "Tim Duncan"} :bachelor{name: "Tim Duncan", speciality: "psychology"}) |
+-------------------------------------------------------------------------------------------------------------+
Got 3 rows (time spent 3606/4029 us)

Expected behavior Query behave consistently for dangling edges.

czpmango avatar Aug 11 '22 06:08 czpmango