Ambiguous column reference error when returning variable used in the RHS of SET clause #1884
Description
Describe the bug
'column reference is ambiguous' error is thrown unexpectedly when trying to return the variable used in right hand side of SET clause
How are you accessing AGE (Command line, driver, etc.)?
- terminal
What data setup do we need to do?
Can be observed without creating any data
What is the command that caused the error?
SELECT * from cypher('graph', $$
MATCH(n) SET n.node=n RETURN n
$$) as (a agtype);ERROR: column reference "n" is ambiguous
Expected behavior
Should update the property and return the result without error
Environment (please complete the following information):
- latest (on PG16)