[jira] [Commented] (CASSANDRA-14345) Empty partition keys allowed in MV, but not in normal table

["Duarte Nunes (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-14345?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16415529#comment-16415529 ] 

Duarte Nunes commented on CASSANDRA-14345:
------------------------------------------

It's also puzzling that I can have an empty partition key if it's multicolumn:
{code:sql}
create table t (a text, b text, c text, primary key ((a, b)))

cqlsh:ks> insert into t (a, b, c) values ('', '', '');
cqlsh:ks> select * from t;

 a | b | c
---+---+---
   |   |
{code}

> Empty partition keys allowed in MV, but not in normal table
> -----------------------------------------------------------
>
>                 Key: CASSANDRA-14345
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-14345
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Materialized Views
>            Reporter: Duarte Nunes
>            Priority: Major
>              Labels: materializedviews
>
> Given the following table:
>  
> {code:java}
> cqlsh> create keyspace ks WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};
>  cqlsh> create table t (p text, c int, v text, primary key (p));
>  cqlsh> use ks;
> {code}
> The following fails:
> {code:java}
> cqlsh:ks> insert into t (p, c, v) values ('', 2, '');
>  InvalidRequest: Error from server: code=2200 [Invalid query] message="Key may not be empty"{code}
> However, MVs don't appear to have this restriction:
> {code:java}
> create materialized view mv as select * from t where v is not null and p is not null and c is not null primary key (v, p);
> insert into t (p, c, v) values ('a', 2, '');
> select * from mv;
>  v | p | c
> ---+---+---
>    | a | 2
> {code}
> I think the behavior should be made consistent, if nothing else because 
>  querying the MV for the empty key is impossible:
> {code:java}
> cqlsh:ks> select * from mv where v = '';
>  InvalidRequest: Error from server: code=2200 [Invalid query] message="Key may not be empty"{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org