[
https://issues.apache.org/jira/browse/CASSANDRA-11331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Philip Thompson updated CASSANDRA-11331:
----------------------------------------
Description:
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 t2_v2_idx_1 is a
duplicate of existing index t2_v2_idx"
{code}
The second {{CREATE INDEX IF NOT EXISTS}} should work fine.
was:
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 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.
> 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;
> 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 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)
