Stuart Freeman created CASSANDRA-7052:
-----------------------------------------
Summary: Query on compact storage with limit returns extra rows
Key: CASSANDRA-7052
URL: https://issues.apache.org/jira/browse/CASSANDRA-7052
Project: Cassandra
Issue Type: Bug
Reporter: Stuart Freeman
I tested this on Cassandra 2.0.6 and 2.0.3 and got the same result on both:
{code}
cqlsh> create KEYSPACE "test" WITH replication = {'class': 'SimpleStrategy',
'replication_factor': 1};
cqlsh> USE "test";
cqlsh:test> CREATE COLUMNFAMILY "VerifyPagedColumnQueryStartAndEnd" ("keyId"
text, "columnName" text, "value" text, PRIMARY KEY ("keyId", "columnName"))
WITH COMPACT STORAGE;
cqlsh:test> INSERT INTO "VerifyPagedColumnQueryStartAndEnd" ("keyId",
"columnName", "value") VALUES ( 'key', 'a', '1' ) ;
cqlsh:test> INSERT INTO "VerifyPagedColumnQueryStartAndEnd" ("keyId",
"columnName", "value") VALUES ( 'key', 'b', '1' ) ;
cqlsh:test> INSERT INTO "VerifyPagedColumnQueryStartAndEnd" ("keyId",
"columnName", "value") VALUES ( 'key', 'c', '1' ) ;
cqlsh:test> INSERT INTO "VerifyPagedColumnQueryStartAndEnd" ("keyId",
"columnName", "value") VALUES ( 'key', 'd', '1' ) ;
cqlsh:test> INSERT INTO "VerifyPagedColumnQueryStartAndEnd" ("keyId",
"columnName", "value") VALUES ( 'key', 'e', '1' ) ;
cqlsh:test> SELECT * FROM "VerifyPagedColumnQueryStartAndEnd" WHERE "keyId" =
'key' AND "columnName" > '' AND "columnName" <= 'e' LIMIT 2;
keyId | columnName | value
-------+------------+-------
key | a | 1
key | b | 1
key | c | 1
(3 rows)
cqlsh:test>
{code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
