[jira] [Commented] (CASSANDRA-12426) Writing a null value into a dense table results into a no-op
[ 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
[ 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
[ 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
[ 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)