[ 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 be called 'indexes'. 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] # schema_id (INT) # schema_name (VARCHAR) # 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_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') # 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. > 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 be called 'indexes'. > 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] > # schema_id (INT) > # schema_name (VARCHAR) > # 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)