bb-10.6-mdev28749 : lp:maria : Git : Code : MariaDB

Get this branch:: git clone -b bb-10.6-mdev28749 https://git.launchpad.net/maria

Branch merges

Branch information

Name:: bb-10.6-mdev28749

Repository:: lp:maria

Recent commits

161e8c5... by Sergey Petrunia on 2022-06-06

MDEV-28749: restore_prev_nj_state() doesn't update cur_sj_inner_tables correctly

Errors:
1. restore_prev_sj_state() assumed that
  "we assume remaining_tables doesnt contain @tab"
  which wasn't true.
2. Another bug in this function: it did remove bits from
   join->cur_sj_inner_tables but never added them.
3. greedy_search() adds tables into the join prefix but
   neglects to update the semi-join optimization state.
   It does update nested outer join state, see this call:

check_interleaving_with_nj(best_table)

   but there's no matching call to update the semi-join state.
   (This wasn't visible because most of the state is in the POSITION
    structure which is updated. But there is also state in JOIN, too)

The patch:
- Fixes all of the above
- Adds JOIN::dbug_verify_sj_inner_tables() which is used to verify the
  state is correct at every step.
- Renamed advance_sj_state() to optimize_semi_joins().
  = Introduced update_sj_state() which ideally should be called
    "advance_sj_state" but I didn't reuse the name to avoid confusion.

2f8d0af... by Marko Mäkelä on 2022-06-02

Merge 10.5 into 10.6

22f935d... by Marko Mäkelä on 2022-06-02

MDEV-28731 Race condition on log checkpoint

mtr_t::modify(): Set the m_made_dirty flag if needed,
so that buf_pool_t::insert_into_flush_list() will be invoked
while holding log_sys.flush_order_mutex.

This is something that was should have been part of
commit b212f1dac284cc9b7a060f1eed2cd4604c326966 (MDEV-22107).

5909e0e... by Marko Mäkelä on 2022-06-02