cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Branden Visser (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-7052) Query on compact storage with limit returns extra rows
Date Fri, 18 Apr 2014 11:37:16 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-7052?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13973993#comment-13973993
] 

Branden Visser commented on CASSANDRA-7052:
-------------------------------------------

This doesn't appear to be an issue on a 1.2.11-SNAPSHOT version of Cassandra I have installed
currently:

{code}
cqlsh:test> SELECT * FROM "VerifyPagedColumnQueryStartAndEnd" WHERE "keyId" = 'key' AND
"columnName" > '' AND "columnName" <= 'e' LIMIT 2;

 keyId | columnName | value
-------+------------+-------
   key |          a |     1
   key |          b |     1

{code}

> 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)

Mime
View raw message