[
https://issues.apache.org/jira/browse/FLINK-31452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17703676#comment-17703676
]
Ran Tao commented on FLINK-31452:
---------------------------------
[~jark] many mature engines such as mysql/pg support sorted databases. what do
you think?
> Show databases should better return sorted results
> --------------------------------------------------
>
> Key: FLINK-31452
> URL: https://issues.apache.org/jira/browse/FLINK-31452
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / API, Table SQL / Planner
> Reporter: Ran Tao
> Priority: Major
> Labels: pull-request-available
>
> flink show databases not support sorted function. I think we can add support
> for these operations. So when returned results are large, user can locate
> result easily. we can see mature engines such as mysql did support it.
> Flink SQL> show databases;
> +------------------+
> | database name|
> +------------------+
> |default_database|
> | test|
> | sys|
> | ca_db|
> +------------------+
> e.g. mysql
> +--------------------+
> |Database |
> +--------------------+
> |information_schema|
> |mysql |
> |performance_schema|
> |sys |
> |test |
> |test_db |
> e.g. pg:
> Name | Owner | Encoding | Collate
> ------------+----------+----------+-------------
> pgbench | postgres | UTF8 | en_US.UTF-8
> postgres | postgres | UTF8 | en_US.UTF-8
> slonmaster | postgres | UTF8 | en_US.UTF-8
> slonslave | postgres | UTF8 | en_US.UTF-8
> template0 | postgres | UTF8 | en_US.UTF-8
> template1 | postgres | UTF8 | en_US.UTF-8
> test | postgres | UTF8 | en_US.UTF-8
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
