bb-11.2-MDEV-33525 : lp:maria : Git : Code : MariaDB

Get this branch:: git clone -b bb-11.2-MDEV-33525 https://git.launchpad.net/maria

Branch merges

Branch information

Name:: bb-11.2-MDEV-33525

Repository:: lp:maria

Recent commits

b620b39... by Dmitry Shulga <email address hidden> on 2024-03-18

MDEV-33525: Recreate/reuse temporary table

Calling a stored function that uses a cursor inside its body
could produce the error ER_NO_SUCH_TABLE on the second execution
in case the cursor uses multi-table query and one of the tables
is a temporary table just created before querying the cursor and
dropped just after the query has been executed.

The reason for issue is that re-parsing of failed a SP instruction
caused be create/drop of the temporary table used LEX object
left from previous parsing of a SP instruction's query instead
re-initialize the lex object before parsing.

To fix the issue, add initialization of lex for cursor's
statement before re-parsing the query of a failed SP instruction.

1553a9d... by Oleksandr "Sanja" Byelkin on 2024-02-07

Merge branch '11.2' into mariadb-11.2.3

35c1970... by Daniel Bartholomew <email address hidden> on 2024-02-06

bump the VERSION

5d37cac... by Nikita Malyavin on 2024-02-03

MDEV-33348 ALTER TABLE lock waiting stages are indistinguishable

Several points of synchronization during ALTER TABLE COPY looked identical
in the progress report query. Besides, if its the late lock upgrade stage,
the data would be:
STAGE 0
MAX_STAGE 0
PROGRESS 0.000

which looks irrelevant.

This patch moves thd_progress_deinit call after the last lock upgrade.

Also, for online alter, if there is nothing to replicate, the
progress and max_progress values would be 0, which discard the result data
on the side of sql_show, see processlist_callback in sql_show.cc.
So now the minimal max_progress will be 1. To avoid 0% progress in the
report, minimax progress value is also set to 1, so we will see 100% if
there's nothing to replicate.

79580f4... by Sergei Golubchik on 2024-02-02