I have upgraded my system from cassandra 2.1.16 to 3.11.2. We had some tables with COMPACT STORAGE enabled. We see some weird behaviour of cassandra while adding a column into it.
Cassandra does not give any error while altering however the added column is invisible.
Same behaviour when we create a new table with compact storage and try to alter it. Below is the commands ran in sequence:
Now altering the table by adding a new column:
notice that above desc table result does not have newly added column profile. However when i try to add it again it gives column already exist;
Inserting also behaves strange: