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

Jogesh Anand commented on CASSANDRA-16916:
------------------------------------------

[~blerer] / @ mentors - thanks for your patience. I modified some alter 
statements as mentioned in the Jira above. Please have an initial look when you 
get some time. Here's [CI 
link|https://app.circleci.com/pipelines/github/djanand/cassandra?branch=CASSANDRA-16916]
 (currently running). I have had issues with test cases that run fine locally 
but the CircleCI breaks. I'll keep an eye out.  Can you please help with the 
below:-
 * Would it be helpful to have IF EXISTS on ALTER TABLE %s RENAME statements?
 * ALTER ROLE,  ALTER MATERIALIZED VIEW, and ALTER USER is WIP and will be 
sharing those changes in a couple of days.
 * I'm not sure how I could join #cassandra-dev slack channel. I don't have an 
@apache.org email, so if someone sends an invite my way that would be pretty 
helpful.

> Add support for IF EXISTS and IF NOT EXISTS in ALTER statements
> ---------------------------------------------------------------
>
>                 Key: CASSANDRA-16916
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-16916
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: CQL/Syntax
>            Reporter: Benjamin Lerer
>            Assignee: Jogesh Anand
>            Priority: Normal
>
> It would make sense to add support for {{IF EXISTS}} and {{IF NOT EXISTS}} in 
> the different {{ALTER}} statements. 
> For example:
> * {{ALTER TABLE IF EXISTS myTable ...}}
> * {{ALTER TABLE myTable ADD IF NOT EXISTS ...}}
> * {{ALTER TABLE myTable DROP IF EXISTS ...}}
> * {{ALTER TYPE IF EXISTS myType ...}}
> * {{ALTER TYPE myType ADD IF NOT EXISTS ...}}
> +Additional info for newcomers:+
> In order to implement this change you will need to change the {{Parser.g}} 
> ANTLR file located in the src/antlr directory and the java classes 
> corresponding to the different alter statements located in the 
> {{org.apache.cassandra.cql3.statements.schema}} package. You can look at the 
> CreateTableStatement class to see how it was done there.
> The unit test for the CQL logic are located under 
> {{org.apache.cassandra.cql3.validation}}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

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

Reply via email to