[jira] [Updated] (CASSANDRA-7485) Missing data from secondary index when secondary index is against a compound PK member

["Vahram Sukyas (JIRA)" <ji...@apache.org>]

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

Vahram Sukyas updated CASSANDRA-7485:
-------------------------------------

    Summary: Missing data from secondary index when secondary index is against a compound PK member  (was: Missing data from secondary index CF when secondary index is against a compound PK member)

> Missing data from secondary index 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)