[CASSANDRA-14706] Support "IF EXISTS/IF NOT EXISTS" for all clauses of "ALTER TABLE"

• Type: New Feature
• Status: Resolved
• Priority: Low
• Resolution: Duplicate
• Component/s: CQL/Interpreter, CQL/Syntax, Legacy/CQL
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Dmitry Lazurkin
• Created: 08/Sep/18 12:15
• Updated: 16/Mar/22 11:57
• Resolved: 08/Oct/21 09:55

Description

Like so:

ALTER TABLE <table> ALTER <column> TYPE <newtype>;
ALTER TABLE [ IF EXISTS ] <table> ADD [ IF NOT EXISTS ] <coumn> <newtype>;
ALTER TABLE [ IF EXISTS ] <table> ADD [ IF NOT EXISTS ] (<column> <newtype>,<column1> <newtype1>..... <column n> <newtype n>);
ALTER TABLE [ IF EXISTS ] <table> DROP [ IF EXISTS ] <column>;
ALTER TABLE [ IF EXISTS ] <table> DROP [ IF EXISTS ] ( <column>,<column1>.....<column n>);
ALTER TABLE [ IF EXISTS ] <table> RENAME [ IF EXISTS ] <column> TO <column>;
ALTER TABLE [ IF EXISTS ] <table> WITH <property> = <value>;

I think common IF EXISTS/IF NOT EXISTS clause for ADD/DROP/RENAME better than clause for each column.

Issue Links

• duplicates: CASSANDRA-16916 Add support for IF EXISTS and IF NOT EXISTS in ALTER statements
• supercedes: CASSANDRA-11147 support alter table add if not exists
• supercedes: CASSANDRA-8492 Support "IF NOT EXISTS" for "ALTER TABLE ADD COLUMN"
• links to: GitHub Pull Request #263