[CASSANDRA-8365] CamelCase name is used as index name instead of lowercase

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.1.3
• Component/s: Legacy/CQL
• Labels: cqlsh docs
• Severity: Low
• Assignee: Benjamin Lerer
• Reporter: Pierre Laporte

Authors

Benjamin Lerer

Reviewers

Tom Hobbs

• Created: 21/Nov/14 22:40
• Updated: 16/Apr/19 09:31
• Resolved: 08/Jan/15 17:28

Description

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 :

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'"

Issue Links

• is duplicated by: CASSANDRA-8393 support quoted identifiers for index names