[ https://issues.apache.org/jira/browse/CASSANDRA-8156?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael Shuler updated CASSANDRA-8156: -------------------------------------- Assignee: Sylvain Lebresne > Support 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 > > 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)