maria:bb-10.9-MDEV-27699

Last commit made on 2022-04-14
Get this branch:
git clone -b bb-10.9-MDEV-27699 https://git.launchpad.net/maria

Branch merges

Branch information

Name:
bb-10.9-MDEV-27699
Repository:
lp:maria

Recent commits

d097748... by Oleg Smirnov

MDEV-27699 ANALYZE FORMAT=JSON fields are incorrect for UNION ALL queries

UNION ALL queries are a subject of optimization introduced in MDEV-334
when creation of a temporary table is skipped.
While there is a check for this optimization in Explain_union::print_explain()
there was no such in Explain_union::print_explain_json(). This resulted in
printing irrelevant data like:
  "union_result": {
    "table_name": "<union2,3>",
    "access_type": "ALL",
    "r_loops": 0,
    "r_rows": null
in case when creation of the temporary table was actually optimized out.
This commits adds a check whether the temporary table was actually created
during the UNION ALL processing and eliminates printing of the irrelevant data.

e98013c... by Marko Mäkelä

Merge 10.8 into 10.9

cbf9d8a... by Nayuta Yanagisawa

Merge 10.7 into 10.8

e87c710... by Kiyoshi Takeda

MDEV-27981 Deprecate spider_internal_limit

The variable spider_internal_limit is for specifying the number of
records acquired by Spider from each remote server.

There seems not to be much use of the variable. Thus, we deprecate it
and the corresponding table options.

Reviewed-by: Nayuta Yanagisawa <email address hidden>

bea47a6... by Daniel Black

MDEV-27791: rocksdb_log_dir test postfix

We can only remove a subdirectory in mtr on an installed instance

Example failure previously:

CURRENT_TEST: rocksdb.rocksdb_log_dir
mysqltest: At line 15: Path '/usr/local/mariadb-10.9.0-linux-systemd-x86_64/mysql-test/var/tmp/1' is not a subdirectory of MYSQLTEST_VARDIR '/usr/local/mariadb-10.9.0-linux-systemd-x86_64/mysql-test/var/1'or MYSQL_TMP_DIR '/usr/local/mariadb-10.9.0-linux-systemd-x86_64/mysql-test/var/tmp/1'

1ac87d6... by Xinyi Hong <email address hidden>

MDEV-27791: Create a new MyRocks parameter rocksdb_log_dir

Parameter rocksdb_log_dir specifies the path of MyRocks error logs.

By default, the error logs are stored in the same folder with MyRocks
redo logs. Being able to put human readable logs in one place and
machine logs in another place improves usability.

All new code of the whole pull request, including one or several files
that are either new files or modified ones, are contributed under the
BSD-new license. I am contributing on behalf of my employer Amazon Web
Services, Inc.

aa3a9d1... by Marko Mäkelä

Merge 10.6 into 10.7

cdc0bbd... by Marko Mäkelä

Merge 10.5 into 10.6

e41500e... by Alexander Barkov

MDEV-26128 type_set and type_enum are broken

The problem was not with the server behavior,
it was with wrong test results recorded.

Enabling both type_set and type_enum.

type_set.result was OK. The test did not fail.

type_enum.result was incorrectly recorded in this commit:
  eb483c5181ab430877c135c16224284cfc517b3d

Recording correct results.

011b332... by THIRUNARAYANAN BALATHANDAYUTHAPANI

MDEV-28037 Assertion `trx->bulk_insert' failed in innodb_prepare_commit_versioned

- Trigger statement initiate update statement after bulk insert
operation and leads to disable of bulk operation. During commit,
InnoDB expects transaction to be in bulk insert mode before
applying the bulk insert operation. InnoDB transaction should
apply all bulk insert operation before disabling bulk insert
operation.