[GitHub] [age] dehowef opened a new issue, #312: CALL... YIELD clause ignores WHERE condition

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

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

   **Describe the bug**
   CALL ... YIELD clause ignores the WHERE condition. WHERE clauses used proceeding a CALL ... YIELD subquery will be ignored.
   
   **How are you accessing AGE (Command line, driver, etc.)?**
   - [e.g. JDBC]
   psql commandline
   
   **What is the command that caused the error?**
   ```pgsql
   SELECT * FROM cypher('test', $$ CALL sqrt(1) YIELD sqrt WHERE sqrt = 2 RETURN sqrt$$) as (a agtype);
   ```
   Result:
   ```
     a  
   -----
    1.0
   (1 row)
   ```
   
   **Expected behavior**
   Return value should be null; sqrt(1) != WHERE condition of 2.
   
   **Environment (please complete the following information):**
   - Version: latest version of master branch
   


-- 
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.apache.org

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

[GitHub] [age] jrgemignani commented on issue #312: CALL... YIELD clause ignores WHERE condition

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

jrgemignani commented on issue #312:
URL: https://github.com/apache/age/issues/312#issuecomment-1261527265

   This is the offending line -
   
   2184         if (is_ag_node(clause, cypher_call))
   
   I changed it to -
   
   2184         if (is_ag_node(clause->self, cypher_call))
   
   It looks like just a typo that got overlooked.


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