Allow for `CREATE TABLE AS SELECT` statements
Open
- Dominant language
- Go
- Stars
- 2.1k
- Forks
- 73
- Avg merge
- 1d 10h
- Merged PRs (30d)
- 129
Description
Currently, the query `create table t2 as select * from t` generates an error message `ERROR: TableCopier only accepts CreateTable or TableNode as the destination`, despite it being a valid a query in Postgres (at least according to [ChatGPT](https://chatgpt.com/share/687e7f91-4440-8001-bb82-4e8c2ea15fd2))
Discovered in dolthub/go-mysql-server#3110. Test currently tagged with `Dialect: "mysql"`. Remove dialect tag once fixed
Contributor guide
Assessment
This issue has not been assessed yet.