cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aleksey Yeschenko (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-8850) clean up options syntax for create/alter role
Date Wed, 04 Mar 2015 01:06:04 GMT

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

Aleksey Yeschenko commented on CASSANDRA-8850:
----------------------------------------------

I've been thinking about it a bit. If we don't care too much about emulating Postgres syntactically,
can we go with a more consistent (wrt the rest of C* CQL statements) option?

Instead of
{noformat}
CREATE ROLE mike WITH PASSWORD '12345' AND NOSUPERUSER AND LOGIN
{noformat}
have
{noformat}
CREATE ROLE mike WITH PASSWORD = '12345' AND SUPERUSER = false AND LOGIN = true
{noformat}

Instead of
{noformat}
ALTER ROLE mike WITH NOSUPERUSER AND NOLOGIN
{noformat}
have
{noformat}
ALTER ROLE mike WITH SUPERUSER = false AND LOGIN = false
{noformat}

It also extends nicely to OPTIONS, too. What do you think?

> clean up options syntax for create/alter role 
> ----------------------------------------------
>
>                 Key: CASSANDRA-8850
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8850
>             Project: Cassandra
>          Issue Type: Improvement
>            Reporter: Sam Tunnicliffe
>            Assignee: Sam Tunnicliffe
>            Priority: Minor
>             Fix For: 3.0
>
>         Attachments: 8850-v2.txt, 8850.txt
>
>
> {{CREATE/ALTER ROLE}} syntax would be improved by using {{WITH}} and {{AND}} in a way
more consistent with other statements.
> e.g. {{CREATE ROLE foo WITH LOGIN AND SUPERUSER AND PASSWORD 'password'}}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message