[jira] [Created] (IGNITE-5422) CREATE TABLE command should support all-key fields case

[Anton Vinogradov (Jira)]

Vladimir Ozerov created IGNITE-5422:
---------------------------------------

             Summary: CREATE TABLE command should support all-key fields case
                 Key: IGNITE-5422
                 URL: https://issues.apache.org/jira/browse/IGNITE-5422
             Project: Ignite
          Issue Type: Task
          Components: sql
            Reporter: Vladimir Ozerov
            Assignee: Alexander Paschenko
             Fix For: 2.2


Currently it is impossible to create a table containing only {{PRIMARY KEY}} columns:
{code}
CREATE TABLE PersonProject {
    person_id BIGINT,
    project_id BIGINT,
    PRIMARY KEY (person_id, project_id);
};
{code}
The reason for this limitation is that we have nothing to be saved as cache value and {{null}} values are restricted because they are indistinguishable from removal.

We should allow this case somehow. Possible solutions:
1) Save empty object of table type: {{IgniteBinary.builder("PersonProject").build()}}
2) Save {{false}} as it is done in Java in Map-to-Set conversion

Note that DML processing should be adjusted accordingly.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)