[
https://issues.apache.org/jira/browse/IGNITE-21120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Puchkovskiy updated IGNITE-21120:
---------------------------------------
Description:
The view should contain the following:
# index_id (INT)
# index_name (VARCHAR)
# table_id (INT)
# table_name (VARCHAR) [at the moment of the query to the view is executed]
# type (VARCHAR, allowed values are 'hash' or 'sorted')
# 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')
This has to be refined.
was:
The view should contain the following:
# Index name (VARCHAR)
# Index ID (INT)
# Owning table name/ID
# Index type (hash/sorted)
# Columns (for a hash index, just a list of column names; for a sorted index,
a list of column names with their collations)
This has to be refined.
> 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
>
>
> The view should contain the following:
> # index_id (INT)
> # index_name (VARCHAR)
> # table_id (INT)
> # table_name (VARCHAR) [at the moment of the query to the view is executed]
> # type (VARCHAR, allowed values are 'hash' or 'sorted')
> # 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')
> This has to be refined.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
