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

Allow quoted identifiers for triggers' names

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Low
    • Resolution: Fixed
    • Fix Version/s: 2.1.0, 2.1.1
    • Component/s: None
    • Labels:
      None
    • Severity:
      Low

      Description

      Current implementation doesn't allow quoted/case sensitive identifiers for triggers' names, and doesn't handle those names in case-insensitive manner either.

      mstepura-mac:cassandra mikhail$ bin/cqlsh
      Connected to Test Cluster at 127.0.0.1:9042.
      [cqlsh 5.0.1 | Cassandra 2.1.1-SNAPSHOT | CQL spec 3.2.0 | Native protocol v3]
      Use HELP for help.
      cqlsh> use stress;
      cqlsh:stress> create TRIGGER "ZooZoo" ON t1 USING  'org.apache.cassandra.triggers.InvertedIndex';
      <ErrorMessage code=2000 [Syntax error in CQL query] message="line 1:15 mismatched input 'ZooZoo' expecting IDENT (create TRIGGER ["ZooZo]o" ON...)">
      cqlsh:stress>
      cqlsh:stress>
      cqlsh:stress> create TRIGGER ZooZoo ON t1 USING  'org.apache.cassandra.triggers.InvertedIndex';
      cqlsh:stress>
      cqlsh:stress>
      cqlsh:stress> drop TRIGGER zoozoo ON stress.t1 ;
      code=2200 [Invalid query] message="Trigger zoozoo was not found"
      cqlsh:stress>
      cqlsh:stress>
      cqlsh:stress> drop TRIGGER "ZooZoo" ON stress.t1 ;
      <ErrorMessage code=2000 [Syntax error in CQL query] message="line 1:13 mismatched input 'ZooZoo' expecting IDENT (drop TRIGGER ["ZooZo]o" ON...)">
      cqlsh:stress>
      cqlsh:stress>
      cqlsh:stress> drop TRIGGER ZooZoo ON stress.t1 ;
      

        Attachments

        1. CASSANDRA-2.1-7847.patch
          3 kB
          Mikhail Stepura

          Activity

            People

            • Assignee:
              mishail Mikhail Stepura
              Reporter:
              mishail Mikhail Stepura
              Authors:
              Mikhail Stepura
              Reviewers:
              Sylvain Lebresne
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: