[
https://issues.apache.org/jira/browse/IGNITE-24304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov reassigned IGNITE-24304:
-----------------------------------------
Assignee: Maksim Zhuravkov
> 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
> Assignee: 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)
