[GitHub] [age] jrgemignani commented on issue #339: Error on relationship when source vertex in EXISTS() has alias

[GitBox <gi...@apache.org>]

jrgemignani commented on issue #339:
URL: https://github.com/apache/age/issues/339#issuecomment-1290795651

   Yep, verified this is an issue with 1.1.0 -
   
   ```
   psql-11.5-5432-pgsql=# drop extension age cascade; create extension age; load 'age'; set search_path TO ag_catalog;
   ERROR:  extension "age" does not exist
   CREATE EXTENSION
   LOAD
   SET
   psql-11.5-5432-pgsql=# SELECT * FROM create_graph('test');
   NOTICE:  graph "test" has been created
    create_graph
   --------------
   
   (1 row)
   
   psql-11.5-5432-pgsql=# SELECT * FROM cypher('test', $$ CREATE (:A)-[:incs]->(:C) $$) AS (result agtype);
    result
   --------
   (0 rows)
   
   psql-11.5-5432-pgsql=# SELECT * FROM cypher('test', $$ MATCH (a:A) WITH a OPTIONAL MATCH (a)-[:incs]->(c) WHERE EXISTS((c)<-[:incs]-()) RETURN a,c $$) AS (a agtype, c agtype);
                                   a                                |                                c
   -----------------------------------------------------------------+------------------------------------------------------------------
    {"id": 844424930131969, "label": "A", "properties": {}}::vertex | {"id": 1407374883553281, "label": "C", "properties": {}}::vertex
   (1 row)
   
   psql-11.5-5432-pgsql=# SELECT * FROM cypher('test', $$ MATCH (a:A) WITH a OPTIONAL MATCH (a)-[:incs]->(c) WHERE EXISTS((c)<-[:incs]-(a)) RETURN a,c $$) AS (a agtype, c agtype);
   ERROR:  attribute 1 of type test.incs has wrong type
   DETAIL:  Table has type graphid, but query expects agtype.
   psql-11.5-5432-pgsql=#
   ```
   
   We will look into this.


-- 
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: dev-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org