[jira] [Updated] (CASSANDRA-11134) [SASI Pre-QA] Index creation should respect IF NOT EXISTS

2016-02-08 Thread Pavel Yaskevich (JIRA)

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

Pavel Yaskevich updated CASSANDRA-11134:

Issue Type: Sub-task  (was: Bug)
Parent: CASSANDRA-11136

> [SASI Pre-QA] Index creation should respect IF NOT EXISTS
> -
>
> Key: CASSANDRA-11134
> URL: https://issues.apache.org/jira/browse/CASSANDRA-11134
> Project: Cassandra
>  Issue Type: Sub-task
>  Components: CQL
> Environment: Tested from build 
> [CASSANDRA-11067|https://issues.apache.org/jira/browse/CASSANDRA-11067]
>Reporter: DOAN DuyHai
>Assignee: Pavel Yaskevich
> Fix For: 3.4
>
>
> Tested from build 
> [CASSANDRA-11067|https://issues.apache.org/jira/browse/CASSANDRA-11067]
> {code:sql}
> CREATE KEYSPACE music WITH replication = {'class': 'SimpleStrategy', 
> 'replication_factor': '1'}  AND durable_writes = true;
> CREATE TABLE music.albums (
> id int PRIMARY KEY,
> country text,
> title text
> );
> CREATE CUSTOM INDEX IF NOT EXISTS ON albums (country) USING 
> 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = {'mode':'PREFIX'};
> CREATE CUSTOM INDEX IF NOT EXISTS ON albums (country) USING 
> 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = {'mode':'PREFIX'};
> InvalidRequest: code=2200 [Invalid query] message="Index albums_country_idx_1 
> is a duplicate of existing index albums_country_idx"
> {code}
> The index creation should respect *IF NOT EXISTS* semantics and not create a 
> duplicate index if there is already one index on the same column



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (CASSANDRA-11134) [SASI Pre-QA] Index creation should respect IF NOT EXISTS

2016-02-07 Thread DOAN DuyHai (JIRA)

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

DOAN DuyHai updated CASSANDRA-11134:

Summary: [SASI Pre-QA] Index creation should respect IF NOT EXISTS  (was: 
[SASI Pre-QA] Index creation should respect *IF NOT EXISTS*)

> [SASI Pre-QA] Index creation should respect IF NOT EXISTS
> -
>
> Key: CASSANDRA-11134
> URL: https://issues.apache.org/jira/browse/CASSANDRA-11134
> Project: Cassandra
>  Issue Type: Bug
>  Components: CQL
> Environment: Tested from build 
> [CASSANDRA-11067|https://issues.apache.org/jira/browse/CASSANDRA-11067]
>Reporter: DOAN DuyHai
>
> Tested from build 
> [CASSANDRA-11067|https://issues.apache.org/jira/browse/CASSANDRA-11067]
> {code:sql}
> CREATE KEYSPACE music WITH replication = {'class': 'SimpleStrategy', 
> 'replication_factor': '1'}  AND durable_writes = true;
> CREATE TABLE music.albums (
> id int PRIMARY KEY,
> country text,
> title text
> );
> CREATE CUSTOM INDEX IF NOT EXISTS ON albums (country) USING 
> 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = {'mode':'PREFIX'};
> CREATE CUSTOM INDEX IF NOT EXISTS ON albums (country) USING 
> 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = {'mode':'PREFIX'};
> InvalidRequest: code=2200 [Invalid query] message="Index albums_country_idx_1 
> is a duplicate of existing index albums_country_idx"
> {code}
> The index creation should respect *IF NOT EXISTS* semantics and not create a 
> duplicate index if there is already one index on the same column



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (CASSANDRA-11134) [SASI Pre-QA] Index creation should respect IF NOT EXISTS

2016-02-07 Thread Pavel Yaskevich (JIRA)

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

Pavel Yaskevich updated CASSANDRA-11134:

 Reviewer: Sam Tunnicliffe
Fix Version/s: 3.4

> [SASI Pre-QA] Index creation should respect IF NOT EXISTS
> -
>
> Key: CASSANDRA-11134
> URL: https://issues.apache.org/jira/browse/CASSANDRA-11134
> Project: Cassandra
>  Issue Type: Bug
>  Components: CQL
> Environment: Tested from build 
> [CASSANDRA-11067|https://issues.apache.org/jira/browse/CASSANDRA-11067]
>Reporter: DOAN DuyHai
>Assignee: Pavel Yaskevich
> Fix For: 3.4
>
>
> Tested from build 
> [CASSANDRA-11067|https://issues.apache.org/jira/browse/CASSANDRA-11067]
> {code:sql}
> CREATE KEYSPACE music WITH replication = {'class': 'SimpleStrategy', 
> 'replication_factor': '1'}  AND durable_writes = true;
> CREATE TABLE music.albums (
> id int PRIMARY KEY,
> country text,
> title text
> );
> CREATE CUSTOM INDEX IF NOT EXISTS ON albums (country) USING 
> 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = {'mode':'PREFIX'};
> CREATE CUSTOM INDEX IF NOT EXISTS ON albums (country) USING 
> 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = {'mode':'PREFIX'};
> InvalidRequest: code=2200 [Invalid query] message="Index albums_country_idx_1 
> is a duplicate of existing index albums_country_idx"
> {code}
> The index creation should respect *IF NOT EXISTS* semantics and not create a 
> duplicate index if there is already one index on the same column



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)