[ https://issues.apache.org/jira/browse/CASSANDRA-11134?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
DOAN DuyHai updated CASSANDRA-11134: ------------------------------------ Summary: [SASI Pre-QA] Index creation should respect IF NOT EXISTS (was: [SASI Pre-QA] Index creation should respect *IF NOT EXISTS*) > [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)