[jira] [Created] (IGNITE-16859) [SQL] Mandatory PK

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

Konstantin Orlov created IGNITE-16859:
-----------------------------------------

             Summary: [SQL] Mandatory PK
                 Key: IGNITE-16859
                 URL: https://issues.apache.org/jira/browse/IGNITE-16859
             Project: Ignite
          Issue Type: Epic
          Components: sql
            Reporter: Konstantin Orlov


Apache Ignite is trying to unite the two worlds SQL and KV together, making the user experience of both worlds as natural as possible. Because of this, the key is considered mandatory.

Nevertheless, the SQL standard allows tables without PK specified, and some customers potentially could have such tables in ther production. Besides, there are external tests (like TCP-H for instance), which don't bothering himself by defining PK which they won't be using anyway.

To make it easier to migrate from tables without a key, let's provide a workaround where we could define a PK whose value will be automatically generated by some function.

To make it easier to adopt external tests, we need to provide ability to inject the key without changing the source scripts. 



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