[jira] [Updated] (IGNITE-16856) Sql. Ability to create table without specifying PK

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

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

Konstantin Orlov updated IGNITE-16856:
--------------------------------------
    Labels: ignite-3  (was: )

> Sql. Ability to create table without specifying PK
> --------------------------------------------------
>
>                 Key: IGNITE-16856
>                 URL: https://issues.apache.org/jira/browse/IGNITE-16856
>             Project: Ignite
>          Issue Type: New Feature
>          Components: sql
>            Reporter: Konstantin Orlov
>            Priority: Major
>              Labels: ignite-3
>
> Despite a keyless use case currently is not supported by Ignite-3, SQL standard allows to create such tables, and many external tests (TCP-H for instance) are taking advantage of this.
> To ease of adoption such a tests, let's provide a special mode for Ignite, where implicit PK will be created in case of lack explicit one.
> Key points to consider:
>  * This mode considered for test purpose only, hence the implementation should be as less invasive as possible.
>  * An implicit key column should not be returned by {{SELECT *}} queries. It may be accessed by its name though.
>  * Type of this column doesn't matter, but the range of possible values should be big enough to support billiones of unique values.



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