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

Allow quoted identifiers for triggers' names

Agile BoardAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment