[CASSANDRA-12878] Exception occurs caused by nested expression in where-clause

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Invalid
• Fix Version/s: 3.7
• Component/s: Legacy/CQL
• Labels: cql3

Environment

version: cassandra 3.7
client: cqlsh
os: debian 7

• Severity: Normal
• Since Version: 3.7
• Assignee: Unassigned
• Reporter: Joson Choo
• Created: 04/Nov/16 09:48
• Updated: 16/Apr/19 09:30
• Resolved: 04/Nov/16 10:01

Description

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)