[jira] [Updated] (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 updated IGNITE-16860:
--------------------------------------
    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:
{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.

> 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
>            Reporter: Konstantin Orlov
>            Priority: Major
>
> 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.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)