mirror of
https://github.com/MariaDB/server.git
synced 2025-06-25 14:11:27 +02:00
dd710e7552
Relaxed assertion (in MySQL it was removed). For "LOCK TABLES t1 WRITE CONCURRENT, t1 READ" upgrade lock to weakest existing suitable lock, which is MDL_SHARED_NO_READ_WRITE.
19 lines
772 B
Text
19 lines
772 B
Text
--source include/have_metadata_lock_info.inc
|
|
--source include/have_innodb.inc
|
|
|
|
--echo #
|
|
--echo # MDEV-12882 - Assertion `mdl_ticket->m_type == MDL_SHARED_UPGRADABLE ||
|
|
--echo # mdl_ticket->m_type == MDL_SHARED_NO_WRITE ||
|
|
--echo # mdl_ticket->m_type == MDL_SHARED_NO_READ_WRITE ||
|
|
--echo # mdl_ticket->m_type == MDL_SHARED_READ'
|
|
--echo # failed in MDL_context::upgrade_shared_lock
|
|
--echo #
|
|
|
|
CREATE TABLE t1(a INT) ENGINE=InnoDB;
|
|
LOCK TABLES t1 WRITE CONCURRENT, t1 AS t2 READ;
|
|
SELECT * FROM information_schema.metadata_lock_info;
|
|
UNLOCK TABLES;
|
|
LOCK TABLES t1 AS t2 READ, t1 WRITE CONCURRENT;
|
|
SELECT * FROM information_schema.metadata_lock_info;
|
|
UNLOCK TABLES;
|
|
DROP TABLE t1;
|