[GitHub] [age] humzakt commented on issue #993: Graph traversal optimization by excluding graph path (stop conditions)

["humzakt (via GitHub)" <gi...@apache.org>]

humzakt commented on issue #993:
URL: https://github.com/apache/age/issues/993#issuecomment-1593378125

   The error message "missing FROM-clause entry for table "from"" is indicating that there's a problem with the alias from in your query. The word from is a reserved keyword in SQL and it's also used in the MATCH clause of the Cypher language. This might be confusing the query parser.
   
   Try changing the alias from to something else that's not a reserved keyword, for example, start_node:
   
   
   ```
   select
       properties
   from ag_catalog.cypher('test_graph', $$
       MATCH (start_node:`account` { id: 'cd94fd96-adeb-40a6-bc17-a2f9b51f6296'} )-[any_edge:`edges`*1..100]->(to)
       WITH start_node, to, last(any_edge) AS edge_out
       WHERE exists( (start_node)-[ { relation: "managed" } ]-(to) )
       AND NOT edge_out.relation IN ['managed']
   
       RETURN properties(to)
   $$
            ) as (properties ag_catalog.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: dev-unsubscribe@age.apache.org

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