cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Yaskevich (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-11134) [SASI Pre-QA] Index creation should respect IF NOT EXISTS
Date Mon, 08 Feb 2016 05:24:39 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-11134?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15136597#comment-15136597
] 

Pavel Yaskevich commented on CASSANDRA-11134:
---------------------------------------------

Branch [sasi_validation|https://github.com/xedin/cassandra/tree/sasi_validation] addresses
this by adding explicit check if the index is already present.

> [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)

Mime
View raw message