[ https://issues.apache.org/jira/browse/CASSANDRA-9527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14569146#comment-14569146 ]
Benjamin Lerer commented on CASSANDRA-9527: ------------------------------------------- The issue is valid. Our test is: {code} if ((cfm.getCfDef().isCompact || !cfm.getCfDef().isComposite) && cd.type != ColumnDefinition.Type.REGULAR) throw new InvalidRequestException("Secondary indexes are not supported on PRIMARY KEY columns in COMPACT STORAGE tables"); {code} The problem is that the type of the c column is {{ColumnDefinition.Type.COMPACT_VALUE}} and not {{ColumnDefinition.Type.REGULAR}}. > 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 > Assignee: Benjamin Lerer > Priority: Minor > Fix For: 2.0.x > > > In CASSANDRA-8156 it is said that secondary indexes are not allowed on > clustering 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)