You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Dave Brosius (JIRA)" <ji...@apache.org> on 2013/09/20 07:30:52 UTC

[jira] [Assigned] (CASSANDRA-6037) Parens around WHERE condition break query

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

Dave Brosius reassigned CASSANDRA-6037:
---------------------------------------

    Assignee: Dave Brosius
    
> 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
>         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