ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vladimir Ozerov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-5422) CREATE TABLE command should support all-key fields case
Date Tue, 06 Jun 2017 10:56:18 GMT
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:
CREATE TABLE PersonProject {
    person_id BIGINT,
    project_id BIGINT,
    PRIMARY KEY (person_id, project_id);
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

View raw message