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