[CALCITE-6022] Support "CREATE TABLE ... LIKE" DDL in server module

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.35.0
• Fix Version/s: 1.36.0
• Component/s: server
• Labels: pull-request-available
• Assignee: hongyu guo
• Reporter: hongyu guo
• Created: 22/Sep/23 09:28
• Updated: 10/Nov/23 11:34
• Resolved: 19/Oct/23 01:57

Description

"CREATE TABLE ... LIKE" is SQL standard syntax, and some other dbms(mysql, postgresql, sparksql) support it. So I think it is worth implementing.
Syntax:

CREATE TABLE [IF NOT EXISTS] table_name 
LIKE source_table [ like_option ... ]

And for the `like_option`,  I think the syntax of postgreSQL is more flexible and powerful, and I believe it is reasonable to be similar to postgreSQL. But there are not so many attributes in calcite, just keep GENERATED, DEFAULTS and ALL.

{ INCLUDING | EXCLUDING } { GENERATED | DEFAULTS | ALL }

Some related link:

https://www.postgresql.org/docs/current/sql-createtable.html

https://ronsavage.github.io/SQL/sql-2003-2.bnf.html#table%20definition 

https://dev.mysql.com/doc/refman/8.0/en/create-table-like.html 

 

Issue Links

• links to: GitHub Pull Request #3442