[ 
https://issues.apache.org/jira/browse/IGNITE-24304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Iurii Gerzhedovich updated IGNITE-24304:
----------------------------------------
    Description: 
Index system view stores index columns as a string, which makes in difficult to 
work with and requires manual parsing (e.g. IgniteCatalog provides index 
information - https://issues.apache.org/jira/browse/IGNITE-24294 ), it would be 
better to introduce a separate system view for index columns (or extend table 
columns view to include index columns).

System view name:
 * index_columns

System view columns:
 * schema_id
 * schema_name
 * table_id
 * table_name
 * index_id
 * index_name
 * column_name
 * column_ordinal - a position in an index definition
 * collation (desc, asc, null first, null last, etc, see IgniteCatalog 
SortOrder) (must be null for hash indices)

  was:
Index system view stores index columns as a string, which makes in difficult to 
work with and requires manual parsing (e.g. IgniteCatalog provides index 
information - https://issues.apache.org/jira/browse/IGNITE-24294 ), it would be 
better to introduce a separate system view for index columns (or extend table 
columns view to include index columns).

System view name: 
* index_columns

System view columns:
* schema_id
* schema_name
* table_id
* table_name
* index_id
* index_name
* column_ordinal - a position in an index definition
* collation (desc, asc, null first, null last, etc, see IgniteCatalog 
SortOrder) (must be null for hash indices)
 


> Sql. System views. Introduce a system view for index columns
> ------------------------------------------------------------
>
>                 Key: IGNITE-24304
>                 URL: https://issues.apache.org/jira/browse/IGNITE-24304
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>            Reporter: Maksim Zhuravkov
>            Priority: Major
>              Labels: ignite-3
>
> Index system view stores index columns as a string, which makes in difficult 
> to work with and requires manual parsing (e.g. IgniteCatalog provides index 
> information - https://issues.apache.org/jira/browse/IGNITE-24294 ), it would 
> be better to introduce a separate system view for index columns (or extend 
> table columns view to include index columns).
> System view name:
>  * index_columns
> System view columns:
>  * schema_id
>  * schema_name
>  * table_id
>  * table_name
>  * index_id
>  * index_name
>  * column_name
>  * column_ordinal - a position in an index definition
>  * collation (desc, asc, null first, null last, etc, see IgniteCatalog 
> SortOrder) (must be null for hash indices)



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to