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

["Sergey Nagaytsev (JIRA)" <ji...@apache.org>]

Sergey Nagaytsev created CASSANDRA-6037:
-------------------------------------------

             Summary: 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


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