[ https://issues.apache.org/jira/browse/CASSANDRA-7305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14009864#comment-14009864 ]
Aleksey Yeschenko commented on CASSANDRA-7305: ---------------------------------------------- I think it's trickier than that. A similar query (one static, one regular column) SELECT b, c FROM statictest; - actually does return the correct result. > CQL3, Static columns not returning rows if values are not set > ------------------------------------------------------------- > > Key: CASSANDRA-7305 > URL: https://issues.apache.org/jira/browse/CASSANDRA-7305 > Project: Cassandra > Issue Type: Bug > Components: Core > Reporter: Patrick Callaghan > Assignee: Sylvain Lebresne > > Just a quick note on static columns, if you create some cql rows using > clustered columns and don't provide a value for a static column, then > selecting the row key with the (null) static column won't return any rows. > create table statictest( a int, b text static, c text, PRIMARY KEY (a, c)); > insert into statictest (a, c) values (1, 'test'); > select a,b from statictest; > (0 rows) -- This message was sent by Atlassian JIRA (v6.2#6252)