[jira] [Commented] (CASSANDRA-2903) Default behavior of generating index_name for columns might need to be improved.

["Boris Yen (JIRA)" <ji...@apache.org>]

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

Boris Yen commented on CASSANDRA-2903:
--------------------------------------

I have tested another case, not sure if this is a bug.

I created a few column families on 0.8.0 each has user_name column, in addition, I also enabled secondary index on this column.  Then, I upgraded to 0.8.1, when I used cassandra-cli: show keyspaces, I saw index name "user_name_idx" appears for different columns families. It seems the validation rule for index_name on 0.8.1 has been skipped completely.

> Default behavior of generating index_name for columns might need to be improved.
> --------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2903
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2903
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: API
>    Affects Versions: 0.8.1
>            Reporter: Boris Yen
>
> I have a few column families, each has a column called user_name. I tried to use secondary index on user_name column for each of the column family. However, when creating these column families, cassandra keeps reporting "Duplicate index name..." exception. I finally figured out that it seems the default index name is "column name"+"_idx", this make my column family violate the "uniqueness of index name" rule.
> I was wondering if the default index_name generating rule could be like "column name"+"cf name", so the index name would not collide with each other that easily, if the user do not assign "index_name" when creating a column family.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira