bb-11.0-mdev-29447-31338 : lp:maria : Git : Code : MariaDB

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

Branch merges

Branch information

Name:: bb-11.0-mdev-29447-31338

Repository:: lp:maria

Recent commits

1899067... by Yuchen Pei on 2023-01-03

MDEV-29447 MDEV-26285 MDEV-31338 Refactor spider_db_mbase_util::open_item_func

spider_db_mbase_util::open_item_func() is a monster function.
It is difficult to maintain while it is expected that we need to
modify it when a new SQL function or a new func_type is added.

We split the function into two distinct functions: one handles the
case of str != NULL and the other handles the case of str == NULL.

This refactoring was done in a conservative way because we do not
have comprehensive tests on the function.

It also fixes MDEV-29447 and MDEV-31338 where field items that are
arguments of a func item may be used before created / initialised.

Note this commit is adapted from a patch by Nayuta for MDEV-26285.

3d617fd... by Monty <email address hidden> on 2023-06-21

MDEV-31375 Assertion `dbl_records <= s->records' failed with optimizer_use_condition_selectivity=1

The reason for the crash wad that 'best splitting' optimization
predicted less rows to be found than what opt_range did.
This code in apply_selectivity_for_table(), when using use_cond_selectivity=1,
was not prepared for this case which caused an assert in debug builds.
Production builds is not affected.

The fix is to choose the smaller of the two row counts. It will have a
minimum on costs when using use_cond_selectivity=1 and should not cause
any problems in production.

d3c8180... by Monty <email address hidden> on 2023-06-21

MDEV-31494 Server crashes in ha_partition::index_blocks / get_key_scans_params

MDEV-31445 Server crashes in ha_partition::index_blocks / cost_for_index_read

The crash happened in the case where partition pruning finds 0
partitions.

f25a74c... by Monty <email address hidden> on 2023-06-18

Fixed typo on opt_range.cc: SEL_ARG::number_of_eq_groups()

It could cause wrong range estimation for GROUP BY queries that are
using 'WHERE index_part >= constant'.
(The function was trying to check for 'index_part = constant')

Reporter: Yuty Chaikou

5fb2c03... by Marko Mäkelä on 2023-06-08