nebula
nebula copied to clipboard
Match statement hanging edge problem
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.