[
https://issues.apache.org/jira/browse/CASSANDRA-7052?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13975508#comment-13975508
]
Sylvain Lebresne commented on CASSANDRA-7052:
---------------------------------------------
bq. Can you add test cases for range and secondary index queries?
2ndary index are not affected since the only kind of table concerned are "wide"
compact tables and those can't have index. "Range" queries are in fact broken,
but that has always be the case and will probably require much more work than
this to fix. I've created CASSANDRA-7059 for that.
So regarding this issue, I committed the attached patch since it fixes the
regression from 1.2. I did slightly updated the dtest to include 'IN' queries
though.
> 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
> Fix For: 2.0.8
>
> Attachments: 7052.txt
>
>
> 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)
