cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sam Tunnicliffe (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-11331) Create Index IF NOT EXISTS throws error when index already exists
Date Thu, 31 Mar 2016 14:49:25 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-11331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Sam Tunnicliffe updated CASSANDRA-11331:
----------------------------------------
       Resolution: Fixed
    Fix Version/s:     (was: 3.0.x)
                       (was: 3.x)
                   3.5
                   3.0.5
    Reproduced In: 3.4, 3.0.4  (was: 3.0.4, 3.4)
           Status: Resolved  (was: Ready to Commit)

Thanks, committed to 3.0 in {{be3808140207d2ab783ef907639c2ad544b6683f}}

> 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.5, 3.5
>
>
> 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)

Mime
View raw message