[
https://issues.apache.org/jira/browse/IGNITE-21120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17823656#comment-17823656
]
Roman Puchkovskiy commented on IGNITE-21120:
--------------------------------------------
The patch looks good to me
> Add a system view to list available indexes
> -------------------------------------------
>
> Key: IGNITE-21120
> URL: https://issues.apache.org/jira/browse/IGNITE-21120
> Project: Ignite
> Issue Type: Improvement
> Reporter: Roman Puchkovskiy
> Assignee: Philipp Shergalis
> Priority: Major
> Labels: ignite-3
> Fix For: 3.0.0-beta2
>
> Time Spent: 1h
> Remaining Estimate: 0h
>
> The view should be called 'indexes'. It will only display the indexes which
> are currently alive (that is, REGISTERED, BUILDING or AVAILABLE).
> The view should contain the following columns:
> # index_id (INT)
> # index_name (VARCHAR)
> # table_id (INT)
> # table_name (VARCHAR) [at the moment of the query to the view is executed]
> # schema_id (INT)
> # schema_name (VARCHAR)
> # type (VARCHAR, allowed values are 'hash' or 'sorted')
> # is_unique (BOOLEAN)
> # columns (VARCHAR) (for a hash index, just a list of column names separated
> with commas [like 'first_name, last_name']; for a sorted index, a list of
> column names with their collations, like 'first_name ASC, last_name DESC')
> # status (VARCHAR)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
