Return-Path: X-Original-To: apmail-cassandra-commits-archive@www.apache.org Delivered-To: apmail-cassandra-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8DF5518AF3 for ; Fri, 31 Jul 2015 07:34:05 +0000 (UTC) Received: (qmail 72753 invoked by uid 500); 31 Jul 2015 07:34:05 -0000 Delivered-To: apmail-cassandra-commits-archive@cassandra.apache.org Received: (qmail 72715 invoked by uid 500); 31 Jul 2015 07:34:05 -0000 Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cassandra.apache.org Delivered-To: mailing list commits@cassandra.apache.org Received: (qmail 72702 invoked by uid 99); 31 Jul 2015 07:34:05 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 31 Jul 2015 07:34:05 +0000 Date: Fri, 31 Jul 2015 07:34:05 +0000 (UTC) From: "zhaoyan (JIRA)" To: commits@cassandra.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (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 X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CASSANDRA-9606?page=3Dcom.atlas= sian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D= 14648872#comment-14648872 ]=20 zhaoyan commented on CASSANDRA-9606: ------------------------------------ hello~ what's the Fix Version? > 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=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<6 > {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} > second page=EF=BC=9A > {code} > 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) > {code} > 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 = have both tuple-notation inequalities and single-column inequalities: (b, c= ) > (3, 2)" -- This message was sent by Atlassian JIRA (v6.3.4#6332)