avowkind commented on issue #365:
URL: https://github.com/apache/age/issues/365#issuecomment-2046277521
Further to the 2nd try element
in the following code the delete_global_graphs ensures that the PropertyType
query fails. but the following Feature query succeeds although it is on a
different entity and edge type.
```psql
LOAD 'age';
SET search_path = ag_catalog, "$user", public;
-- delete all graph contexts
-- should return true
SELECT * FROM cypher('fishpond', $$ RETURN delete_global_graphs(NULL) $$) AS
(result agtype);
SELECT * FROM cypher('fishpond', $$
MATCH (p:PropertyType)<-[edge:typeOf*0..]-(node:PropertyType)
WHERE p.id = 'fish_weight_g'
RETURN node, edge
$$) as ( node agtype, edge agtype);
SELECT * FROM cypher('fishpond', $$
MATCH (p:Feature)<-[edge:partOf*0..]-(node:Feature)
WHERE p.id = 'pfr:nelson:tank:A01'
RETURN node, edge
$$) as ( node agtype, edge agtype);
```
--
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]