[CASSANDRA-18322] Warn about unqualified prepared statement only if it is a select, update, delete, insert

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 5.1
• Component/s: Messaging/Client
• Complexity: Normal
• Platform: All

Source Control Link

https://github.com/apache/cassandra/commit/08b2e80aabd2b56e69fb6708dd1e579ede760ded

Test and Documentation Plan

CI and manual cassandra-stress execution

• Assignee: Stefan Miklosovic
• Reporter: Mohammad Aburadeh

Authors

Stefan Miklosovic

Reviewers

Benjamin Lerer

• Created: 12/Mar/23 10:06
• Updated: 22/Aug/24 11:23
• Resolved: 08/Aug/24 12:41

Description

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

Issue Links

• is duplicated by: CASSANDRA-18495 Warnings when using the perl driver to connect to Cassandra
• links to: GitHub Pull Request #2668
• links to: GitHub Pull Request #2669
• links to: GitHub Pull Request #2670