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

inconsistent quoted identifier handling in UDTs

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • 2.2.4
    • Legacy/Tools
    • None
    • 2.2.1

    • Normal

    Description

      > create keyspace test with replication =

      {'class': 'SimpleStrategy', 'replication_factor': 1 }

      ;
      > create type if not exists mytype ("my.field" text);
      > desc keyspace; – observe that mytype is listed
      > create table mytable (pk int primary key, myfield frozen<mytype>);
      > desc keyspace; – observe that mytype is listed, but mytable is not.
      > select * from mytable;
      ValueError: Type names and field names can only contain alphanumeric characters and underscores: 'my.field'
      create table myothertable (pk int primary key, "my.field" text);
      select * from myothertable; – valid

      huh? It's valid to create a field of a table, or a field of a type, with a quoted name containing non-alpha chars, but it's not valid to use a such a type in a table? I can just about live with that though it seems unnecessarily restrictive, but allowing creation of such a table and then making it invisible/unusable definitely seems wrong.

      Attachments

        Issue Links

          Activity

            People

              samt Sam Tunnicliffe
              jhalliday Jonathan Halliday
              Sam Tunnicliffe
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: