[
https://issues.apache.org/jira/browse/IGNITE-24304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov 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_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
* sort_order (desc, asc, null first, null last, etc, see IgniteCatalog
SortOrder) (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_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)
