[jira] [Commented] (CASSANDRA-6276) CQL: Map can not be created with the same name as a previously dropped list

["Mahafuzur Rahman (JIRA)" <ji...@apache.org>]

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

Mahafuzur Rahman commented on CASSANDRA-6276:
---------------------------------------------

Facing the same problem in cassandra v3.7. Btw, it works when you drop the column, recreate a non collection column such as int with the same name and then drop that again. After that you can add the same name column with a different collection type and cassandra allows the operation. Dirty workaround though!

> CQL: Map can not be created with the same name as a previously dropped list
> ---------------------------------------------------------------------------
>
>                 Key: CASSANDRA-6276
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6276
>             Project: Cassandra
>          Issue Type: Bug
>         Environment:  Cassandra 2.0.2 | CQL spec 3.1.0
> centos 64 bit
> Java(TM) SE Runtime Environment (build 1.7.0-b147)
>            Reporter: Oli Schacher
>            Assignee: Benjamin Lerer
>            Priority: Minor
>              Labels: cql
>             Fix For: 2.0.10
>
>         Attachments: 6272-2.0.txt, CASSANDRA-6276-V2.txt, CASSANDRA-6276.txt
>
>
> If create a list, drop it and create a map with the same name, i get "Bad Request: comparators do not match or are not compatible."
> {quote}
> cqlsh:os_test1> create table thetable(id timeuuid primary key, somevalue text);
> cqlsh:os_test1> alter table thetable add mycollection list<text>;  
> cqlsh:os_test1> alter table thetable drop mycollection;
> cqlsh:os_test1> alter table thetable add mycollection map<text,text>;  
> Bad Request: comparators do not match or are not compatible.
> {quote}



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