[CASSANDRA-13627] Index queries are rejected on COMPACT tables

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.0.15, 3.11.1, 4.0-alpha1, 4.0
• Component/s: Legacy/CQL
• Bug Category: Correctness - API / Semantic Implementation
• Severity: Normal
• Since Version: 3.0.0
• Assignee: Benjamin Lerer
• Reporter: Benjamin Lerer

Authors

Benjamin Lerer

Reviewers

Andres de la Peña

• Created: 21/Jun/17 13:04
• Updated: 15/May/20 08:02
• Resolved: 26/Jun/17 11:34

Description

Since 3.0, compact tables are using under the hood static columns. Due to that SELECT queries using secondary indexes get rejected with the following error:
Queries using 2ndary indexes don't support selecting only static columns.

This problem can be reproduced using the following unit test:

    @Test
    public void testIndicesOnCompactTable() throws Throwable
    {
        createTable("CREATE TABLE %s (pk int PRIMARY KEY, v int) WITH COMPACT STORAGE");
        createIndex("CREATE INDEX ON %s(v)");

        execute("INSERT INTO %S (pk, v) VALUES (?, ?)", 1, 1);
        execute("INSERT INTO %S (pk, v) VALUES (?, ?)", 2, 1);
        execute("INSERT INTO %S (pk, v) VALUES (?, ?)", 3, 3);

        assertRows(execute("SELECT pk, v FROM %s WHERE v = 1"),
                   row(1, 1),
                   row(2, 1));

    }