ToLboo opened a new issue, #2143:
URL: https://github.com/apache/age/issues/2143

   I am experiencing a similar issue with 
[.](https://github.com/apache/age/issues/365) Whenever I run the following 
query:
   ```
   SELECT * FROM cypher('multi_in_1_graph', $$ MATCH (cs:CLOSED_SHELL {id: 
32722, file_name: "Jaguar_E_Type_roadster"})-[*1..3]->(el:EDGE_LOOP) RETURN 
el.id AS id, el $$) AS (id integer, el agtype);
   ```
   
   It always throws the following error on the first execution:
   
   ```ERROR: could not open relation with OID 0
   SQL state: XX000
   ```
   
   Subsequent executions do not throw this error but always return empty 
results. However, when I run this query:
   ```
   SELECT * FROM cypher('multi_in_1_graph', $$ MATCH (cs:CLOSED_SHELL {id: 
32722, file_name: "Jaguar_E_Type_roadster"})-[]->()-[]->()-[]->(el:EDGE_LOOP) 
RETURN el.id AS id, el $$) AS (id integer, el agtype);
   ```
   It successfully retrieves valid results.
   
   Could you please help me understand why this is happening and how to resolve 
the issue?


-- 
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-unsubscr...@age.apache.org.apache.org

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

Reply via email to