[jira] [Created] (CASSANDRA-15459) Short read protection doesn't work on group-by queries

["ZhaoYang (Jira)" <ji...@apache.org>]

ZhaoYang created CASSANDRA-15459:
------------------------------------

             Summary: Short read protection doesn't work on group-by queries
                 Key: CASSANDRA-15459
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-15459
             Project: Cassandra
          Issue Type: Bug
          Components: Legacy/Coordination
            Reporter: ZhaoYang


[DTest to reproduce|https://github.com/apache/cassandra-dtest/compare/master...jasonstack:srp_group_by_trunk?expand=1]:

{code}
In a two-node cluster with RF = 2

Execute only on Node1:
* Insert pk=1 and ck=1 with timestamp 9
* Delete pk=0 and ck=0 with timestamp 10
* Insert pk=2 and ck=2 with timestamp 9

Execute only on Node2:
* Delete pk=1 and ck=1 with timestamp 10
* Insert pk=0 and ck=0 with timestamp 9
* Delete pk=2 and ck=2 with timestamp 10

Query: "SELECT pk, c FROM %s GROUP BY pk LIMIT 1"
* Expect no live data, but got [0, 0]
{code}


Note: for group-by queries, SRP should use "group counted" to calculate rows-to-fetch, rather than "row counted".



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