[
https://issues.apache.org/jira/browse/CASSANDRA-12878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15635864#comment-15635864
]
Benjamin Lerer commented on CASSANDRA-12878:
--------------------------------------------
{{OR}} and parenthesis are not supported in the {{WHERE}} clause.
> Exception occurs caused by nested expression in where-clause
> ------------------------------------------------------------
>
> Key: CASSANDRA-12878
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12878
> Project: Cassandra
> Issue Type: Bug
> Components: CQL
> Environment: version: cassandra 3.7
> client: cqlsh
> os: debian 7
> Reporter: Joson Choo
> Labels: cql3
> Fix For: 3.7
>
>
> I can't execute a composite expression as below in cqlsh.
> CQL:
> SELECT * FROM bbot_extract.item_basic_info
> WHERE PART_ID=19 AND ( ITEM_ID < 1901000 OR ITEM_ID >= 1909000) ;
> OUTPUT:
> SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query]
> message="line 1:85 mismatched input 'OR' expecting ')' (...AND ( ITEM_ID <
> 1901000 [OR] ITEM_ID...)">
> About the table:
> Primary key(PART_ID, ITEM_ID, PROPERTY)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
