[I] create table as select * from cypher()... throw an error [age]

[via GitHub]

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

   **Describe the bug**
   When execute 'create table as select * from cypher(...)'  using pgsql, the 
sql will return an error, 
   if I create table xxx first, and then insert into xxx select ...  the result 
 is ok
   
   **What is the command that caused the error?**
   ```pgsql
   
   postgresDB=# create table tt as SELECT * FROM cypher('agload_test_graph', 
$$MATCH (a)-[e]->(b) RETURN e$$) as (n agtype) limit 1;
   ERROR:  unhandled cypher(cstring) function call
   DETAIL:  agload_test_graph
   postgresDB=# create table tt(n agtype);
   CREATE TABLE
   postgresDB=# insert into tt SELECT * FROM cypher('agload_test_graph', 
$$MATCH (a)-[e]->(b) RETURN e$$) as (n agtype) limit 1;
   INSERT 0 1
   
   ```
   
   **Expected behavior**
   It should ok for create table as select ...
   I think  maybe need a litter change for hook of parser for DDL
   
   **Environment (please complete the following information):**
   - Use  apache/age docker to test
   
   
   


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