[CASSANDRA-8206] Deleting columns breaks secondary index on clustering column

• Type: Bug
• Status: Resolved
• Priority: Urgent
• Resolution: Fixed
• Fix Version/s: 2.0.12, 2.1.2
• Component/s: Feature/2i Index
• Labels: qa-resolved
• Severity: Critical
• Since Version: 2.0.6
• Assignee: Sylvain Lebresne
• Reporter: Tuukka Mustonen

Authors

Sylvain Lebresne

Reviewers

Tom Hobbs

• Tester: Philip Thompson
• Created: 29/Oct/14 08:35
• Updated: 16/Apr/19 09:31
• Resolved: 04/Nov/14 17:44

Description

Removing items from a set breaks index for field id:

cqlsh:cs> CREATE TABLE buckets (
      ...   tenant int,
      ...   id int,
      ...   items set<text>,
      ...   PRIMARY KEY (tenant, id)
      ... );
cqlsh:cs> CREATE INDEX buckets_ids ON buckets(id);
cqlsh:cs> INSERT INTO buckets (tenant, id, items) VALUES (1, 1, {'foo', 'bar'});
cqlsh:cs> SELECT * FROM buckets;

 tenant | id | items
--------+----+----------------
      1 |  1 | {'bar', 'foo'}

(1 rows)

cqlsh:cs> SELECT * FROM buckets WHERE id = 1;

 tenant | id | items
--------+----+----------------
      1 |  1 | {'bar', 'foo'}

(1 rows)

cqlsh:cs> UPDATE buckets SET items=items-{'foo'} WHERE tenant=1 AND id=1;
cqlsh:cs> SELECT * FROM buckets;

 tenant | id | items
--------+----+---------
      1 |  1 | {'bar'}

(1 rows)

cqlsh:cs> SELECT * FROM buckets WHERE id = 1;

(0 rows)

Re-building the index fixes the issue:

cqlsh:cs> DROP INDEX buckets_ids;
cqlsh:cs> CREATE INDEX buckets_ids ON buckets(id);
cqlsh:cs> SELECT * FROM buckets WHERE id = 1;

 tenant | id | items
--------+----+---------
      1 |  1 | {'bar'}

(1 rows)

Adding items does not cause similar failure, only delete. Also didn't test if other collections are also affected

Issue Links

• is duplicated by: CASSANDRA-7485 Missing data from secondary index when secondary index is against a compound PK member
• relates to: CASSANDRA-6782 setting TTL on some columns seems to expire whole row