Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Thu, 19 Jun 2014 17:00:29 +0000 (UTC)
From: "Sylvain Lebresne (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12716770.1401186798915.9689.1403197229504@arcas>
In-Reply-To: <JIRA.12716770.1401186798915@arcas>
References: <JIRA.12716770.1401186798915@arcas>
Subject: [jira] [Updated] (CASSANDRA-7305) CQL3, Static columns not
 returning rows if values are not set
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/CASSANDRA-7305?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sylvain Lebresne updated CASSANDRA-7305:
----------------------------------------

    Attachment: 7305.txt

Attaching patch that implements what I discuss above: we don't special case queries that only select static columns anymore (as that's arguably inconsistent and unexpected), but we allow static columns with {{DISTINCT}} (and in that case only the very beginning of the partition is queried).

There is also some dtests for this [here|https://github.com/pcmanus/cassandra-dtest/commit/d56f319dea7dedd791faecd1dcc2c64840f30e9c].

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