[jira] [Updated] (CASSANDRA-21046) Schema annotations escape validation on CREATE and ALTER DDL statements

["Sam Tunnicliffe (Jira)" <ji...@apache.org>]

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

Sam Tunnicliffe updated CASSANDRA-21046:
----------------------------------------
     Bug Category: Parent values: Correctness(12982)Level 1 values: Transient Incorrect Response(12987)
       Complexity: Normal
    Discovered By: User Report
    Fix Version/s: 6.x
         Severity: Normal
           Status: Open  (was: Triage Needed)

> Schema annotations escape validation on CREATE and ALTER DDL statements
> -----------------------------------------------------------------------
>
>                 Key: CASSANDRA-21046
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-21046
>             Project: Apache Cassandra
>          Issue Type: Bug
>          Components: Cluster/Schema
>            Reporter: Sam Tunnicliffe
>            Priority: Normal
>             Fix For: 6.x
>
>
> {{CREATE KEYSPACE}} & {{CREATE TABLE}} statements silently accept {{security_label}} and {{comment}} as options, but only {{CREATE TABLE ... WITH comment ...}} has any effect. The same applies to {{ALTER KEYSPACE/ALTER TABLE}}.
> {code}
> cqlsh> create KEYSPACE ks1 with replication = {'class': 'SimpleStrategy', 'replication_factor': 1} AND security_label = 'label1' AND comment = 'comment1';
> cqlsh> describe ks1;
> CREATE KEYSPACE ks1 WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'}  AND durable_writes = true  AND fast_path = 'simple';
> {code}
> Supplying an unsupported/unimplemented option to either a {{CREATE}} or {{ALTER}} statement should raise an error like:
> {code}
> cqlsh> alter table ks.t1 with blabla='foooo';
> SyntaxException: Unknown property 'blabla'
> {code}



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

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