1--source include/have_metadata_lock_info.inc
2--source include/have_innodb.inc
3
4--echo #
5--echo # MDEV-12882 - Assertion `mdl_ticket->m_type == MDL_SHARED_UPGRADABLE ||
6--echo #                         mdl_ticket->m_type == MDL_SHARED_NO_WRITE ||
7--echo #                         mdl_ticket->m_type == MDL_SHARED_NO_READ_WRITE ||
8--echo #                         mdl_ticket->m_type == MDL_SHARED_READ'
9--echo #                         failed in MDL_context::upgrade_shared_lock
10--echo #
11
12CREATE TABLE t1(a INT) ENGINE=InnoDB;
13LOCK TABLES t1 WRITE CONCURRENT, t1 AS t2 READ;
14SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA, TABLE_NAME FROM information_schema.metadata_lock_info;
15UNLOCK TABLES;
16LOCK TABLES t1 AS t2 READ, t1 WRITE CONCURRENT;
17SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA, TABLE_NAME FROM information_schema.metadata_lock_info;
18UNLOCK TABLES;
19DROP TABLE t1;
20