[CASSANDRA-13730] Dropping a table doesn't drop its dropped columns

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 3.0.15, 3.11.1
• Component/s: Legacy/Distributed Metadata
• Severity: Low
• Assignee: Zhao Yang
• Reporter: Duarte Nunes

Authors

Zhao Yang

Reviewers

Aleksey Yeschenko

• Created: 25/Jul/17 18:05
• Updated: 16/Apr/19 09:30
• Resolved: 03/Aug/17 13:43

Description

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:

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)

This can have surprising consequences when creating another table with the same name.