search

bitnine-oss / agensgraph

AgensGraph, a transactional graph database based on PostgreSQL
http://www.agensgraph.org
Other
1.32k stars 146 forks source link

fix: Columns not visible when using a VLE. (#609) #610

Open emotionbug opened 1 year ago

yjy44 commented 1 year ago

Please explain briefly about the continuation of the pathout and the VLE.

emotionbug commented 1 year ago

There are two issues found in the issue in #609.

First thing, because the target of a Joinlist is not visible, some statement can't perform the logic of how to join with it. https://github.com/bitnine-oss/agensgraph/blob/91ff58c56ec8f57aafe39210460cc33ae0c3349d/src/backend/parser/parse_graph.c#L1918

this resolves the errors, but ruins the results of the join with the unnamed VLE.

Second thing, problem is that in statements like the one in this problem, AgensGraph is forced to treat joins as paths. however, except for types like ShortestPath, if the name of the path does not exist, it is not treated as a path. this leads to a deviation from the expected behavior and results in an invalid join.