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