cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Philip Thompson (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-11331) Create Index IF NOT EXISTS not working on trunk
Date Wed, 09 Mar 2016 20:20:40 GMT
Philip Thompson created CASSANDRA-11331:
-------------------------------------------

             Summary: Create Index IF NOT EXISTS not working on trunk
                 Key: CASSANDRA-11331
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11331
             Project: Cassandra
          Issue Type: Bug
          Components: CQL
            Reporter: Philip Thompson
             Fix For: 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;
CREATE TABLE k.t (
    id int PRIMARY KEY,
    v int,
    v2 int,
    v3 text
)
CREATE INDEX IF NOT EXISTS ON t2 (v2);
CREATE INDEX IF NOT EXISTS ON t2 (v2);
InvalidRequest: code=2200 [Invalid query] message="Index t2_v2_idx_1 is a duplicate of existing
index t2_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