[jira] [Assigned] (IGNITE-16860) Sql. Ability to create table with autogenerated PK values

["Konstantin Orlov (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-16860?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Konstantin Orlov reassigned IGNITE-16860:
-----------------------------------------

    Assignee: Konstantin Orlov

> 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)