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)
