MariaDB

maria:bb-10.4-MDEV-27233-2

  1. Git
  2. lp:maria
  3. bb-10.4-MDEV-27233-2
Last commit made on 2022-07-20
Get this branch:
git clone -b bb-10.4-MDEV-27233-2 https://git.launchpad.net/maria

Branch merges

Branch information

Name:
bb-10.4-MDEV-27233-2
Repository:
lp:maria

Recent commits

1f25595... by Nayuta Yanagisawa

MDEV-27233 Server hangs when using --init-file which loads Spider and creates a Spider table

Spider waits until the server initialization is complete
(i.e., mysqld_server_started == 1) before creating the Spider system
tables like mysql.spider_XX. Spider also wait until the tables are
created before instantiating ha_spider.

This results in dead lock when Spider is loaded and a non-system
Spider table is created by --in-file because queries passed by
--in-file are executed during the server initialization
(i.e., mysqld_server_started == 0).

In the first place, there seems to be no need for Spider to wait until
the server initialization is completed before creating the system
tables. Thus, we simply remove that synchronization.

0092301... by Alexey Botchkov

Fix to quiet the compiler on Windows.

2b43dfc... by Alexey Botchkov

MDEV-27595 Backport SQL service, introduced by MDEV-19275.

test_sql_service.test fixed.

9465024... by Alexey Botchkov

MDEV-27595 Backport SQL service, introduced by MDEV-19275.

Embedded-server related fixes.

9baa814... by Alexey Botchkov

MDEV-27832 disable binary logging for SQL SERVICE.

Binary logging is now disabled for the queries run by SQL SERVICE.
The binlogging can be turned on with the 'SET SQL_LOG_BIN=On' query.

Conflicts:
 sql/sql_prepare.cc

277a614... by Alexey Botchkov

Fixes to make SQL SERVICE working.

1fb606a... by Alexey Botchkov

MDEV-26890 : Crash on shutdown, with active binlog dump threads

   Backported from 10.7.
   The reason for the crash was a bug in MDEV-19275, after which
   shutdown does not wait for binlog threads anymore.

c87738c... by Alexey Botchkov

The SQL SERVICE backported into the 10.4 to be tested.

8911823... by Alexey Botchkov

MDEV-26546 SIGSEGV's in spider_db_connect on SHOW TABLE and spider_db… …_mbase::connect (and SIGSEGV's in check_vcol_forward_refs and inline_mysql_mutex_lock)

Not the SPIDER issue - happens to INSERT DELAYED.
the field::make_new_field does't copy the LONG_UNIQUE_HASH_FIELD
flag to the new field. Though the Delayed_insert::get_local_table
copies the field->vcol_info for this field. Ad a result
the parse_vcol_defs doesn't create the expression for that column
so the field->vcol_info->expr is NULL. Which leads to crash.
Backported fix for this from 10.5 - the flagg added in the
Delayed_insert::get_local_table.

Another problem with the USING HASH key is thst the
parse_vcol_defs modifies the table->keys content. Then the same
parse_vcol_defs is called on the table copy that has keys already
modified. Backported fix for that from 10.5 - key copying added
tot the Delayed_insert::get_local_table.

Finally - the created copy has to clear the expr_arena as
this table is not in the thd->open_tables list so won't be
cleared automatically.

65cc89e... by Igor Babaev

MDEV-29088 Server crash upon CREATE VIEW with unknown column in ON condition

This bug caused crashes when the server executed such a CREATE VIEW
statement whose view specification contained a reference to an unknown
column in a subquery used in ON condition.
The cause of this bug is quite similar to the cause of the bug MDEV-26412.
The fix of this bug is quite similar to the fix for MDEV-26412.

Approved by Sergey Petrunia <email address hidden>