shady-cj opened a new issue, #950:
URL: https://github.com/apache/age/issues/950

   
   Using the exists(expression) one can check for a property or path… according 
to the example given in the documentation 
[here](https://age.apache.org/age-manual/master/functions/predicate_functions.html)
 the following examples raised errors.
   
   
   ```
   SELECT * FROM cypher('graph_name', $$
    MATCH (n)
    WHERE exists(n)-[]-(name: 'Willem Defoe')
    RETURN n.full_name
   $$) as (full_name agtype);
   ```
   
   **The following error was raised**
   
   ```
   
   ERROR:  syntax error at or near ")"
   LINE 3:  WHERE exists(n)-[]-(name: 'Willem Defoe')
                          ^
   
   ```
   
   **Expected behavior**
   The expected behavior is to return either `null` or `surname` of agtype that 
matches the `WHERE` clause 
   
   
   **The expected query**
   
   The expected query that worked is the following 
   
   
   ```
   
   SELECT * FROM cypher('graph_name', $$
    MATCH (n)
    WHERE exists((n)-[]-({name: 'Willem Defoe'})) 
    RETURN n.full_name 
   $$) as (full_name 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.apache.org

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

Reply via email to