[ https://issues.apache.org/jira/browse/CASSANDRA-7052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sylvain Lebresne reassigned CASSANDRA-7052: ------------------------------------------- Assignee: Sylvain Lebresne > 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 > Assignee: Sylvain Lebresne > > 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)