Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Wed, 17 Jun 2015 01:49:00 +0000 (UTC)
From: "zhaoyan (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12838360.1434505709000.92481.1434505740366@Atlassian.JIRA>
In-Reply-To: <JIRA.12838360.1434505709000@Atlassian.JIRA>
References: <JIRA.12838360.1434505709000@Atlassian.JIRA>
 <JIRA.12838360.1434505709764@arcas>
Subject: [jira] [Created] (CASSANDRA-9606) this query is not supported in
 new version
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

zhaoyan created CASSANDRA-9606:
----------------------------------

             Summary: 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


Background:

1=E3=80=81create a table:
{code}
CREATE TABLE test (
    a int,
    b int,
    c int,
=09d int,
    PRIMARY KEY (a, b, c)
);
{code}
2=E3=80=81query by a=3D1 and b<3
{code}
select * from test where a=3D1 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=E3=80=81query by page
first page=EF=BC=9A
{code}
select * from test where a=3D1 and b<6 limit 2;
 a | b | c | d
---+---+---+---
 1 | 3 | 1 | 2
 1 | 3 | 2 | 2

(2 rows)
{code}
fsecond page=EF=BC=9A
select * from test where a=3D1 and b<6 and (b,c) > (3,2) limit 2;
 a | b | c | d
---+---+---+---
 1 | 3 | 4 | 2
 1 | 3 | 5 | 2

(2 rows)
last page=EF=BC=9A
{code}
select * from test where a=3D1 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=EF=BC=9A
{code}
select * from test where a=3D1 and b<6 and (b,c) > (3,2) limit 2;
{code}
get one error message=EF=BC=9A

InvalidRequest: code=3D2200 [Invalid query] message=3D"Column "b" cannot ha=
ve both tuple-notation inequalities and single-column inequalities: (b, c) =
> (3, 2)"


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