You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladimir Ozerov (JIRA)" <ji...@apache.org> on 2017/06/06 10:56:18 UTC
[jira] [Created] (IGNITE-5422) CREATE TABLE command should support
all-key fields case
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)