-
Type:
Sub-task
-
Status: Resolved
-
Priority:
Normal
-
Resolution: Fixed
-
Fix Version/s: 3.4
-
Component/s: Legacy/CQL
-
Labels:None
-
Environment:
Tested from build CASSANDRA-11067
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