diff options
| author | Monty <monty@mariadb.org> | 2021-05-23 19:41:17 +0300 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2021-05-23 19:41:49 +0300 |
| commit | 5a20b30fb306882718dee307571269502ceb2720 (patch) | |
| tree | fe23d7905a797feca72dd37b81bc1d9d7330ba99 | |
| parent | 15214a4f11a4081dd716c60bc163eeddc2024149 (diff) | |
| download | mariadb-git-5a20b30fb306882718dee307571269502ceb2720.tar.gz | |
MDEV-25738 Assertion `ticket->m_duration == MDL_EXPLICIT' failed
No crash (probably fixed before). Added test case
| -rw-r--r-- | mysql-test/main/trigger-trans.result | 13 | ||||
| -rw-r--r-- | mysql-test/main/trigger-trans.test | 16 |
2 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/main/trigger-trans.result b/mysql-test/main/trigger-trans.result index c58c4230a40..24ef9a4291a 100644 --- a/mysql-test/main/trigger-trans.result +++ b/mysql-test/main/trigger-trans.result @@ -229,3 +229,16 @@ INSERT INTO t2 (id) VALUES (1); disconnect con2; connection default; DROP TABLE t3, t2, t1; +# +# MDEV-25738 Assertion `ticket->m_duration == MDL_EXPLICIT' failed in +# void MDL_context::release_lock(MDL_ticket*) +# +CREATE TABLE t1 (id int(11)) ENGINE=InnoDB; +SET max_statement_time= 0.001; +LOCK TABLES t1 WRITE; +CREATE TRIGGER tr16 AFTER UPDATE ON t1 FOR EACH ROW INSERT INTO t1 VALUES (1); +DROP TABLE t1; +SET max_statement_time= default; +# +# End of 10.5 tests +# diff --git a/mysql-test/main/trigger-trans.test b/mysql-test/main/trigger-trans.test index 17656c3516e..378da045e0a 100644 --- a/mysql-test/main/trigger-trans.test +++ b/mysql-test/main/trigger-trans.test @@ -233,3 +233,19 @@ DROP TABLE t3, t2, t1; # Wait till we reached the initial number of concurrent sessions --source include/wait_until_count_sessions.inc + +--echo # +--echo # MDEV-25738 Assertion `ticket->m_duration == MDL_EXPLICIT' failed in +--echo # void MDL_context::release_lock(MDL_ticket*) +--echo # + +CREATE TABLE t1 (id int(11)) ENGINE=InnoDB; +SET max_statement_time= 0.001; +LOCK TABLES t1 WRITE; +CREATE TRIGGER tr16 AFTER UPDATE ON t1 FOR EACH ROW INSERT INTO t1 VALUES (1); +DROP TABLE t1; +SET max_statement_time= default; + +--echo # +--echo # End of 10.5 tests +--echo # |