dehowef opened a new issue, #701:
URL: https://github.com/apache/age/issues/701
**Describe the bug**
There is unintended behavior when a user tries to MATCH a node with property
constraints after already MATCHing a node with the same variable name.
**How are you accessing AGE (Command line, driver, etc.)?**
Command Line
**What data setup do we need to do?**
Have AGE running.
**What is the necessary configuration info needed?**
- N/A
**What is the command that caused the error?**
```pgsql
SELECT * FROM cypher('my_graph', $$ MATCH (a) MATCH (a {prop:'val'}) RETURN
a $$ ) AS (a agtype);
```
```
postgres=# SELECT * FROM cypher('my_graph', $$ MATCH (a) MATCH (a
{prop:'val'}) RETURN a $$ ) AS (a agtype);
2023-02-22 01:29:05.230 PST [59866] ERROR: missing FROM-clause entry for
table "a" at character 34
2023-02-22 01:29:05.230 PST [59866] STATEMENT: SELECT * FROM
cypher('pilots', $$ MATCH (a) MATCH (a {s:'as'}) RETURN a $$ ) AS (a agtype);
ERROR: missing FROM-clause entry for table "a"
LINE 1: SELECT * FROM cypher('my_graph', $$ MATCH (a) MATCH (a {prop:'val'...
```
**Expected behavior**
The program should detect the variable and return the according result. The
RTE is not being detected and the program is throwing an error.
**Environment (please complete the following information):**
- Version: PG11 Version 1.1.X, Fedora OS 36
**Additional context**
Add any other context about the problem here.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
