age icon indicating copy to clipboard operation
age copied to clipboard

Ambiguous column reference error when returning variable used in the RHS of SET clause

Open Zainab-Saad opened this issue 9 months ago • 1 comments

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)

Zainab-Saad avatar May 17 '24 10:05 Zainab-Saad