[IGNITE-16860] Sql. Ability to create table with autogenerated PK values

• Type: New Feature
• 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: 15/Apr/22 13:19
• Updated: 13/Oct/22 12:01
• Resolved: 27/Jul/22 08:52

Description

To make it easier for users to migrate from systems which allow table without PK, let's introduce an ability to create tables with PK whose value is autogenerated by system function. The syntax could look like this:

CREATE TABLE my_table (id UUID DEFAULT gen_random_uuid PRIMARY KEY, <other columns>)

Where gen_random_uuid is a system function returning a random UUID value.

Within this ticket we need to update grammar for CREATE TABLE operation and make all sql-runtime related changes to properly handle such default values. 

Issue Links

• is blocked by: IGNITE-16870 Extend Schema with ability to specify function as default value generator
• links to: GitHub Pull Request #955
• links to: GitHub Pull Request #1026
• links to: PR