[
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.
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.
was:
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
> Components: sql
> Reporter: 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.1#820001)
