[
https://issues.apache.org/jira/browse/IGNITE-16860?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-16860:
--------------------------------------
Ignite Flags: Release Notes Required (was: Docs Required,Release Notes
Required)
> Sql. Ability to create table with autogenerated PK values
> ---------------------------------------------------------
>
> Key: IGNITE-16860
> URL: https://issues.apache.org/jira/browse/IGNITE-16860
> Project: Ignite
> Issue Type: New Feature
> Components: sql
> Reporter: Konstantin Orlov
> Assignee: Konstantin Orlov
> Priority: Major
> Labels: ignite-3
>
> 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:
> {noformat}
> CREATE TABLE my_table (id UUID DEFAULT gen_random_uuid PRIMARY KEY, <other
> columns>){noformat}
> 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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
