Artem Soloviov created CASSANDRA-11165:
------------------------------------------
Summary: Static column restriction ignored
Key: CASSANDRA-11165
URL: https://issues.apache.org/jira/browse/CASSANDRA-11165
Project: Cassandra
Issue Type: Bug
Components: Local Write-Read Paths
Environment: [cqlsh 5.0.1 | Cassandra 3.3 | CQL spec 3.4.0 | Native
protocol v4]
Reporter: Artem Soloviov
Priority: Minor
Applying restriction on static field value does not affect any results.
{code}
CREATE TABLE t (k text, s text static, i int, PRIMARY KEY(k,i));
INSERT INTO t (k, s, i) VALUES ( 'a','static value',1);
INSERT INTO t (k, s, i) VALUES ( 'b','other value',2);
SELECT * FROM t WHERE k = 'b' AND s = 'static value' ALLOW FILTERING ;
{code}
*Expected result:*
empty set
*Actual result:*
{code}
k | i | s
---+---+-------------
b | 2 | other value
(1 rows)
{code}
{code}
SELECT * FROM t WHERE i = 2 AND s = 'static value' ALLOW FILTERING ;
{code}
*Expected result:*
empty set
*Actual result:*
{code}
k | i | s
---+---+-------------
b | 2 | other value
(1 rows)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
