Invalid reuse of previous clause variable in succeeding CREATE clause

[Zainab-Saad]

Describe the bug
The succeeding CREATE clause is letting the reuse of variable of the previous CREATE.

How are you accessing AGE (Command line, driver, etc.)?
psql

What is the command that caused the error?

SELECT * FROM cypher('graph', $$ CREATE(n) CREATE(n)  RETURN n $$) AS (result agtype);

creates one vertex

                             result                             
----------------------------------------------------------------
 {"id": 281474976710657, "label": "", "properties": {}}::vertex
(1 row)

Environment (please complete the following information):
AGE master - PG16

Expected behavior
The second CREATE clause should give a duplicate variable error. Neo4j errors out as:

Variable `n` already declared (line 1, column 18 (offset: 17))
"CREATE(n) CREATE(n)  RETURN n"
                  ^

[jrgemignani]

@Zainab-Saad Good catch!

[jrgemignani]

@Zainab-Saad If you are planning on creating a PR to fix this, please note it here :)

[rafsun42]

This can be a project. The other executors may have similar issues. #1446 is a related one.