[
https://issues.apache.org/jira/browse/FLINK-31452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ran Tao updated FLINK-31452:
----------------------------
Parent: (was: FLINK-31256)
Issue Type: Improvement (was: Sub-task)
> 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
>
> Currently TableEnv support return sorted views and tables.
> But other operations such as show databases without sorted function. I think
> we can add support for these operations. So when returned results are large,
> user can locate result easily.
> 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)
