Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Tue, 1 Jul 2014 16:54:25 +0000 (UTC)
From: "Vahram Sukyas (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12724767.1404233576312.81636.1404233665411@arcas>
In-Reply-To: <JIRA.12724767.1404233576312@arcas>
References: <JIRA.12724767.1404233576312@arcas>
Subject: [jira] [Created] (CASSANDRA-7485) Missing data from secondary index
 CF when secondary index is against a compound PK member
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Vahram Sukyas created CASSANDRA-7485:
----------------------------------------

             Summary: Missing data from secondary index CF when secondary index is against a compound PK member
                 Key: CASSANDRA-7485
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-7485
             Project: Cassandra
          Issue Type: Bug
          Components: Core
            Reporter: Vahram Sukyas


Under 2.0.8, assuming the following schema:

CREATE TABLE foo (
  a text,
  b text,
  c text,
  d text,
  PRIMARY KEY (a, b)
);

CREATE INDEX foo_b_idx ON foo (b);

If you do a delete against c or d but specify a and b in the where clause, it will remove the secondary index reference to b (verified that it removes it from the underlying SSTable as well).

Example:

cqlsh:test> insert into foo (a, b, c, d) values ('test','test2','to_be_deleted', 'test3');
cqlsh:test> select * from foo;

 a    | b     | c             | d
------+-------+---------------+-------
 test | test2 | to_be_deleted | test3

(1 rows)

cqlsh:test> delete c from foo where a = 'test' and b = 'test2';

cqlsh:test> select * from foo where b = 'test2';

(0 rows)

cqlsh:test> select * from foo where a = 'test' and b = 'test2';

 a    | b     | c    | d
------+-------+------+-------
 test | test2 | null | test3

(1 rows)

cqlsh:test> select * from foo;

 a    | b     | c    | d
------+-------+------+-------
 test | test2 | null | test3

(1 rows)


--
This message was sent by Atlassian JIRA
(v6.2#6252)