• Sergei Petrunia's avatar
    MDEV-27382: OFFSET is ignored when combined with DISTINCT · 7259b299
    Sergei Petrunia authored
    A query in form
    
      SELECT DISTINCT expr_that_is_inferred_to_be_const LIMIT 0 OFFSET n
    
    produces one row when it should produce none. The issue was in
    JOIN_TAB::remove_duplicates() in the piece of logic that tried to
    avoid duplicate removal for such cases but didn't account for possible
    "LIMIT 0".
    
    Fixed by making Select_limit_counters::set_limit() change OFFSET to 0
    when LIMIT is 0.
    7259b299
distinct.test 28.9 KB