[jira] [Assigned] (CASSANDRA-9606) this query is not supported in new version

["Benjamin Lerer (JIRA)" <ji...@apache.org>]

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

Benjamin Lerer reassigned CASSANDRA-9606:
-----------------------------------------

    Assignee: Benjamin Lerer

> this query is not supported in new version
> ------------------------------------------
>
>                 Key: CASSANDRA-9606
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-9606
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>         Environment: cassandra 2.1.6
> jdk 1.7.0_55
>            Reporter: zhaoyan
>            Assignee: Benjamin Lerer
>
> Background:
> 1、create a table:
> {code}
> CREATE TABLE test (
>     a int,
>     b int,
>     c int,
> 	d int,
>     PRIMARY KEY (a, b, c)
> );
> {code}
> 2、query by a=1 and b<6
> {code}
> select * from test where a=1 and b<6;
>  a | b | c | d
> ---+---+---+---
>  1 | 3 | 1 | 2
>  1 | 3 | 2 | 2
>  1 | 3 | 4 | 2
>  1 | 3 | 5 | 2
>  1 | 4 | 4 | 2
>  1 | 5 | 5 | 2
> (6 rows)
> {code}
> 3、query by page
> first page：
> {code}
> select * from test where a=1 and b<6 limit 2;
>  a | b | c | d
> ---+---+---+---
>  1 | 3 | 1 | 2
>  1 | 3 | 2 | 2
> (2 rows)
> {code}
> second page：
> {code}
> select * from test where a=1 and b<6 and (b,c) > (3,2) limit 2;
>  a | b | c | d
> ---+---+---+---
>  1 | 3 | 4 | 2
>  1 | 3 | 5 | 2
> (2 rows)
> {code}
> last page：
> {code}
> select * from test where a=1 and b<6 and (b,c) > (3,5) limit 2;
>  a | b | c | d
> ---+---+---+---
>  1 | 4 | 4 | 2
>  1 | 5 | 5 | 2
> (2 rows)
> {code}
> question:
> this query by page is ok when cassandra 2.0.8.
> but is not supported in the latest version 2.1.6
> when execute：
> {code}
> select * from test where a=1 and b<6 and (b,c) > (3,2) limit 2;
> {code}
> get one error message：
> InvalidRequest: code=2200 [Invalid query] message="Column "b" cannot have both tuple-notation inequalities and single-column inequalities: (b, c) > (3, 2)"



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)