You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Jark Wu (Jira)" <ji...@apache.org> on 2023/03/23 08:34:00 UTC
[jira] [Closed] (FLINK-31452) Show databases should better return sorted results
[ https://issues.apache.org/jira/browse/FLINK-31452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jark Wu closed FLINK-31452.
---------------------------
Fix Version/s: 1.18.0
Assignee: Ran Tao
Resolution: Fixed
Fixed in master: 027db9002407c4cfe06cab7f18b9cdc0c6932a5a
> 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
> Assignee: Ran Tao
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.18.0
>
>
> 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)