Uploaded image for project: 'Apache Cassandra'
  1. Apache Cassandra
  2. CASSANDRA-15459

Short read protection doesn't work on group-by queries

    XMLWordPrintableJSON

Details

    Description

      DTest to reproduce: it affects all versions..

      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]
      

      Note: for group-by queries, SRP should use "group counted" to calculate limits used for SRP query, rather than "row counted".

      Attachments

        Issue Links

          Activity

            People

              adelapena Andres de la Peña
              jasonstack Zhao Yang
              Andres de la Peña
              Caleb Rackliffe
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 2.5h
                  2.5h