[FLINK-14687] Add database related ddl support to SQL Parser

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.10.0
• Component/s: Table SQL / API, Table SQL / Client
• Labels: pull-request-available
• Assignee: Terry Wang
• Reporter: Terry Wang
• Created: 10/Nov/19 05:47
• Updated: 14/Nov/19 21:31
• Resolved: 14/Nov/19 21:31

Description

According to FLIP-69, we should introduce such following DDLs related to the database in the sql parser.

1. createDatabaseStatement:
CREATE DATABASE [ IF NOT EXISTS ] [ catalogName.] dataBaseName
[ COMMENT database_comment ]
[WITH ( name=value [, name=value]*)]

2. dropDatabaseStatement:
DROP DATABASE [ IF EXISTS ] [ catalogName.] dataBaseName
[ (RESTRICT|CASCADE)]

3. alterDatabaseStatement:
ALTER DATABASE [ catalogName.] dataBaseName SET
( name=value [, name=value]*)

4. useDatabaseStatement:
USE [ catalogName.] dataBaseName

5. showDatabasesStatement:
SHOW DATABASES

6. descDatabaseStatement:
DESCRIBE DATABASE [ EXTENDED] [ catalogName.] dataBasesName

Issue Links

• links to: GitHub Pull Request #10201