[
https://issues.apache.org/jira/browse/CASSANDRA-18322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700703#comment-17700703
]
Josh McKenzie commented on CASSANDRA-18322:
-------------------------------------------
Might be nice to still warn on it but update the warning to indicate why
preparing CREATE/DROP doesn't make sense.
bq. USE <keyspace> with prepared statements is considered to be an anti-pattern
due to ambiguity in non-qualified table names.
Could become something like:
bq. Prepared statements for CREATE/DROP keyspace or table commands is
indicative of programmatic keyspace/table creation or deletion and should be
avoided.
If we wanted to get really crazy we could start considering tying error
messages to documentation on why certain behavior was a bad idea. :D
> Warnings when using prepared statement with "drop/create keyspace .." ( after
> 15252)
> ------------------------------------------------------------------------------------
>
> Key: CASSANDRA-18322
> URL: https://issues.apache.org/jira/browse/CASSANDRA-18322
> Project: Cassandra
> Issue Type: Bug
> Components: Messaging/Client
> Reporter: Mohammad Aburadeh
> Priority: Urgent
>
> Hi,
> We get the following warnings when we use prepared statements with "create
> keyspace ... " or "drop keyspace" statements.
> "
> {{USE <keyspace>}} with prepared statements is considered to be an
> anti-pattern due to ambiguity in non-qualified table names. Please consider
> removing instances of {{{}Session#setKeyspace(<keyspace>){}}},
> {{Session#execute("USE <keyspace>")}} and {{cluster.newSession(<keyspace>)}}
> from your code, and always use fully qualified table names (e.g.
> <keyspace>.<table>). Keyspace used: null, statement keyspace: null, statement
> id: 8153d922390fdf9a9963bfeda85b2f3b at
> "
> Such statements are already full-qualified. So, why are we getting this
> warning?
> Regards
> Mohammad
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
