[ https://issues.apache.org/jira/browse/CASSANDRA-7305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14042493#comment-14042493 ]
Tyler Hobbs commented on CASSANDRA-7305: ---------------------------------------- A few minor comments: * A space is missing in this error message: {{"SELECT DISTINCT queries must only request partition key columns and/or static columns(not %s)"}} * The {{select_distinct_test}} dtest method checks error messages that this patch changes, so it now fails * Make sure to update NEWS.txt describing the behavioral changes for existing static columns users Other than that, +1 > 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 > Fix For: 2.0.9 > > Attachments: 7305.txt > > > 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)