[IGNITE-11368] use the same information about indexes for JDBC drivers as for system view INDEXES

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.15
• Component/s: jdbc, odbc, sql
• Labels: ise newbie
• Assignee: Ilya Shishkov
• Reporter: Iurii Gerzhedovich
• Created: 20/Feb/19 12:15
• Updated: 03/Nov/22 15:48
• Resolved: 03/Nov/22 07:27

Description

As of now indexes information for JDBC drivers get by another way then system SQL view INDEXES. Need to use single source of the information to have consistent picture.

So, JDBC drivers should use the same source as SQL view INDEXES (org.apache.ignite.internal.processors.query.h2.sys.view.SqlSystemViewIndexes)
Start point for JDBC index metadata is org.apache.ignite.internal.jdbc2.JdbcDatabaseMetadata#getIndexInfo

Also order of result should be correspond Javadoc ('ordered by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION') - at present it is not so.

Issue Links

• is blocked by: IGNITE-17285 Ambiguous output of INDEXES SytemView if cache is created via DDL
• is duplicated by: IGNITE-9490 Connection.getMetaData.getIndexInfo method doesn't return PK indexes
• relates to: IGNITE-15424 Calcite engine. Move schema management infrastructure to the core module
• links to: GitHub Pull Request #10316