Filter NOT EXISTS leads to an error if a relation label does not exists as database table

[nupis-DanielS]

Describe the bug
We run in an error if we query for a non existing relationship. If the filter contains the label of the relationship it will return "Variable foo does not exist". When the relationship label is not used everything works as expected. It looks like that the error occurs only when the database table for the label is not present..

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

• JDBC
• pg (Node)

What data setup do we need to do?

/

What is the necessary configuration info needed?

• /

What is the command that caused the error?

SELECT * FROM cypher('property-graph', $$ 
  MATCH (foo)
  WHERE NOT exists((foo)-[:BAR]->())
  RETURN count(foo) > 0
$$) as (c agtype)

Variable `foo` does not exist

Expected behavior
false

Environment (please complete the following information):

• Version: 1.4.0
• PostgreSQL: 14.6 (Ubuntu 14.6-1.pgdg22.04+1)

Additional context
Without non existing relation label it works as expected (result -> false).

[jimenasansav]

Hi @nupis-DanielS! Thank you for letting us know about this issue. Our technical team will go through it and provide a solution soon. In the meantime, please feel free to reach out if you have any other questions.

[jrgemignani]

@nupis-DanielS I will look into this. Related to #1393

psql-15.4-5432-pgsql=# SELECT * FROM cypher('property-graph', $$ MATCH (foo) WHERE NOT exists((foo)-[:BAR]->()) RETURN count(foo) > 0 $$) as (c agtype)
;
ERROR:  variable `foo` does not exist
LINE 1: ...property-graph', $$ MATCH (foo) WHERE NOT exists((foo)-[:BAR...
                                                             ^
psql-15.4-5432-pgsql=# SELECT * FROM cypher('property-graph', $$ create ()-[:BAR]->() $$) as (c agtype)                             ;
 c
---
(0 rows)

psql-15.4-5432-pgsql=# SELECT * FROM cypher('property-graph', $$ MATCH (foo) WHERE NOT exists((foo)-[:BAR]->()) RETURN count(foo) > 0 $$) as (c agtype)
;
  c
------
 true
(1 row)

psql-15.4-5432-pgsql=#

[jrgemignani]

@nupis-DanielS PR #1400 should resolve this once reviewed and merged.

[jrgemignani]

@nupis-DanielS The fix is now in the master branch. If you could verify that it satisfactorily resolves your issue and close it, that would be great.