Details
-
Bug
-
Status: Resolved
-
Normal
-
Resolution: Fixed
-
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
- relates to
-
CASSANDRA-10607 Using reserved keyword for Type field crashes cqlsh
- Resolved