[jira] [Commented] (CASSANDRA-12426) Writing a null value into a dense table results into a no-op

2016-08-10 Thread Jeremiah Jordan (JIRA)

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

Jeremiah Jordan commented on CASSANDRA-12426:
-

+1 on "Won't Fix" this is the correct behavior for COMPACT STORAGE

> Writing a null value into a dense table results into a no-op 
> -
>
> Key: CASSANDRA-12426
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12426
> Project: Cassandra
>  Issue Type: Bug
>Reporter: Alex Petrov
>
> Making an insert into the dense table doesn't seem to create a live partition:
> {code}
> cqlsh> CREATE KEYSPACE test WITH replication = {'class': 
> 'NetworkTopologyStrategy', 'datacenter1': '1' };
> cqlsh> use test ;
> cqlsh:test> CREATE TABLE a (partition text, key text, owner text, PRIMARY KEY 
> (partition, key) ) WITH COMPACT STORAGE;
> cqlsh:test> INSERT INTO a (partition, key, owner) VALUES ('a', 'b', null);
> cqlsh:test> select * from a;
>  partition | key | owner
> ---+-+
> {code}
> (same behaviour on 2.2)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CASSANDRA-12426) Writing a null value into a dense table results into a no-op

2016-08-10 Thread Aleksey Yeschenko (JIRA)

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

Aleksey Yeschenko commented on CASSANDRA-12426:
---

I feel like changing it in 3.0 would break existing behaviour that some users 
might be relying on. I'd say leave it be.

And we'll soon have CASSANDRA-10857 in, for those who want to switch the 
behaviour.

> Writing a null value into a dense table results into a no-op 
> -
>
> Key: CASSANDRA-12426
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12426
> Project: Cassandra
>  Issue Type: Bug
>Reporter: Alex Petrov
>
> Making an insert into the dense table doesn't seem to create a live partition:
> {code}
> cqlsh> CREATE KEYSPACE test WITH replication = {'class': 
> 'NetworkTopologyStrategy', 'datacenter1': '1' };
> cqlsh> use test ;
> cqlsh:test> CREATE TABLE a (partition text, key text, owner text, PRIMARY KEY 
> (partition, key) ) WITH COMPACT STORAGE;
> cqlsh:test> INSERT INTO a (partition, key, owner) VALUES ('a', 'b', null);
> cqlsh:test> select * from a;
>  partition | key | owner
> ---+-+
> {code}
> (same behaviour on 2.2)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CASSANDRA-12426) Writing a null value into a dense table results into a no-op

2016-08-10 Thread Alex Petrov (JIRA)

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

Alex Petrov commented on CASSANDRA-12426:
-

So the behaviour is correct: after insert, we can not differentiate between 
partition that was inserted with null and that was never existing? Should it be 
same for 3.x, or it should return {{'a', 'b', null}} in 3.0?

> Writing a null value into a dense table results into a no-op 
> -
>
> Key: CASSANDRA-12426
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12426
> Project: Cassandra
>  Issue Type: Bug
>Reporter: Alex Petrov
>
> Making an insert into the dense table doesn't seem to create a live partition:
> {code}
> cqlsh> CREATE KEYSPACE test WITH replication = {'class': 
> 'NetworkTopologyStrategy', 'datacenter1': '1' };
> cqlsh> use test ;
> cqlsh:test> CREATE TABLE a (partition text, key text, owner text, PRIMARY KEY 
> (partition, key) ) WITH COMPACT STORAGE;
> cqlsh:test> INSERT INTO a (partition, key, owner) VALUES ('a', 'b', null);
> cqlsh:test> select * from a;
>  partition | key | owner
> ---+-+
> {code}
> (same behaviour on 2.2)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CASSANDRA-12426) Writing a null value into a dense table results into a no-op

2016-08-10 Thread Aleksey Yeschenko (JIRA)

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

Aleksey Yeschenko commented on CASSANDRA-12426:
---

It's not supposed to. We are not using row markers for {{COMPACT STORAGE}} 
tables (in 2.x).

> Writing a null value into a dense table results into a no-op 
> -
>
> Key: CASSANDRA-12426
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12426
> Project: Cassandra
>  Issue Type: Bug
>Reporter: Alex Petrov
>
> Making an insert into the dense table doesn't seem to create a live partition:
> {code}
> cqlsh> CREATE KEYSPACE test WITH replication = {'class': 
> 'NetworkTopologyStrategy', 'datacenter1': '1' };
> cqlsh> use test ;
> cqlsh:test> CREATE TABLE a (partition text, key text, owner text, PRIMARY KEY 
> (partition, key) ) WITH COMPACT STORAGE;
> cqlsh:test> INSERT INTO a (partition, key, owner) VALUES ('a', 'b', null);
> cqlsh:test> select * from a;
>  partition | key | owner
> ---+-+
> {code}
> (same behaviour on 2.2)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)