[
https://issues.apache.org/jira/browse/CASSANDRA-9606?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14648884#comment-14648884
]
Sam Tunnicliffe commented on CASSANDRA-9606:
--------------------------------------------
Sorry, this is still waiting for review. I'll try and get to it in the next few
days so it will probably make it into the next release on each target branch
(2.0.17, 2.1.9, 2.2.1).
> 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
> Attachments: 9606-2.0.txt, 9606-2.1.txt, 9606-2.2.txt
>
>
> 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)
