cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Adam Holmberg (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-10380) SELECT count within a partition does not respect LIMIT
Date Mon, 21 Sep 2015 17:54:04 GMT
Adam Holmberg created CASSANDRA-10380:
-----------------------------------------

             Summary: SELECT count within a partition does not respect LIMIT
                 Key: CASSANDRA-10380
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-10380
             Project: Cassandra
          Issue Type: Bug
          Components: Core
            Reporter: Adam Holmberg
            Priority: Minor


{code}
cassandra@cqlsh> create KEYSPACE test WITH replication = {'class': 'SimpleStrategy', 'replication_factor':
'1'};
cassandra@cqlsh> use test;
cassandra@cqlsh:test> create table t (k int, c int, v int, primary key (k, c));
cassandra@cqlsh:test> INSERT INTO t (k, c, v) VALUES (0, 0, 0);
cassandra@cqlsh:test> INSERT INTO t (k, c, v) VALUES (0, 1, 0);
cassandra@cqlsh:test> INSERT INTO t (k, c, v) VALUES (0, 2, 0);
cassandra@cqlsh:test> select * from t where k = 0;

 k | c | v
---+---+---
 0 | 0 | 0
 0 | 1 | 0
 0 | 2 | 0

(3 rows)
cassandra@cqlsh:test> select count(*) from t where k = 0 limit 2;

 count
-------
     3

(1 rows)
{code}

Expected: count should return 2, according to limit.
Actual: count of all rows in partition

This manifests in 3.0, does not appear in 2.2



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message