Jonathan Halliday created CASSANDRA-7684:
--------------------------------------------
Summary: flush makes rows invisible to cluster key equality query
Key: CASSANDRA-7684
URL: https://issues.apache.org/jira/browse/CASSANDRA-7684
Project: Cassandra
Issue Type: Bug
Environment: 2.1.0.rc5
Reporter: Jonathan Halliday
{noformat}
CREATE KEYSPACE test WITH replication = {'class': 'SimpleStrategy',
'replication_factor': 1 };
USE test;
CREATE TYPE point_t (x double, y double);
CREATE TABLE points (partitionkey int, b boolean static, clusteringkey point_t,
PRIMARY KEY (partitionkey, clusteringkey) );
INSERT INTO points (partitionkey, clusteringkey) VALUES (1,
{x:-104.9925100000,y:39.7476520000});
select * from points WHERE partitionkey=1 AND clusteringkey =
{x:-104.9925100000,y:39.7476520000};
partitionkey | clusteringkey | b
--------------+-------------------------+------
1 | {x: -104.99, y: 39.748} | null
(1 rows)
cqlsh:test> update points set b = true where partitionkey=1;
cqlsh:test> select * from points WHERE partitionkey=1 AND clusteringkey =
{x:-104.9925100000,y:39.7476520000};
partitionkey | clusteringkey | b
--------------+-------------------------+------
1 | {x: -104.99, y: 39.748} | True
(1 rows)
{noformat}
// run bin/nodetool flush here
{noformat}
cqlsh:test> select * from points WHERE partitionkey=1 AND clusteringkey =
{x:-104.9925100000,y:39.7476520000};
(0 rows)
cqlsh:test> select * from points WHERE partitionkey=1;
partitionkey | clusteringkey | b
--------------+-------------------------+------
1 | {x: -104.99, y: 39.748} | True
(1 rows)
{noformat}
i.e. the data is not lost, it's just invisible when read from sstable, but
visible when read from memtable.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
