Match Search, The order of results is inconsistent with the order of Return

[jianan0982]

Describe the bug (required)
Nebula-Graph Version: 2.5

Rebuild

• Command
  MATCH p=(v:owl_Class{name:"畜肉类"})<-[e1]-(v2:owl_NamedIndividual)-[e2:relation{name:"有标签"}]->(

  v3:owl_NamedIndividual{name:"高蛋白"}) RETURN v,e1,v2,e2,v3,p limit 20

• Correct Result

• Command
  MATCH p=(v:owl_Class{name:"畜肉类"})<-[e1]-(v2:owl_NamedIndividual)-[e2:relation{name:"有标签"}]->(

  v3:owl_NamedIndividual{name:"高蛋白"}) RETURN e2,v3,p,v,e1,v2 limit 20

• ERROR Result
  

[Sophie-Xie]

We cannot reproduce on nebula 2.5. Can you provide more version info about studio and nebula?

[jianan0982]

复现时查询语句需要加上LIMIT

Nebula version: 2.5

Nebula Graph Studio:3.0

[jianan0982]

必须加上LIMIT才能复现当前Bug
MATCH p=(v:owl_Class{name:"畜肉类"})<-[e1]-(v2:owl_NamedIndividual)-[e2:relation{name:"有标签"}]->(v3:owl_NamedIndividual{name:"高蛋白"}) RETURN e2,v3,p,v,e1,v2 LIMIT 20
和
MATCH p=(v:owl_Class{name:"畜肉类"})<-[e1]-(v2:owl_NamedIndividual)-[e2:relation{name:"有标签"}]->(v3:owl_NamedIndividual{name:"高蛋白"}) RETURN ,v,e1,v2,e2,v3,p LIMIT 20

[Sophie-Xie]

MATCH p=(v:owl_Class{name:"畜肉类"})<-[e1]-(v2:owl_NamedIndividual)-[e2:relation{name:"有标签"}]->(v3:owl_NamedIndividual{name:"高蛋白"}) RETURN e2,v3,p,v,e1,v2 LIMIT 20

Thanks. Is is OK if executing nGQL directly on nebula console without Studio?

[jianan0982]

在nebula-console运行也是一样的问题

[jievince]

Hi @jianan0982 , it might be a bug caused by a bad optimization rule. nebula-graph v2.6.0 has fixed this bug. You could try to upgrade to v2.6.0.
BTW, the version of nebula you are using is nebula-graph-2021.10.09-nightly which is not v2.5.0.