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)
