Describe the bug
I simplified the Cypher query to do the following:
MATCH nodes with Object labelMATCH nodes that are connected with the nodes resulting from the previous query by any edgeRETURN the nodes
How are you accessing AGE (Command line, driver, etc.)?
- Command line inside
psql client
What data setup do we need to do?
Minimal data setup:
postgresDB=# SELECT * FROM ag_catalog.create_graph('testgraph');
postgresDB=# SELECT * FROM cypher('testgraph', $$ CREATE (n1:Object) RETURN n1$$)
postgresDB=# SELECT * FROM cypher('testgraph', $$ MATCH (n1:Object)
MATCH (n2:Object)
WHERE EXISTS((n1)-[]->(n2))
RETURN n2 $$)
AS (n2 agtype);
ERROR: missing FROM-clause entry for table "n1"
LINE 1: SELECT * FROM cypher('testgraph', $$ MATCH (n1:Object)
What is the necessary configuration info needed?
What is the command that caused the error?
postgresDB=# SELECT * FROM cypher('testgraph', $$ MATCH (n1:Object)
MATCH (n2:Object)
WHERE EXISTS((n1)-[]->(n2))
RETURN n2 $$)
AS (n2 agtype);
ERROR: missing FROM-clause entry for table "n1"
LINE 1: SELECT * FROM cypher('testgraph', $$ MATCH (n1:Object)
Expected behavior
The query should succeed and return 0 rows.
Environment (please complete the following information):
- Installed from docker image obtained from command command
docker pull apache/age
- Run using docker command
docker run \ --name myPostgresDb \ -p 5455:5432 \ -e POSTGRES_USER=postgresUser \ -e POSTGRES_PASSWORD=postgresPW \ -e POSTGRES_DB=postgresDB \ -d \ apache/age
- PostgreSQL version 15.4
Additional context
Describe the bug
I simplified the Cypher query to do the following:
MATCHnodes withObjectlabelMATCHnodes that are connected with the nodes resulting from the previous query by any edgeRETURNthe nodesHow are you accessing AGE (Command line, driver, etc.)?
psqlclientWhat data setup do we need to do?
Minimal data setup:
postgresDB=# SELECT * FROM ag_catalog.create_graph('testgraph');
postgresDB=# SELECT * FROM cypher('testgraph', $$ CREATE (n1:Object) RETURN n1$$)
postgresDB=# SELECT * FROM cypher('testgraph', $$ MATCH (n1:Object)
MATCH (n2:Object)
WHERE EXISTS((n1)-[]->(n2))
RETURN n2 $$)
AS (n2 agtype);
ERROR: missing FROM-clause entry for table "n1"
LINE 1: SELECT * FROM cypher('testgraph', $$ MATCH (n1:Object)
What is the necessary configuration info needed?
What is the command that caused the error?
postgresDB=# SELECT * FROM cypher('testgraph', $$ MATCH (n1:Object)
MATCH (n2:Object)
WHERE EXISTS((n1)-[]->(n2))
RETURN n2 $$)
AS (n2 agtype);
ERROR: missing FROM-clause entry for table "n1"
LINE 1: SELECT * FROM cypher('testgraph', $$ MATCH (n1:Object)
Expected behavior
The query should succeed and return 0 rows.
Environment (please complete the following information):
docker pull apache/agedocker run \ --name myPostgresDb \ -p 5455:5432 \ -e POSTGRES_USER=postgresUser \ -e POSTGRES_PASSWORD=postgresPW \ -e POSTGRES_DB=postgresDB \ -d \ apache/ageAdditional context