[jira] [Comment Edited] (FLINK-13206) modify 'use database' syntax in SQL CLI to be consistant with standard sql

["Xuefu Zhang (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FLINK-13206?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16883277#comment-16883277 ] 

Xuefu Zhang edited comment on FLINK-13206 at 7/11/19 7:29 PM:
--------------------------------------------------------------

Actually no. {{Catalog}} is the parent and so an aggregation of databases (as evident from {{Catalog.listDatabases()}}). A database is equivalent of SQL schema, which is a container of actual meta objects such as tables, views, and functions.

DDL "use database" is to switch current database in the a catalog.

[~Terry1897] It would be good to add some description to the JIRA to reflect the problem and the proposal addressing the problem.


was (Author: xuefuz):
Actually no. {{Catalog}} is the parent and so an aggregation of databases (as evident from {{Catalog.listDatabases()}}). A database is equivalent of SQL schema, which is a container of actually meta objects such as tables, views, and functions.

DDL "use database" is to switch current database in the a catalog.

[~Terry1897] It would be good to add some description to the JIRA to reflect the problem and the proposal addressing the problem.

> modify 'use database' syntax in SQL CLI to be consistant with standard sql
> --------------------------------------------------------------------------
>
>                 Key: FLINK-13206
>                 URL: https://issues.apache.org/jira/browse/FLINK-13206
>             Project: Flink
>          Issue Type: Sub-task
>            Reporter: zjuwangg
>            Assignee: zjuwangg
>            Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.14#76016)