[CASSANDRA-11619] "SELECT" returns incorrect result in some cases

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Duplicate

Environment

Windows 7, DDC 3.4.0/3.5.0

• Severity: Normal
• Since Version: 3.4
• Assignee: Unassigned
• Reporter: untitled
• Created: 20/Apr/16 13:05
• Updated: 16/Apr/19 09:30
• Resolved: 20/Apr/16 15:03

Description

In tables like
"CREATE TABLE test (
pk uuid,
ck1 uuid,
ck2 uuid,
st text STATIC,
data text,
PRIMARY KEY (pk, ck1, ck2)
);"
after some inserts in one partition with not empty static column and restart of Cassandra, next sequence "insert -> select with same pk an cks" returns whole partition, this can be fixed by compaction. Default configuration was used.
"CREATE KEYSPACE keyspace1
WITH replication =

{ 'class' : 'SimpleStrategy', 'replication_factor' : 1 }

;"
was used. Unable to reproduce this on 3.3.0. This might be associated with separation of sstables files, exact reason is unknown as well as exact conditions.

Issue Links

• duplicates: CASSANDRA-11513 Result set is not unique on primary key (cql)