You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Konstantin Orlov (Jira)" <ji...@apache.org> on 2022/04/15 13:20:00 UTC

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

Konstantin Orlov created IGNITE-16860:
-----------------------------------------

             Summary: 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
         Environment: 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.
            Reporter: Konstantin Orlov






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