[ https://issues.apache.org/jira/browse/CASSANDRA-11331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sam Tunnicliffe updated CASSANDRA-11331: ---------------------------------------- Reproduced In: 3.4, 3.0.4 (was: 3.0.4, 3.4) Status: Patch Available (was: Open) Pushed a branch in which the {{IF NOT EXISTS}} clause is applied to a duplicate-in-all-but-name. It merges cleanly to 3.5 and trunk, where the relevant unit tests also pass, so I didn't trigger additional CI on those branches. ||branch||testall||dtest|| |[11331-3.0|https://github.com/beobal/cassandra/tree/11331-3.0]|[testall|http://cassci.datastax.com/view/Dev/view/beobal/job/beobal-11331-3.0-testall]|[dtest|http://cassci.datastax.com/view/Dev/view/beobal/job/beobal-11331-3.0-dtest]| > Create Index IF NOT EXISTS throws error when index already exists > ----------------------------------------------------------------- > > Key: CASSANDRA-11331 > URL: https://issues.apache.org/jira/browse/CASSANDRA-11331 > Project: Cassandra > Issue Type: Bug > Components: CQL > Reporter: Philip Thompson > Assignee: Sam Tunnicliffe > Fix For: 3.0.x, 3.x > > > While testing with trunk, I see that issuing the following queries throws an > InvalidRequest, despite being valid. > {code} > 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" > {code} > The second {{CREATE INDEX IF NOT EXISTS}} should work fine. -- This message was sent by Atlassian JIRA (v6.3.4#6332)