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

Allow quoted identifiers for triggers' names

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Low
    • Resolution: Fixed
    • 2.1.0, 2.1.1
    • None
    • None
    • 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

            mishail Mikhail Stepura
            mishail Mikhail Stepura
            Mikhail Stepura
            Sylvain Lebresne
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: