You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Benjamin Lerer (JIRA)" <ji...@apache.org> on 2016/03/02 17:22:18 UTC
[jira] [Commented] (CASSANDRA-6377) ALLOW FILTERING should allow
seq scan filtering
[ https://issues.apache.org/jira/browse/CASSANDRA-6377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15175867#comment-15175867 ]
Benjamin Lerer commented on CASSANDRA-6377:
-------------------------------------------
I have pushed the fix for the review comments.
The tombstones were added to make sure that the filtering was working properly with them. I added a comment to clarify the code.
||Branch||Unit tests||DTests||
|[2.2|https://github.com/blerer/cassandra/tree/6377-2.2]|[2.2|http://cassci.datastax.com/view/Dev/view/blerer/job/blerer-6377-2.2-testall/4/]|[2.2|http://cassci.datastax.com/view/Dev/view/blerer/job/blerer-6377-2.2-dtest/4/]|
|[3.0|https://github.com/blerer/cassandra/tree/6377-3.0]|[3.0|http://cassci.datastax.com/view/Dev/view/blerer/job/blerer-6377-3.0-testall/4/]|[3.0|http://cassci.datastax.com/view/Dev/view/blerer/job/blerer-6377-3.0-dtest/4/]|
|[trunk|https://github.com/blerer/cassandra/tree/6377-trunk]|[trunk|http://cassci.datastax.com/view/Dev/view/blerer/job/blerer-6377-trunk-testall/5/]|[trunk|http://cassci.datastax.com/view/Dev/view/blerer/job/blerer-6377-trunk-dtest/6/]|
> ALLOW FILTERING should allow seq scan filtering
> -----------------------------------------------
>
> Key: CASSANDRA-6377
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6377
> Project: Cassandra
> Issue Type: Improvement
> Components: CQL
> Reporter: Jonathan Ellis
> Assignee: Benjamin Lerer
> Labels: cql
> Fix For: 3.0.x, 3.x
>
>
> CREATE TABLE emp_table2 (
> empID int PRIMARY KEY,
> firstname text,
> lastname text,
> b_mon text,
> b_day text,
> b_yr text,
> );
> INSERT INTO emp_table2 (empID,firstname,lastname,b_mon,b_day,b_yr)
> VALUES (100,'jane','doe','oct','31','1980');
> INSERT INTO emp_table2 (empID,firstname,lastname,b_mon,b_day,b_yr)
> VALUES (101,'john','smith','jan','01','1981');
> INSERT INTO emp_table2 (empID,firstname,lastname,b_mon,b_day,b_yr)
> VALUES (102,'mary','jones','apr','15','1982');
> INSERT INTO emp_table2 (empID,firstname,lastname,b_mon,b_day,b_yr)
> VALUES (103,'tim','best','oct','25','1982');
>
> SELECT b_mon,b_day,b_yr,firstname,lastname FROM emp_table2
> WHERE b_mon='oct' ALLOW FILTERING;
> Bad Request: No indexed columns present in by-columns clause with Equal operator
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)