Bug: MATCH path with recursive relation returns nodes/rels in wrong order

[sapalli2989]

Kùzu version

0.4.2

What operating system are you using?

Fedora 39

What happened?

MATCHing all paths from any user to :City {name: "Guelph"} via

MATCH p = (u:User)-[e*]->(c:City {name: "Guelph"}) 
RETURN properties(nodes(p),'name'), properties(rels(p),'_label');

returns

["Noura","Guelph"]	["LivesIn"]
["Zhang","Noura","Guelph"]	["LivesIn","Follows"]
["Adam","Noura","Zhang","Guelph"]	["LivesIn","Follows","Follows"]
["Karissa","Noura","Zhang","Guelph"]	["LivesIn","Follows","Follows"]
["Adam","Noura","Zhang","Karissa","Guelph"]	["LivesIn","Follows","Follows","Follows"]

, which doesn't reflect nodes and rel order in graph:

(demo dataset)

Are there known steps to reproduce?

No response

[prrao87]

Hi @sapalli2989, I think this is related to #3751 and #3169. I believe the fix was issued on the latest dev build as per #3765. Could you try it there and let us know?

[sapalli2989]

@prrao87 Just tried out with latest nightly cli from https://github.com/kuzudb/kuzu/actions/runs/9853279670 . Result is unchanged 🤔:

kuzu> MATCH p = (u:User)-[e*]->(c:City {name: "Guelph"})
..> RETURN properties(nodes(p),'name'), properties(rels(p),'_label');
-------------------------------------------------------------------------
| PROPERTIES(NODES(p),name)         | PROPERTIES(RELS(p),_label)        |
-------------------------------------------------------------------------
| [Noura,Guelph]                    | [LivesIn]                         |
-------------------------------------------------------------------------
| [Zhang,Noura,Guelph]              | [LivesIn,Follows]                 |
-------------------------------------------------------------------------
| [Adam,Noura,Zhang,Guelph]         | [LivesIn,Follows,Follows]         |
-------------------------------------------------------------------------
| [Karissa,Noura,Zhang,Guelph]      | [LivesIn,Follows,Follows]         |
-------------------------------------------------------------------------
| [Adam,Noura,Zhang,Karissa,Guelph] | [LivesIn,Follows,Follows,Follows] |
-------------------------------------------------------------------------

[prrao87]

Ok, this is something worth keeping open then.