[jira] [Created] (CASSANDRA-8156) Support indexes on composite column components of COMPACT tables

["Denis Angilella (JIRA)" <ji...@apache.org>]

Denis Angilella created CASSANDRA-8156:
------------------------------------------

             Summary: 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


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)