[jira] [Created] (CASSANDRA-11134) [SASI Pre-QA] Index creation should respect *IF NOT EXISTS*

[DOAN DuyHai (JIRA)]

DOAN DuyHai created CASSANDRA-11134:
---------------------------------------

             Summary: [SASI Pre-QA] Index creation should respect *IF NOT 
EXISTS*
                 Key: CASSANDRA-11134
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11134
             Project: Cassandra
          Issue Type: Bug
          Components: CQL
         Environment: Tested from build 
[CASSANDRA-11067|https://issues.apache.org/jira/browse/CASSANDRA-11067]
            Reporter: DOAN DuyHai


Tested from build 
[CASSANDRA-11067|https://issues.apache.org/jira/browse/CASSANDRA-11067]

{code:sql}
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"

{code}

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





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)