[CASSANDRA-6532] Deleting and re-adding counter causes null count value.

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Invalid
• Labels: counters

Environment

cqlsh 4.1.0 | Cassandra 2.0.3 | CQL spec 3.1.1 | Thrift protocol 19.38.0

• Assignee: Unassigned
• Reporter: Gregory Ramsperger
• Created: 27/Dec/13 21:42
• Updated: 16/Apr/19 09:31
• Resolved: 28/Dec/13 00:23

Description

After a specific counter has been deleted, recreating a new counter with the same key causes the value to be permanently null.

cqlsh:demo> create table DemoCounter ( pk  text primary key, cnt counter );
cqlsh:demo> update DemoCounter set cnt = cnt + 1 where pk = 'foo';
cqlsh:demo> select * from DemoCounter;

 pk  | cnt
-----+-----
 foo |   1

(1 rows)

cqlsh:demo> delete from DemoCounter where pk = 'foo';
cqlsh:demo> select * from DemoCounter;

(0 rows)

cqlsh:demo> update DemoCounter set cnt = cnt + 1 where pk = 'foo';
cqlsh:demo> select * from DemoCounter;

 pk  | cnt
-----+------
 foo | null

(1 rows)

cqlsh:demo>