cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-6037) Parens around WHERE condition break query
Date Fri, 20 Sep 2013 12:39:55 GMT

     [ 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

Mime
View raw message