[ https://issues.apache.org/jira/browse/CASSANDRA-6377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15179650#comment-15179650 ]
Sam Tunnicliffe commented on CASSANDRA-6377: -------------------------------------------- +1 on the patches, +0 on changing the ticket type. A quick grep shows there are quite a few places in tests (on all 3 branches) where we should use {{StatementRestrictions.REQUIRES_ALLOW_FILTERING_MESSAGE}}, I know it's very nit-picky, but it would be good to fix those on commit. > 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)