[jira] [Commented] (CASSANDRA-7305) CQL3, Static columns not returning rows if values are not set

["Tyler Hobbs (JIRA)" <ji...@apache.org>]

    [ 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)