[FLINK-31452] Show databases should better return sorted results

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.18.0
• Component/s: Table SQL / API, Table SQL / Planner
• Labels: pull-request-available
• Assignee: Ran Tao
• Reporter: Ran Tao
• Created: 14/Mar/23 12:28
• Updated: 23/Mar/23 08:33
• Resolved: 23/Mar/23 08:33

Description

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 

 

Issue Links

• links to: GitHub Pull Request #22242