[jira] [Commented] (CASSANDRA-8156) Fix validation of indexes on composite column components of COMPACT tables

["Tyler Hobbs (JIRA)" <ji...@apache.org>]

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

Tyler Hobbs commented on CASSANDRA-8156:
----------------------------------------

One nitpick: we should improve the error message for this.  My suggestion: "Secondary indexes are not supported on PRIMARY KEY columns in COMPACT STORAGE tables"

Other than that, +1

> Fix validation of indexes on composite column components of COMPACT tables
> --------------------------------------------------------------------------
>
>                 Key: CASSANDRA-8156
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8156
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>            Reporter: Denis Angilella
>            Assignee: Sylvain Lebresne
>            Priority: Trivial
>             Fix For: 2.0.12
>
>         Attachments: 8156.txt
>
>
> CASSANDRA-5125 added support of indexes on composite column components for *non-compact* tables (see CASSANDRA-5125 comments for additional information).
> This is a follow up for *compact* tables.
> Using compact tables it is possible to CREATE INDEX on composite primary key columns, but queries returns no results for the tests below.
> {code:sql}
> CREATE TABLE users2 (
>    userID uuid,
>    fname text,
>    zip int,
>    state text,
>   PRIMARY KEY ((userID, fname))
> ) WITH COMPACT STORAGE;
> CREATE INDEX ON users2 (userID);
> CREATE INDEX ON users2 (fname);
> INSERT INTO users2 (userID, fname, zip, state) VALUES (b3e3bc33-b237-4b55-9337-3d41de9a5649, 'John', 10007, 'NY');
> -- the following queries returns 0 rows, instead of 1 expected
> SELECT * FROM users2 WHERE fname='John'; 
> SELECT * FROM users2 WHERE userid=b3e3bc33-b237-4b55-9337-3d41de9a5649;
> SELECT * FROM users2 WHERE userid=b3e3bc33-b237-4b55-9337-3d41de9a5649 AND fname='John';
> -- dropping 2ndary indexes restore normal behavior
> {code}



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