[jira] [Created] (CASSANDRA-9527) Cannot create secondary index on a table WITH COMPACT STORAGE

[fuggy_yama (JIRA)]

fuggy_yama created CASSANDRA-9527:
-------------------------------------

             Summary: Cannot create secondary index on a table WITH COMPACT 
STORAGE
                 Key: CASSANDRA-9527
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-9527
             Project: Cassandra
          Issue Type: Bug
          Components: Core
         Environment: cassandra v2.0.13
            Reporter: fuggy_yama
            Priority: Minor


In CASSANDRA-8156 it is said that secondary indexes are not allowed on PK 
columns in COMPACT tables.

However, I found that it is not possible to create a secondary index on the 
value column in a COMPACT table:

CREATE TABLE t (
        a INT,
        b INT,
        c INT,
        PRIMARY KEY (a, b)
) WITH COMPACT STORAGE;

CREATE INDEX ON t (c);

Bad Request: Secondary indexes are not supported on PRIMARY KEY columns in 
COMPACT STORAGE tables




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