Benjamin Lerer created CASSANDRA-16686:
------------------------------------------

             Summary: Queries returning static content when the partition has 
no rows might fail to return some rows
                 Key: CASSANDRA-16686
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-16686
             Project: Cassandra
          Issue Type: Bug
            Reporter: Benjamin Lerer
            Assignee: Benjamin Lerer


The problem can be reproduced with the following test:
{code}
    @Test
    public void testStaticColumnDeletionWithMultipleStaticColumns() throws 
Throwable
    {
        createTable("CREATE TABLE %s (pk int, ck int, s1 int static, s2 int 
static, v int, PRIMARY KEY(pk, ck))");
        execute("INSERT INTO %s (pk, s1, s2) VALUES (1, 1, 1) USING TIMESTAMP 
1000");
        flush();
        execute("INSERT INTO %s (pk, s1) VALUES (1, 2) USING TIMESTAMP 2000");
        flush();
        execute("DELETE s1 FROM %s USING TIMESTAMP 3000 WHERE pk = 1");
        flush();
        assertRows(execute("SELECT * FROM %s WHERE pk=1"), row(1, null, null, 
1, null));
        assertRows(execute("SELECT s1, s2 FROM %s WHERE pk=1"), row((Integer) 
null, 1));
        assertRows(execute("SELECT s1 FROM %s WHERE pk=1"), row((Integer) 
null)); // <-FAIL
    }
{code}

This problem is a regression in 4.0 and trunk



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to