kuzu
kuzu copied to clipboard
Join order with multiple variable names
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."