You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Tyler Hobbs (JIRA)" <ji...@apache.org> on 2015/01/07 21:54:35 UTC
[jira] [Reopened] (CASSANDRA-8365) CamelCase name is used as index
name instead of lowercase
[ https://issues.apache.org/jira/browse/CASSANDRA-8365?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tyler Hobbs reopened CASSANDRA-8365:
------------------------------------
[~blerer] it looks like the tests are breaking in trunk due to the keyspace not being handled properly: http://cassci.datastax.com/job/trunk_utest/1267/testReport/junit/org.apache.cassandra.cql3/CreateIndexStatementTest/. I took a look to see if it would be a quick fix, but it doesn't appear to be, so I've reopened this.
> 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.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)