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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
