[ 
https://issues.apache.org/jira/browse/CASSANDRA-19556?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Yuqi Yan updated CASSANDRA-19556:
---------------------------------
    Description: 
Sometimes we want to block DDL/DCL queries to stop new schemas being created or 
roles created. (e.g. when doing live-upgrade)

For DDL guardrail current implementation won't block the query if it's no-op 
(e.g. CREATE TABLE...IF NOT EXISTS, but table already exists, etc. The 
guardrail check is added in apply() right after all the existence check)

I don't have preference on either block every DDL query or check whether if 
it's no-op here. Just we have some users always run CREATE..IF NOT EXISTS.. at 
startup, which is no-op but will be blocked by this guardrail and failed to 
start.

 

4.1 PR: [https://github.com/apache/cassandra/pull/3248]

 

  was:
Sometimes we want to block DDL/DCL queries to stop new schemas being created. 
(e.g. when doing live-upgrade)

For DDL guardrail current implementation won't block the query if it's no-op 
(e.g. CREATE TABLE...IF NOT EXISTS, but table already exists, etc. The 
guardrail check is added in apply() right after all the existence check)

I don't have preference on either block every DDL query or check whether if 
it's no-op here. Just we have some users always run CREATE..IF NOT EXISTS.. at 
startup, which is no-op but will be blocked by this guardrail and failed to 
start.

 

4.1 PR: [https://github.com/apache/cassandra/pull/3248]

 


> Guardrail to block DDL/DCL queries
> ----------------------------------
>
>                 Key: CASSANDRA-19556
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-19556
>             Project: Cassandra
>          Issue Type: New Feature
>          Components: Feature/Guardrails
>            Reporter: Yuqi Yan
>            Assignee: Yuqi Yan
>            Priority: Normal
>
> Sometimes we want to block DDL/DCL queries to stop new schemas being created 
> or roles created. (e.g. when doing live-upgrade)
> For DDL guardrail current implementation won't block the query if it's no-op 
> (e.g. CREATE TABLE...IF NOT EXISTS, but table already exists, etc. The 
> guardrail check is added in apply() right after all the existence check)
> I don't have preference on either block every DDL query or check whether if 
> it's no-op here. Just we have some users always run CREATE..IF NOT EXISTS.. 
> at startup, which is no-op but will be blocked by this guardrail and failed 
> to start.
>  
> 4.1 PR: [https://github.com/apache/cassandra/pull/3248]
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org

Reply via email to