[
https://issues.apache.org/jira/browse/CASSANDRA-7636?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Krzysztof Zarzycki updated CASSANDRA-7636:
------------------------------------------
Description:
I have a table on which I'm running some SELECTs with WHERE clause filtering on
cluster columns, but the rows are not getting filtered out.
Look:
cqlsh:leadbullet> create KEYSPACE test_keyspace WITH replication = {'class':
'SimpleStrategy', 'replication_factor': 1};
cqlsh:leadbullet> use test_keyspace ;
cqlsh:test_keyspace> CREATE TABLE test ( p1 bigint, c1 int, PRIMARY
KEY (p1, c1) ) WITH caching = '{"keys":"NONE", "rows_per_partition":"ALL"}';
cqlsh:test_keyspace> insert into test (p1, c1 ) values ( 123, 10);
cqlsh:test_keyspace> select * from test where p1 = 123 and c1 > 10;
(0 rows)
cqlsh:test_keyspace> select * from test where p1 = 123 and c1 > 9;
p1 | c1
-----+----
123 | 10
(1 rows)
cqlsh:test_keyspace> select * from test where p1 = 123 and c1 > 10;
p1 | c1
-----+----
123 | 10
(1 rows)
The filtering on other (partition) columns runs fine. Only the clustering
column is somewhat malfunctioning.
was:
I have a table on which I'm running some SELECTs with WHERE clause filtering on
cluster columns, but the rows are not getting filtered out.
Look:
cqlsh:leadbullet> create KEYSPACE test_keyspace WITH replication = {'class':
'SimpleStrategy', 'replication_factor': 1};
cqlsh:leadbullet> use test_keyspace ;
cqlsh:test_keyspace> CREATE TABLE test ( p1 bigint, c1 int, PRIMARY
KEY (p1, c1) ) WITH caching = '{"keys":"NONE", "rows_per_partition":"ALL"}';
cqlsh:test_keyspace> insert into test (p1, c1 ) values ( 123, 10);
cqlsh:test_keyspace> select * from test where p1 = 1395139215166955 and c1 > 10;
(0 rows)
cqlsh:test_keyspace> select * from test where p1 = 123 and c1 > 10;
(0 rows)
cqlsh:test_keyspace> select * from test where p1 = 123 and c1 > 9;
p1 | c1
-----+----
123 | 10
(1 rows)
cqlsh:test_keyspace> select * from test where p1 = 123 and c1 > 10;
p1 | c1
-----+----
123 | 10
(1 rows)
The filtering on other (partition) columns runs fine. Only the clustering
column is somewhat malfunctioning.
> Data is not filtered out when using WHERE clause on cluster column
> ------------------------------------------------------------------
>
> Key: CASSANDRA-7636
> URL: https://issues.apache.org/jira/browse/CASSANDRA-7636
> Project: Cassandra
> Issue Type: Bug
> Environment: Cassandra 2.1.0-rc4
> Reporter: Krzysztof Zarzycki
>
> I have a table on which I'm running some SELECTs with WHERE clause filtering
> on cluster columns, but the rows are not getting filtered out.
> Look:
> cqlsh:leadbullet> create KEYSPACE test_keyspace WITH replication = {'class':
> 'SimpleStrategy', 'replication_factor': 1};
> cqlsh:leadbullet> use test_keyspace ;
> cqlsh:test_keyspace> CREATE TABLE test ( p1 bigint, c1 int,
> PRIMARY KEY (p1, c1) ) WITH caching = '{"keys":"NONE",
> "rows_per_partition":"ALL"}';
> cqlsh:test_keyspace> insert into test (p1, c1 ) values ( 123, 10);
> cqlsh:test_keyspace> select * from test where p1 = 123 and c1 > 10;
> (0 rows)
> cqlsh:test_keyspace> select * from test where p1 = 123 and c1 > 9;
> p1 | c1
> -----+----
> 123 | 10
> (1 rows)
> cqlsh:test_keyspace> select * from test where p1 = 123 and c1 > 10;
> p1 | c1
> -----+----
> 123 | 10
> (1 rows)
> The filtering on other (partition) columns runs fine. Only the clustering
> column is somewhat malfunctioning.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
