kuzu icon indicating copy to clipboard operation
kuzu copied to clipboard

Join order with multiple variable names

Open semihsalihoglu-uw opened this issue 6 months ago • 0 comments

Can we give a better error for this case. I'm using b twice in the join order:

kuzu> explain match (a:Person)-[e1]->(b:Person)-[e2]->(c:Person) HINT (a JOIN (e1 JOIN b)) JOIN ((b JOIN e2) JOIN c) return *;
Error: Binder exception: Cannot resolve join condition.

The ideal error message should be: "The variable b is used twice in the join HINT. In HINT, each node and relationship pattern must appear exactly once."

semihsalihoglu-uw avatar Aug 04 '24 07:08 semihsalihoglu-uw