[CASSANDRA-6377] ALLOW FILTERING should allow seq scan filtering

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.2.6, 3.0.5, 3.5
• Component/s: Legacy/CQL
• Labels: cql doc-impacting
• Assignee: Benjamin Lerer
• Reporter: Jonathan Ellis

Authors

Benjamin Lerer

Reviewers

Sam Tunnicliffe

• Created: 19/Nov/13 17:48
• Updated: 14/May/19 11:09
• Resolved: 04/Mar/16 21:22

Description

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

Issue Links

• breaks: CASSANDRA-15126 Resource leak when queries apply a RowFilter
• is depended upon by: CASSANDRA-10715 Allow filtering on NULL
• is duplicated by: CASSANDRA-7079 allow filtering within wide row
• is duplicated by: CASSANDRA-11031 Allow filtering on partition key columns for queries without secondary indexes
• is duplicated by: CASSANDRA-8424 Collection filtering not working when using PK
• is duplicated by: CASSANDRA-10356 Add row filters like in HBase
• is related to: CASSANDRA-4987 Support more queries when ALLOW FILTERING is used.