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)
