• unknown's avatar
    BUG#30573: Ordered range scan over partitioned tables returns some rows twice · 0b22925c
    unknown authored
    The problem: ha_partition::read_range_first() could return a record that is 
    outside of the scanned range. If that record happened to be in the next 
    subsequent range, it would satisfy the WHERE and appear in the output twice.
    (we would get it the second time when scanning the next subsequent range)
    
    Fix: 
    Made ha_partition::read_range_first() check if the returned recod is within
    the scanned range, like other read_range_first() implementations do.
    
    
    mysql-test/r/partition_range.result:
      BUG#30573: Ordered range scan over partitioned tables returns some rows twice
       - Testcase
    mysql-test/t/partition_range.test:
      BUG#30573: Ordered range scan over partitioned tables returns some rows twice
       - Testcase
    sql/ha_partition.cc:
      BUG#30573: Ordered range scan over partitioned tables returns some rows twice
      - Make ha_partition::read_range_first() check if the returned record is 
        within the range.
    0b22925c
ha_partition.cc 167 KB