Return-Path: <commits-return-184955-archive-asf-public=cust-asf.ponee.io@cassandra.apache.org>
X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io
Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io
Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183])
	by cust-asf2.ponee.io (Postfix) with ESMTP id 3DE9C200BC4
	for <archive-asf-public-internal@cust-asf2.ponee.io>; Fri,  4 Nov 2016 11:01:13 +0100 (CET)
Received: by cust-asf.ponee.io (Postfix)
	id 3CA25160AE8; Fri,  4 Nov 2016 10:01:13 +0000 (UTC)
Delivered-To: archive-asf-public@cust-asf.ponee.io
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by cust-asf.ponee.io (Postfix) with SMTP id B42FC160AE9
	for <archive-asf-public@cust-asf.ponee.io>; Fri,  4 Nov 2016 11:01:12 +0100 (CET)
Received: (qmail 61849 invoked by uid 500); 4 Nov 2016 10:01:11 -0000
Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:commits-help@cassandra.apache.org>
List-Unsubscribe: <mailto:commits-unsubscribe@cassandra.apache.org>
List-Post: <mailto:commits@cassandra.apache.org>
List-Id: <commits.cassandra.apache.org>
Reply-To: dev@cassandra.apache.org
Delivered-To: mailing list commits@cassandra.apache.org
Received: (qmail 61815 invoked by uid 99); 4 Nov 2016 10:01:11 -0000
Received: from arcas.apache.org (HELO arcas) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 04 Nov 2016 10:01:11 +0000
Received: from arcas.apache.org (localhost [127.0.0.1])
	by arcas (Postfix) with ESMTP id BED532C2A67
	for <commits@cassandra.apache.org>; Fri,  4 Nov 2016 10:01:11 +0000 (UTC)
Date: Fri, 4 Nov 2016 10:01:11 +0000 (UTC)
From: "Benjamin Lerer (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.13018005.1478252882000.186897.1478253671778@Atlassian.JIRA>
In-Reply-To: <JIRA.13018005.1478252882000@Atlassian.JIRA>
References: <JIRA.13018005.1478252882000@Atlassian.JIRA> <JIRA.13018005.1478252882556@arcas>
Subject: [jira] [Commented] (CASSANDRA-12878) Exception occurs caused by
 nested expression in where-clause
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
archived-at: Fri, 04 Nov 2016 10:01:13 -0000


    [ https://issues.apache.org/jira/browse/CASSANDRA-12878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15635864#comment-15635864 ] 

Benjamin Lerer commented on CASSANDRA-12878:
--------------------------------------------

{{OR}} and parenthesis are not supported in the {{WHERE}} clause.

> Exception occurs caused by nested expression in where-clause
> ------------------------------------------------------------
>
>                 Key: CASSANDRA-12878
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-12878
>             Project: Cassandra
>          Issue Type: Bug
>          Components: CQL
>         Environment: version: cassandra 3.7
> client: cqlsh
> os: debian 7
>            Reporter: Joson Choo
>              Labels: cql3
>             Fix For: 3.7
>
>
> I can't execute a composite expression as below in cqlsh.
> CQL:
> SELECT * FROM bbot_extract.item_basic_info 
> WHERE  PART_ID=19 AND ( ITEM_ID < 1901000 OR ITEM_ID >= 1909000) ;
> OUTPUT:
> SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query] message="line 1:85 mismatched input 'OR' expecting ')' (...AND ( ITEM_ID < 1901000 [OR] ITEM_ID...)">
> About the table:
> Primary key(PART_ID, ITEM_ID, PROPERTY)



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