[jira] [Commented] (CASSANDRA-12878) Exception occurs caused by nested expression in where-clause

["Benjamin Lerer (JIRA)" <ji...@apache.org>]

    [ 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)