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

ZhaoYang edited comment on CASSANDRA-13730 at 7/31/17 2:45 AM:
---------------------------------------------------------------

| [trunk|https://github.com/jasonstack/cassandra/commits/CASSANDRA-13730-trunk] 
| [unit|https://circleci.com/gh/jasonstack/cassandra/295] | |
| [3.11|https://github.com/jasonstack/cassandra/commits/CASSANDRA-13730-3.11] | 
[unit|https://circleci.com/gh/jasonstack/cassandra/296] | passed dtest |
| [3.0|https://github.com/jasonstack/cassandra/commits/CASSANDRA-13730-3.0] | 
[unit|https://circleci.com/gh/jasonstack/cassandra/287] | |
| [dtest|https://github.com/riptano/cassandra-dtest/commits/CASSANDRA-13730] | 

clear corresponding dropped_columns entries when table is dropped.


was (Author: jasonstack):
| [trunk|https://github.com/jasonstack/cassandra/commits/CASSANDRA-13730-trunk] 
| [unit|https://circleci.com/gh/jasonstack/cassandra/295] | |
| [3.11|https://github.com/jasonstack/cassandra/commits/CASSANDRA-13730-3.11] | 
[unit|https://circleci.com/gh/jasonstack/cassandra/296] | passed dtest |
| [3.0|https://github.com/jasonstack/cassandra/commits/CASSANDRA-13730-3.0] | 
[unit|https://circleci.com/gh/jasonstack/cassandra/287] | |
| [dtest|https://github.com/riptano/cassandra-dtest/commits/CASSANDRA-13730] \ 
| \ |

clear corresponding dropped_columns entries when table is dropped.

> Dropping a table doesn't drop its dropped columns
> -------------------------------------------------
>
>                 Key: CASSANDRA-13730
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-13730
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Duarte Nunes
>            Assignee: ZhaoYang
>             Fix For: 3.0.x, 3.11.x
>
>
> I'm not sure if this is intended or not, but currently a table's dropped 
> columns are not dropped when the table itself is dropped:
> {noformat}
> cqlsh> create keyspace ks WITH replication={ 'class' : 'SimpleStrategy', 
> 'replication_factor' : 1 } ;
> cqlsh> use ks;
> cqlsh:ks> create table  test (pk text primary key, c1 int);
> cqlsh:ks> alter table test drop c1;
> cqlsh:ks> drop table test;
> cqlsh:ks> select * from system_schema.dropped_columns where keyspace_name = 
> 'ks' and table_name = 'test';
>  keyspace_name | table_name | column_name | dropped_time                    | 
> kind    | type
> ---------------+------------+-------------+---------------------------------+---------+------
>             ks |       test |          c1 | 2017-07-25 17:53:47.651000+0000 | 
> regular |  int
> (1 rows)
> {noformat}
> This can have surprising consequences when creating another table with the 
> same name.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to