[FLINK-14691] Support database related DDLs (don't need return values) through sqlUpdate() method in TableEnvironment

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.10.0
• Component/s: Table SQL / API
• Labels: pull-request-available
• Assignee: Terry Wang
• Reporter: Terry Wang
• Created: 10/Nov/19 06:06
• Updated: 1 week ago 01:31
• Resolved: 1 week ago 01:31

Description

According to FLIP-69, we should support such following DDLs related to the database in the TableEnvironment through `sqlUpdate()` method.

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

Issue Links

• links to: GitHub Pull Request #10296