[
https://issues.apache.org/jira/browse/CASSANDRA-20268?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17927648#comment-17927648
]
Stefan Miklosovic commented on CASSANDRA-20268:
-----------------------------------------------
This already works as expected:
{code}
CREATE TABLE ks.patients (
id timeuuid PRIMARY KEY,
name text MASKED WITH system.mask_default() CHECK NOT_NULL(name) AND
LENGTH(name) > 1
)
{code}
What does not seem to work is when we ALTER a column:
{code}
cassandra@cqlsh> ALTER TABLE ks.patients ALTER name MASKED WITH
system.mask_default() CHECK NOT_NULL(name) AND LENGTH(name) > 1;
SyntaxException: line 1:69 mismatched input 'CHECK' expecting EOF (...MASKED
WITH system.mask_default() [CHECK]...)
cassandra@cqlsh> ALTER TABLE ks.patients ALTER name MASKED WITH mask_default()
CHECK NOT_NULL(name) AND LENGTH(name) > 1;
SyntaxException: line 1:62 mismatched input 'CHECK' expecting EOF (...name
MASKED WITH mask_default() [CHECK]...)
ALTER TABLE ks.patients ALTER name MASKED WITH mask_default() AND CHECK
NOT_NULL(name) AND LENGTH(name) > 1;
SyntaxException: line 1:62 mismatched input 'AND' expecting EOF (...name MASKED
WITH mask_default() [AND]...)
{code}
Altering that column individually works. I would focus on why the combination
of it does not work.
> Add constraints support to be used with MASKED statements
> ---------------------------------------------------------
>
> Key: CASSANDRA-20268
> URL: https://issues.apache.org/jira/browse/CASSANDRA-20268
> Project: Apache Cassandra
> Issue Type: Improvement
> Components: Feature/Constraints
> Reporter: Bernardo Botella Corbi
> Priority: Normal
>
> Currently, constraints CHECK keyword and MASKED keyword can't go together. We
> need to find a way of supporting both at the same time.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
