cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sam Tunnicliffe (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (CASSANDRA-11165) Static column restriction ignored
Date Mon, 15 Feb 2016 09:43:18 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-11165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Sam Tunnicliffe resolved CASSANDRA-11165.
-----------------------------------------
    Resolution: Duplicate

Closing as a duplicate of CASSANDRA-10958, a fix for which was included as part of CASSANDRA-8103

> 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)

Mime
View raw message