[
https://issues.apache.org/jira/browse/CASSANDRA-20271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17927643#comment-17927643
]
Stefan Miklosovic commented on CASSANDRA-20271:
-----------------------------------------------
I do not think this is a valid ticket because system tables are not modifiable
already.
{code}
cassandra@cqlsh> alter table system_auth.roles alter role CHECK NOT_NULL(role);
Unauthorized: Error from server: code=2100 [Unauthorized] message="Cannot ALTER
<table system_auth.roles>"
{code}
{code}
cassandra@cqlsh> alter table system.local ALTER bootstrapped check
NOT_NULL(bootstrapped);
Unauthorized: Error from server: code=2100 [Unauthorized] message="system
keyspace is not user-modifiable."
{code}
I would resolve this ticket as invalid cc [~bernardo.botella].
> Disallow constraints on system tables
> -------------------------------------
>
> Key: CASSANDRA-20271
> URL: https://issues.apache.org/jira/browse/CASSANDRA-20271
> Project: Apache Cassandra
> Issue Type: Improvement
> Components: Feature/Constraints
> Reporter: Bernardo Botella Corbi
> Priority: Normal
>
> System tables should not be allowed to have constraints. Even if they are
> protected by admin only access, we should make sure that a system table
> doesn't have a constraint on it that may impact how Cassandra operates.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
