Stefan Miklosovic created CASSANDRA-18477:
---------------------------------------------
Summary: Do not require allow filtering when all primary keys are
specified in SELECT
Key: CASSANDRA-18477
URL: https://issues.apache.org/jira/browse/CASSANDRA-18477
Project: Cassandra
Issue Type: Bug
Components: CQL/Semantics
Reporter: Stefan Miklosovic
This was discussed in
https://lists.apache.org/thread/loj6jgv54szdvyt3wmvbtwwrrg1dtlxq
Basically, when I have this table:
{code}
create table ks.tb (p1 int, c1 int, col1 int, col2 int, primary key (p1, c1));
{code}
and I do this
{code}
select * from ks.tb where p1 = 1 and c1 = 2 and col2 = 1;
{code}
this will fail and it will require to use ALLOW FILTERING just because we are
also specifying "col2". This is clearly a bug - there is no reason to require
it if we are going to fetch one row only as all partition and clustering keys
were specified.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
