bb-11.0-mdev30693 : lp:maria : Git : Code : MariaDB

Get this branch:: git clone -b bb-11.0-mdev30693 https://git.launchpad.net/maria

Branch merges

Branch information

Name:: bb-11.0-mdev30693

Repository:: lp:maria

Recent commits

301fd68... by Sergey Petrunia on 2023-02-22

MDEV-30693: Assertion `dbl_records <= s->records' failed in apply_selectivity_for_table on SELECT

The crash happened due to rows=2 vs rows=1 difference between how the
estimate of number of rows in a derived table is computed in
TABLE_LIST::fetch_number_of_rows() and JOIN::add_keyuses_for_splitting().

Made JOIN::add_keyuses_for_splitting() use the result of computations in
TABLE_LIST::fetch_number_of_rows().

d61bc94... by Sergey Petrunia on 2023-02-21

MDEV-30659 Server crash on EXPLAIN SELECT/SELECT on table with engine Aria for LooseScan Strategy

Amended patch from Monty:

The issue was that Loose_scan_opt::save_to_position() did not take
into account records_out from best_access_path()

Make sure that POSITION object filled by Loose_scan_opt::save_to_position()
has records_out not higher than any other possible access method.

d5d7c8b... by Marko Mäkelä on 2023-02-02

MDEV-30544 Deprecate innodb_defragment and related parameters

There is a little used option innodb_defragment that would make
OPTIMIZE TABLE not rebuild the table as usual for InnoDB, but
instead cause the index B-trees to be optimized in place.

This option uses excessive locking (exclusively locking index trees).
It never covered SPATIAL INDEX or FULLTEXT INDEX. Storage space
was never reclaimed.

Because this option is not particularly useful and causes a
maintenance burden (most recently in
commit de4030e4d49805a7ded5c0bfee01cc3fd7623522),
it is best to deprecate it, to prepare for its removal.

2b13ae1... by Marko Mäkelä on 2023-02-21