[IGNITE-11402] SQL: Add ability to specify inline size of PK and affinity key indexes from CREATE TABLE

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.13
• Component/s: sql
• Labels: newbie
• Release Note: SQL: Added ability to specify inline size of PK and affinity key indexes from CREATE TABLE
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Taras Ledkov
• Reporter: Vladimir Ozerov
• Reviewer: Iurii Gerzhedovich
• Created: 25/Feb/19 08:30
• Updated: 29/Mar/22 11:35
• Resolved: 16/Feb/22 08:40

Description

Currently it is not possible to set inline size for automatically created indexes easily. We need to make sure that user has a convenient way to set them both programmatically and from DDL.
Start point for automatically created indexes is org.apache.ignite.internal.processors.query.h2.H2TableDescriptor#createSystemIndexes where passed parameter inlineSize as -1 for org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing#createSortedIndex

Issue Links

• is duplicated by: IGNITE-12431 Allow to set inline size for implicit indexes per table
• is related to: IGNITE-16098 Key type and schema must be validated on a data insertion
• relates to: IGNITE-13364 Improve index inline defaults
• links to: GitHub Pull Request #9604
• links to: TCBot