[
https://issues.apache.org/jira/browse/FLINK-31452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated FLINK-31452:
-----------------------------------
Labels: pull-request-available (was: )
> 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 |
> +--------------------+
> 6 rows in set (0.01 sec)
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
