mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
b1c6dc6e90
anticipate different execution paths resulting in different thd->proc_info. - Fixed subselect_cache to contain correct results. The results are currently wrong in 5.3, but are correct in 5.2, and 5.3-mwl89.
62 lines
1.5 KiB
PHP
62 lines
1.5 KiB
PHP
#
|
|
# SUMMARY
|
|
# Check if statement reading table '$table' takes shared locks
|
|
# on some of its rows.
|
|
#
|
|
# PARAMETERS
|
|
# $table Table for which presence of row locks should be checked.
|
|
# $con_aux Name of auxiliary connection to be used by this script.
|
|
# $statement Statement to be checked.
|
|
# $wait_statement Sub-statement which is supposed to acquire locks (should
|
|
# be the same as $statement for ordinary statements).
|
|
#
|
|
# EXAMPLE
|
|
# innodb_mysql_lock2.test
|
|
#
|
|
--disable_result_log
|
|
--disable_query_log
|
|
|
|
connection default;
|
|
begin;
|
|
--eval select * from $table for update;
|
|
|
|
connection $con_aux;
|
|
begin;
|
|
--send_eval $statement;
|
|
|
|
--enable_result_log
|
|
--enable_query_log
|
|
|
|
connection default;
|
|
# Wait until statement is successfully blocked because
|
|
# all rows in table are X-locked. This means that at
|
|
# least it acquires S-locks on some of rows.
|
|
let $wait_condition=
|
|
select count(*) = 1 from information_schema.processlist
|
|
where state in ("Sending data","statistics", "preparing", "updating",
|
|
"executing", "Searching rows for update") and
|
|
info = "$wait_statement";
|
|
--source include/wait_condition.inc
|
|
|
|
--disable_result_log
|
|
--disable_query_log
|
|
|
|
rollback;
|
|
|
|
connection $con_aux;
|
|
--reap
|
|
rollback;
|
|
|
|
connection default;
|
|
--enable_result_log
|
|
--enable_query_log
|
|
|
|
if ($success)
|
|
{
|
|
--echo Success: '$statement' takes shared row locks on '$table'.
|
|
}
|
|
|
|
if (!$success)
|
|
{
|
|
--echo Error: '$statement' hasn't taken shared row locks on '$table'!
|
|
}
|