[jira] [Commented] (CASSANDRA-7305) CQL3, Static columns not returning rows if values are not set
[ https://issues.apache.org/jira/browse/CASSANDRA-7305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=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)
[jira] [Commented] (CASSANDRA-7305) CQL3, Static columns not returning rows if values are not set
[ https://issues.apache.org/jira/browse/CASSANDRA-7305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14010885#comment-14010885 ] Sylvain Lebresne commented on CASSANDRA-7305: - I'm confused, what is made trickier by the fact that queries with regular columns work as expected? 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)
[jira] [Commented] (CASSANDRA-7305) CQL3, Static columns not returning rows if values are not set
[ https://issues.apache.org/jira/browse/CASSANDRA-7305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14010956#comment-14010956 ] Aleksey Yeschenko commented on CASSANDRA-7305: -- Never mind, sorry. Didn't notice 'a' being the partition key, somehow. 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)
[jira] [Commented] (CASSANDRA-7305) CQL3, Static columns not returning rows if values are not set
[ https://issues.apache.org/jira/browse/CASSANDRA-7305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14009853#comment-14009853 ] Sylvain Lebresne commented on CASSANDRA-7305: - I agree that this is not a very consistent result. It stems from the fact that for static columns we said that when only the partition key and static columns where selected, the user probably didn't meant to query the full partition, and so we only query the static part of the partition, hence the result above. In hindsight, I would agree that this is a mistake. We should make such query scan the whole partition the same way a selection of just the partition key still scan the full partition (and return as many results as there is rows). And we should extend DISTINCT so user can still query the static part efficiently. This is going to potentially break current users of static columns however (but they are new enough that it's probably fair game to fix early mistake rather than carry them down indefinitely). 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 Priority: Minor 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)
[jira] [Commented] (CASSANDRA-7305) CQL3, Static columns not returning rows if values are not set
[ https://issues.apache.org/jira/browse/CASSANDRA-7305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=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)