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

["Pierre Laporte (JIRA)" <ji...@apache.org>]

Pierre Laporte created CASSANDRA-8365:
-----------------------------------------

             Summary: 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
            Priority: Minor


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)