[CASSANDRA-11556] PER PARTITION LIMIT does not work properly for multi-partition query with ORDER BY

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.6
• Severity: Normal
• Assignee: Alex Petrov
• Reporter: Benjamin Lerer

Authors

Alex Petrov

Reviewers

Benjamin Lerer

• Created: 12/Apr/16 11:57
• Updated: 16/Apr/19 09:30
• Resolved: 14/Apr/16 09:57

Description

Multi-partition queries with PER PARTITION LIMIT with ORDER BY do not respect the PER PARTITION LIMIT.

The problem can be reproduced with the following unit test:

    @Test
    public void testPerPartitionLimitWithMultiPartitionQueryAndOrderBy() throws Throwable
    {
        createTable("CREATE TABLE %s (a int, b int, c int, PRIMARY KEY (a, b))");

        for (int i = 0; i < 5; i++)
        {
            for (int j = 0; j < 5; j++)
            {
                execute("INSERT INTO %s (a, b, c) VALUES (?, ?, ?)", i, j, j);
            }
        }

        assertRows(execute("SELECT * FROM %s WHERE a IN (2, 3) ORDER BY b DESC PER PARTITION LIMIT ?", 2),
                                row(2, 4, 4),
                                row(3, 4, 4),
                                row(2, 3, 3),
                                row(3, 3, 3));
    }