[jira] [Created] (CASSANDRA-6377) ALLOW FILTERING should allow seq scan filtering

["Jonathan Ellis (JIRA)" <ji...@apache.org>]

Jonathan Ellis created CASSANDRA-6377:
-----------------------------------------

             Summary: ALLOW FILTERING should allow seq scan filtering
                 Key: CASSANDRA-6377
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6377
             Project: Cassandra
          Issue Type: Bug
          Components: API
            Reporter: Jonathan Ellis
            Assignee: Sylvain Lebresne
            Priority: Minor
             Fix For: 1.2.12, 2.0.3


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.1#6144)