Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-12878

Exception occurs caused by nested expression in where-clause

    XMLWordPrintableJSON

    Details

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

      version: cassandra 3.7
      client: cqlsh
      os: debian 7

    • Severity:
      Normal
    • Since Version:
      3.7

      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)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              JosonProg Joson Choo
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: