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-unsubscr...@age.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
