[jira] [Comment Edited] (CASSANDRA-8197) Decide whether to allow case-insensitive system keyspace names

["Robert Stupp (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-8197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14186609#comment-14186609 ] 

Robert Stupp edited comment on CASSANDRA-8197 at 10/28/14 9:03 AM:
-------------------------------------------------------------------

{code}
cqlsh> drop KEYSPACE "SYSTEM_tRaCeS";
code=2100 [Unauthorized] message="Cannot DROP <keyspace SYSTEM_tRaCeS>"
cqlsh> drop KEYSPACE "SYSTEM_aUtH";
code=2100 [Unauthorized] message="Cannot DROP <keyspace SYSTEM_aUtH>"
{code}

at least it's partly case insensitive :)


was (Author: snazy):
{code}
cqlsh> drop KEYSPACE "SYSTEM_tRaCeS";
code=2100 [Unauthorized] message="Cannot DROP <keyspace SYSTEM_tRaCeS>"
{code}

at least it's partly case insensitive :)

> Decide whether to allow case-insensitive system keyspace names
> --------------------------------------------------------------
>
>                 Key: CASSANDRA-8197
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8197
>             Project: Cassandra
>          Issue Type: Task
>            Reporter: Robert Stupp
>            Priority: Minor
>
> The current implementation does not allow to create a keyspace like {{sYsTeM}} or other case-variations of "system".
> But it allows that for the two other system keyspaces {{system_trace}} and {{system_auth}}.
> IMO we should make that consistent at least for the system keyspaces.
> {code}
> cqlsh> create KEYSPACE "SyStEM" WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};
> code=2200 [Invalid query] message="system keyspace is not user-modifiable"
> cqlsh> create KEYSPACE "SYSTEM_tRaCeS" WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};
> cqlsh> create KEYSPACE "SYSTEM_aUtH" WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};
> cqlsh> DESC KEYSPACES ;
> "SYSTEM_aUtH"  system  "SYSTEM_tRaCeS"  system_traces
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)