Return-Path: 
 <commits-return-81521-apmail-cassandra-commits-archive=cassandra.apache.org@cassandra.apache.org>
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 9ABBF1063D
	for <apmail-cassandra-commits-archive@www.apache.org>;
 Fri, 20 Sep 2013 12:39:58 +0000 (UTC)
Received: (qmail 26724 invoked by uid 500); 20 Sep 2013 12:39:58 -0000
Delivered-To: apmail-cassandra-commits-archive@cassandra.apache.org
Received: (qmail 26705 invoked by uid 500); 20 Sep 2013 12:39:58 -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 26141 invoked by uid 99); 20 Sep 2013 12:39:55 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Sep 2013 12:39:55 +0000
Date: Fri, 20 Sep 2013 12:39:55 +0000 (UTC)
From: "Jonathan Ellis (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12668957.1379403178876.167730.1379680795107@arcas>
In-Reply-To: <JIRA.12668957.1379403178876@arcas>
References: <JIRA.12668957.1379403178876@arcas>
Subject: [jira] [Updated] (CASSANDRA-6037) Parens around WHERE condition
 break query
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394


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

Jonathan Ellis updated CASSANDRA-6037:
--------------------------------------

    Reviewer: slebresne
    
> Parens around WHERE condition break query
> -----------------------------------------
>
>                 Key: CASSANDRA-6037
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6037
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: cqlsh, pdo_cassandra
>            Reporter: Sergey Nagaytsev
>            Assignee: Dave Brosius
>            Priority: Minor
>              Labels: cql3
>             Fix For: 1.2.11
>
>         Attachments: 6037.txt
>
>
> SELECT * FROM user WHERE (key=<UUID>);
> Bad Request: line 1:25 no viable alternative at input '('
> SELECT * FROM user WHERE key=<UUID>; -- No parens
> -- Normal output
> The example provided is minimal, bug was discovered with AND logic on indexed columns.
> Parens-enclosed conditions is good SQL and so is produced by database abstraction layers in complex queries to avoid operation precedence problems.
> Fixing this at application side is no option - this will open the can of logic bugs.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira