[CASSANDRA-11331] Create Index IF NOT EXISTS throws error when index already exists

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.0.5, 3.5
• Component/s: Legacy/CQL
• Severity: Normal
• Assignee: Sam Tunnicliffe
• Reporter: Philip Thompson

Authors

Sam Tunnicliffe

Reviewers

Benjamin Lerer

• Created: 09/Mar/16 20:20
• Updated: 16/Apr/19 09:30
• Resolved: 31/Mar/16 14:48

Description

While testing with trunk, I see that issuing the following queries throws an InvalidRequest, despite being valid.

CREATE KEYSPACE k WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'}  AND durable_writes = true;
USE k;
CREATE TABLE k.t (
    id int PRIMARY KEY,
    v int,
    v2 int,
    v3 text
);
CREATE INDEX IF NOT EXISTS ON t (v2);
CREATE INDEX IF NOT EXISTS ON t (v2);
InvalidRequest: code=2200 [Invalid query] message="Index t_v2_idx_1 is a duplicate of existing index t_v2_idx"

The second CREATE INDEX IF NOT EXISTS should work fine.