[jira] [Commented] (CASSANDRA-8365) CamelCase name is used as index name instead of lowercase

["Benjamin Lerer (JIRA)" <ji...@apache.org>]

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

Benjamin Lerer commented on CASSANDRA-8365:
-------------------------------------------

I had a look at the code. In 2.0 the index names are case sensitive and quoted names are not supported but the behavior is consistent between create and drop statement. I tested the example mentioned in the description and I was able to delete the index successfully.

If we change the code for 2.0 we might introduce some problems for the users with existing indices. They will suddently have to quote some of their index names to be able to drop them.

I would be in favor of letting 2.0 as such and fixing only 2.1+ where the behavior is really broken.

> CamelCase name is used as index name instead of lowercase
> ---------------------------------------------------------
>
>                 Key: CASSANDRA-8365
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8365
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Pierre Laporte
>            Assignee: Benjamin Lerer
>            Priority: Minor
>              Labels: cqlsh, docs
>             Fix For: 2.0.12, 2.1.3
>
>         Attachments: CASSANDRA-8365-V2.txt, CASSANDRA-8365.txt
>
>
> In cqlsh, when I execute a CREATE INDEX FooBar ... statement, the CamelCase name is used as index name, even though it is unquoted. Trying to quote the index name results in a syntax error.
> However, when I try to delete the index, I have to quote the index name, otherwise I get an invalid-query error telling me that the index (lowercase) does not exist.
> This seems inconsistent.  Shouldn't the index name be lowercased before the index is created ?
> Here is the code to reproduce the issue :
> {code}
> cqlsh:schemabuilderit> CREATE TABLE IndexTest (a int primary key, b int);
> cqlsh:schemabuilderit> CREATE INDEX FooBar on indextest (b);
> cqlsh:schemabuilderit> DESCRIBE TABLE indextest ;
> CREATE TABLE schemabuilderit.indextest (
>     a int PRIMARY KEY,
>     b int
> ) ........;
> CREATE INDEX FooBar ON schemabuilderit.indextest (b);
> cqlsh:schemabuilderit> DROP INDEX FooBar;
> code=2200 [Invalid query] message="Index 'foobar' could not be found in any of the tables of keyspace 'schemabuilderit'"
> {code}



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