Skip to content

match can not filter by rank(e) #5123

Closed
@nebula-bots

Description

@nebula-bots

Please check the FAQ documentation before raising an issue
use rank(e)==2 in where statement, however return rank(e)=0;

 match ()-[e]->() where rank(e) == 2 return e limit 10

result is:

(root@nebula) [backup_sf100]> profile match ()-[e]->() where rank(e) == 2 return e limit 10
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| e                                                                                                                                                                             |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| [:IS_LOCATED_IN "c-10509641"->"l-1" @0 {}]                                                                                                                                    |
| [:COMMENT_HAS_CREATOR "c-10509641"->"p-41416" @0 {browserUsed: "Firefox", content: "thanks", creationDate: 2010-02-18T03:04:41.000000, length: 6, locationIP: "1.2.116.192"}] |
| [:REPLY_OF_COMMENT "c-10509641"->"c-10509627" @0 {}]                                                                                                                          |
| [:IS_LOCATED_IN "c-1051079"->"l-103" @0 {}]                                                                                                                                   |
| [:COMMENT_HAS_CREATOR "c-1051079"->"p-217287" @0 {browserUsed: "Firefox", content: "no", creationDate: 2010-02-19T20:22:43.000000, length: 2, locationIP: "27.112.114.114"}]  |
| [:REPLY_OF_POST "c-1051079"->"s-1051069" @0 {}]                                                                                                                               |
| [:IS_LOCATED_IN "c-10512839"->"l-0" @0 {}]                                                                                                                                    |
| [:COMMENT_HAS_CREATOR "c-10512839"->"p-16592" @0 {browserUsed: "Chrome", content: "thx", creationDate: 2010-02-27T05:36:54.000000, length: 3, locationIP: "49.249.123.82"}]   |
| [:REPLY_OF_COMMENT "c-10512839"->"c-10512837" @0 {}]                                                                                                                          |
| [:IS_LOCATED_IN "c-10514795"->"l-13" @0 {}]                                                                                                                                   |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Got 10 rows (time spent 5651/26492 us)

Your Environments (required)

nebula-ent,2022.12.22-nightly-ent
commit ID:8ac1a26

Expected behavior

return rank(e)==2's data

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions