You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Benjamin Lerer (Jira)" <ji...@apache.org> on 2021/05/21 10:02:00 UTC

[jira] [Updated] (CASSANDRA-16686) Queries returning static content when the partition has no rows might fail to return some rows

     [ https://issues.apache.org/jira/browse/CASSANDRA-16686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Benjamin Lerer updated CASSANDRA-16686:
---------------------------------------
     Bug Category: Parent values: Correctness(12982)Level 1 values: Transient Incorrect Response(12987)
       Complexity: Normal
      Component/s: CQL/Interpreter
    Discovered By: Code Inspection
    Fix Version/s: 4.x
         Severity: Normal
           Status: Open  (was: Triage Needed)

> 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
>          Components: CQL/Interpreter
>            Reporter: Benjamin Lerer
>            Assignee: Benjamin Lerer
>            Priority: Normal
>             Fix For: 4.x
>
>
> 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: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org