[IGNITE-13364] Improve index inline defaults

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.12
• Component/s: sql
• Release Note: Calculation of the default index length was changed for varchar and binary columns. IGNITE_MAX_INDEX_PAYLOAD_SIZE was increased to 64.
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Maksim Timonin
• Reporter: Evgeniy Rudenko
• Reviewer: Stanislav Lukyanov
• Created: 17/Aug/20 06:14
• Updated: 24/Nov/21 14:49
• Resolved: 23/Aug/21 06:41

Description

We need to improve how inline size is calculated by default for variable-length types.

Currently if a varlength type is encountered inline size just defaults to 10, which is almost always not enough.

A more sensible behavior would be the following:

1. Add a fixed default to the inline size calculation for every variable-length type. For example, if the default inlined size for a string is 10 then an index like (INT, VARCHAR, VARCHAR, INT) should have inline size default as 5 + 10 + 10 + 5 = 30 (5 for each int, 10 for each string).

2. Add special support for VARCHAR_FIXED - if a VARCHAR has known length then that length is used for inline size calculation

Issue Links

• is related to: IGNITE-11402 SQL: Add ability to specify inline size of PK and affinity key indexes from CREATE TABLE
• links to: DevList Thread
• links to: GitHub Pull Request #8161
• links to: GitHub Pull Request #9167