[jira] [Commented] (CASSANDRA-7683) Always allow CREATE TABLE IF NOT EXISTS if it exists

["Robert Stupp (JIRA)" <ji...@apache.org>]

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

Robert Stupp commented on CASSANDRA-7683:
-----------------------------------------

[~ztyx] which C* are you using? Can you post a complete command sequence - e.g. from cqlsh ?


> Always allow CREATE TABLE IF NOT EXISTS if it exists
> ----------------------------------------------------
>
>                 Key: CASSANDRA-7683
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-7683
>             Project: Cassandra
>          Issue Type: Wish
>          Components: Core
>            Reporter: Jens Rantil
>            Priority: Minor
>
> Background: I have a table that I'd like to make sure exists when I boot up my application. To make the life easier for our developers I execute an `ALTER TABLE IF EXISTS`.
> In production I am using user based authorization and for security reasons regular production users are not allowed to CREATE TABLEs.
> Problem: When a user without CREATE permission executes `ALTER TABLE IF EXISTS` for a table that already exists, the command fails telling me the user is not allowed to execute `CREATE TABLE`. It feels kinda ridiculous that this fails when I'm not actually creating the table.
> Proposal: That the permission check only should be done if the table is only actually to be created. 
> Workaround: Right now, I have a boolean that checks if in production and in that case don't try to create the table. Another approach would be to manually check if the table exists.



--
This message was sent by Atlassian JIRA
(v6.2#6252)