cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joson Choo (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-12878) Exception occurs caused by nested expression in where-clause
Date Fri, 04 Nov 2016 09:48:58 GMT
Joson Choo created CASSANDRA-12878:
--------------------------------------

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

Mime
View raw message