[GitHub] [incubator-age] JoshInnis commented on issue #217: a bug when working with "begin ... commit"

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

JoshInnis commented on issue #217:
URL: https://github.com/apache/incubator-age/issues/217#issuecomment-1130368665

   It looks like the VLE global contexts are not using the correct graph
   ```
   BEGIN;
   
   SET search_path = ag_catalog, "$user", public;
   
   SELECT create_graph('mygraph');
   
   SELECT * FROM cypher('mygraph', $$
       CREATE (a:Node {name: 'a'})-[:Edge]->(c:Node {name: 'c'})
   $$) AS (g1 agtype);
   
   --Removed VLE call
   
   SELECT * FROM cypher('mygraph', $$
       MATCH (a:Node {name: 'a'})-[e:Edge]->(c:Node {name: 'c'})
       DELETE e
       CREATE (a)-[:Edge]->(:Node {name: 'b'})-[:Edge]->(c)
   $$) AS (g3 agtype);
   
   SELECT * FROM cypher('mygraph', $$
       MATCH p = ()-[:Edge]->()
       RETURN p
   $$) AS (g4 agtype);
   
   SELECT * FROM cypher('mygraph', $$
       MATCH p = ()-[:Edge*]->()
       RETURN p
   $$) AS (g5 agtype);
   
   SELECT drop_graph('mygraph', true);
   
   COMMIT;
   ```
   
   We will take a look into it, for now the workaround I recommend is only use variable length edges once in a transaction


-- 
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