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

   **Describe the bug**
   Running the regression tests line by line I get an error
    ```sh
   postgres=# SELECT * FROM cypher('cypher_call', $$CALL sqrt(64)$$) as (sqrt 
agtype);
   2023-03-08 19:38:02.077 EET [6722] ERROR:  CALL not supported yet at 
character 39
   2023-03-08 19:38:02.077 EET [6722] STATEMENT:  SELECT * FROM 
cypher('cypher_call', $$CALL sqrt(64)$$) as (sqrt agtype);
   ERROR:  CALL not supported yet
   ```
   
   **How are you accessing AGE (Command line, driver, etc.)?**
   - Command line
   
   **What data setup do we need to do?**
   ```pgsql
   LOAD 'age';
   SET search_path TO ag_catalog;
   
   
   
   SELECT create_graph('cypher_call');
   
   SELECT * FROM cypher('cypher_call', $$CREATE ({n: 'a'})$$) as (a agtype);
   SELECT * FROM cypher('cypher_call', $$CREATE ({n: 'b'})$$) as (a agtype);
   
   CREATE SCHEMA call_stmt_test;
   
   CREATE FUNCTION call_stmt_test.add_agtype(agtype, agtype) RETURNS agtype
       AS 'select $1 + $2;'
       LANGUAGE SQL
       IMMUTABLE
       RETURNS NULL ON NULL INPUT;
   
   /* 
    * CALL (solo) 
    */
   
   SELECT * FROM cypher('cypher_call', $$CALL sqrt(64)$$) as (sqrt agtype);
   ```
   
   
   **What is the command that caused the error?**
   ```pgsql
   postgres=# SELECT * FROM cypher('cypher_call', $$CALL sqrt(64)$$) as (sqrt 
agtype);
   ```
   ```
   ERROR:  CALL not supported yet
   ```
   
   **Expected behavior**
   According to the output of the regression tests, it should have returned :
   ```SELECT * FROM cypher('cypher_call', $$CALL sqrt(64) YIELD sqrt$$) as 
(sqrt agtype);
    sqrt 
   ------
    8.0
   (1 row)
   ```
   
   **Environment (please complete the following information):**
   - PostgreSQL Version = 12_14
   - apacheAGE version release/PG12/1.1.1
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to