[CASSANDRA-11134] [SASI Pre-QA] Index creation should respect IF NOT EXISTS

• Type: Sub-task
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.4
• Component/s: Legacy/CQL

Environment

Tested from build CASSANDRA-11067

• Assignee: Pavel Yaskevich
• Reporter: DuyHai Doan

Authors

Pavel Yaskevich

Reviewers

Sam Tunnicliffe

• Created: 07/Feb/16 13:11
• Updated: 16/Apr/19 09:30
• Resolved: 10/Feb/16 19:42

Description

Tested from build CASSANDRA-11067

CREATE KEYSPACE music WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'}  AND durable_writes = true;

CREATE TABLE music.albums (
    id int PRIMARY KEY,
    country text,
    title text
);

CREATE CUSTOM INDEX IF NOT EXISTS ON albums (country) USING 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = {'mode':'PREFIX'};

CREATE CUSTOM INDEX IF NOT EXISTS ON albums (country) USING 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = {'mode':'PREFIX'};

InvalidRequest: code=2200 [Invalid query] message="Index albums_country_idx_1 is a duplicate of existing index albums_country_idx"

The index creation should respect IF NOT EXISTS semantics and not create a duplicate index if there is already one index on the same column