Thanh created CASSANDRA-7903:
--------------------------------
Summary: tombstone created upon insert of new row
Key: CASSANDRA-7903
URL: https://issues.apache.org/jira/browse/CASSANDRA-7903
Project: Cassandra
Issue Type: Bug
Reporter: Thanh
Tombstone is created upon insert of new row, depending on how the row is
inserted.
Simple way to observe this behavior:
Using cqlsh:
CREATE TABLE users1 (
userid text PRIMARY KEY,
first_name text,
last_name text);
insert into users1 (userid, first_name) values ('a','a');
tracing on;
select * from users;
Trace results show 1 live cell and 0 tombstone cells created as a result:
userid | first_name | last_name
--------+------------+-----------
a | a | null
(1 rows)
…
Read 1 live and 0 tombstoned cells | 00:31:31,487 | 10.240.203.201 |
1275
Scanned 1 rows and matched 1 | 00:31:31,487 | 10.240.203.201 |
1328
…
Now,
insert into users1 (userid, first_name,last_name) values ('b','b',null);
select * from users;
Trace results show 1 live cell and 1 tombstone cell created as a result:
userid | first_name | last_name
--------+------------+-----------
a | a | null
b | b | null
(2 rows)
…
Read 1 live and 0 tombstoned cells | 00:35:09,357 | 10.240.203.201 |
1243
Read 1 live and 1 tombstoned cells | 00:35:09,357 | 10.240.203.201 |
1383
Scanned 2 rows and matched 2 | 00:35:09,357 | 10.240.203.201 |
1438
…
Tombstone is not expected to be created in either case.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
