[IGNITE-16870] Extend Schema with ability to specify function as default value generator

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0-beta1
• Component/s: sql
• Labels: ignite-3
• Epic Link: Mandatory PK
• Assignee: Konstantin Orlov
• Reporter: Konstantin Orlov
• Created: 18/Apr/22 10:04
• Updated: 13/Oct/22 12:01
• Resolved: 26/Jul/22 14:17

Description

In order to make IGNITE-16860 possible, we need to add an ability to specify a function as a default value generator. It worth to note, that a behaviour of KV API and SQL should be consistent, thus this feature should be derived from a SQL runtime to the common place.

Within this task we need to extend ColumnConfigurationSchema in order to support several types of default value generators (constant and function for now), as well as introduce a new default value supplier for Column.

As a first step, I would propose to support only a few predefined system functions. This could be possibly extended to support an arbitrary function though.

Issue Links

• blocks: IGNITE-16860 Sql. Ability to create table with autogenerated PK values
• fixes: IGNITE-17370 Support empty values of varlen types as default
• is blocked by: IGNITE-17212 Sql. Add support for DEFAULT operator
• links to: GitHub Pull Request #944