MariaDB

maria:bb-10.2-MDEV-27575

  1. Git
  2. lp:maria
  3. bb-10.2-MDEV-27575
Last commit made on 2022-02-22
Get this branch:
git clone -b bb-10.2-MDEV-27575 https://git.launchpad.net/maria

Branch merges

Branch information

Name:
bb-10.2-MDEV-27575
Repository:
lp:maria

Recent commits

f4aa25f... by Nayuta Yanagisawa

MDEV-27575 SIGSEGV in intern_plugin_lock on SHUTDOWN when setting Spider as default tmp SE

Setting Spider as the default tmp storage engine results in the
server crash at its shutdown.

The crash is due to the lack of NULL checking in intern_plugin_lock().

647e952... by varun

MDEV-15208: server crashed, when using ORDER BY with window function and UNION

(Edits by SergeiP: fix encryption.tempfiles_encrypted, re-word comment)

Global ORDER BY clause of a UNION may not refer to 1) aggregate functions
or 2) window functions. setup_order() checked for #1 but not for #2.

942a979... by varun

MDEV-15208: server crashed, when using ORDER BY with window function and UNION

SELECTs inside a UNION can have window function but not the global ORDER BY clause of the UNION.

d140d27... by Sergey Petrunia

MDEV-22377: Subquery in an UPDATE query uses full scan instead of range

[Patch idea by Igor Babaev]

Symptom: for IN (SELECT ...) subqueries using IN-to-EXISTS transformation,
the optimizer was unable to make inferences using multiple equalities.

The cause is code Item_in_subselect::inject_in_to_exists_cond() which may
break invariants that Multiple-Equality code relies on. In particular, it
may produce a WHERE condition with an empty Item_cond::m_cond_equal.

Fixed this by making Item_cond::m_cond_equal.

24ec144... by Vladislav Vaintroub

MDEV-27901 Windows : expensive system calls used to calculate file system block size

The result is not used anywhere but in the output of Innodb information
schema, but this can take as much as 7%CPU (only) on a benchmark.

Fix to move fs blocksize calculate to where it is used.

4e667b9... by Vladislav Vaintroub

MDEV-27877 considerably speed up innodb_force_recovery test

decrease innodb_lock_wait_timeout for the current session.

73c391a... by Marko Mäkelä

MDEV-27583 InnoDB uses different constants for FK cascade error message in SQL vs error log

convert_error_code_to_mysql(): Use the correct limit FK_MAX_CASCADE_DEL
in the error message. The DICT_FK_MAX_RECURSIVE_LOAD applies to
the number of foreign key constraints in table definitions,
not to the number of rows that are visited while processing
a foreign key constraint.

da64e50... by Marko Mäkelä

MDEV-27722 innodb_fts.innodb-fts-ddl fails with a wrong message on FreeBSD

On FreeBSD, the error message would say "Resource deadlock avoided".
Let us simply replace the error message string in the test.

9f429a2... by Jonathan Sabbe <email address hidden>

fix: Fix 'unknown type usermodehelper_t' issue after upgrading to MariaDB 10.4.24

e195685... by Larysa Sherepa

MDEV-27548 session_tracker_last_gtid.test fails with --repeat, added cleanup after the test