Konstantin Orlov created IGNITE-16856:
-----------------------------------------
Summary: 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
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)
