ToLboo commented on issue #365:
URL: https://github.com/apache/age/issues/365#issuecomment-2558414146
@jrgemignani Hello, I am experiencing a similar issue. 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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
