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

   I have the data populated below however I cannot use MATCH query with 
instance-identifier.
   
   SELECT * FROM cypher('test_graph', $$ MATCH (n) RETURN (n) $$) AS (vertex 
agtype);
                                                                                
                                   vertex
   
   
-------------------------------------------------------------------------------------------------------------------------------------------------------------
   -------------------------------------------------------------------------
    {"id": 4503599627370506, "label": "SL4SHuniverseC0L0NanotherDASHuniverse", 
"properties": {"instance-identifier": "/universe:another-universe"}}::vertex
    {"id": 5348024557502467, "label": "globularDASHcluster", "properties": 
{"instance-identifier": 
"/universe:another-universe/globular-cluster[name='cluster-42
   9']"}}::vertex
    {"id": 5629499534213124, "label": "galaxy", "properties": 
{"instance-identifier": 
"/universe:another-universe/globular-cluster[name='cluster-429']/galaxy[ga
   laxy='galaxy-429']"}}::vertex
    {"id": 5629499534213125, "label": "galaxy", "properties": 
{"instance-identifier": 
"/universe:another-universe/globular-cluster[name='cluster-429']/galaxy[ga
   laxy='galaxy-429-b']"}}::vertex
    {"id": 5910974510923779, "label": "stuffDASHinDASHgalaxy", "properties": 
{"instance-identifier": 
"/universe:another-universe/globular-cluster[name='cluster-
   429']/galaxy[galaxy='galaxy-429-b']/stuff-in-galaxy"}}::vertex
    {"id": 6192449487634435, "label": "nebula", "properties": 
{"instance-identifier": 
"/universe:another-universe/globular-cluster[name='cluster-429']/galaxy[ga
   laxy='galaxy-429-b']/stuff-in-galaxy/nebula[name='nebula429']"}}::vertex
   
   
   SELECT * FROM cypher('test_graph', $$ MATCH 
(p:SL4SHuniverseC0L0NanotherDASHuniverse {id: '/universe:another-universe'}), 
(c:globularDASHcluster {id: 
'/universe:another-universe/globular-cluster[name='cluster-429']'}) CREATE 
(p)-[:CONTAINS]->(c) $$) AS (result agtype);
   ERROR:  syntax error at or near "cluster"
   LINE 1: .../universe:another-universe/globular-cluster[name='cluster-42...
   
   If I use / to bypass the syntax error (as it allowed to populate this in DB) 
it doesn't match the data in DB, hence no results are returned.
   
    SELECT * FROM cypher('test_graph', $$ MATCH 
(p:SL4SHuniverseC0L0NanotherDASHuniverse {id: '/universe:another-universe'}), 
(c:globularDASHcluster {id: 
'/universe:another-universe/globular-cluster[name=\'cluster-429\']'}) CREATE 
(p)-[:CONTAINS]->(c) $$) AS (result agtype);
    result
   --------
   (0 rows)
   
   
   
   


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