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

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.0.9
• Severity: Normal
• Assignee: Sylvain Lebresne
• Reporter: Patrick Callaghan

Authors

Sylvain Lebresne

Reviewers

Tom Hobbs

• Created: 27/May/14 10:33
• Updated: 16/Apr/19 09:31
• Resolved: 25/Jun/14 14:07

Description

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)

Issue Links

• is duplicated by: CASSANDRA-7277 CQL support for select distinct part_key,static_field from table
• is related to: CASSANDRA-7449 Variation of SELECT DISTINCT to find clustering keys with only static columns