diff options
| author | Monty <monty@mariadb.org> | 2020-07-21 15:12:53 +0300 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2020-07-21 15:12:53 +0300 |
| commit | e26c822aa0a73e62d7a3e4a0915c7bf6cd734978 (patch) | |
| tree | 51a4b3e5bd544d1a8a05c2da737b7adf4591d734 /mysql-test/suite/sql_sequence/kill.test | |
| parent | af83ed9f0ed10496c11bea6b054f4d86562e2349 (diff) | |
| download | mariadb-git-e26c822aa0a73e62d7a3e4a0915c7bf6cd734978.tar.gz | |
MDEV-16929 Assertion ... in close_thread_tables upon killing connection
Problem was that the code didn't handle a transaction created in innodb
as part of a failed mysql_lock_tables()
Diffstat (limited to 'mysql-test/suite/sql_sequence/kill.test')
| -rw-r--r-- | mysql-test/suite/sql_sequence/kill.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/suite/sql_sequence/kill.test b/mysql-test/suite/sql_sequence/kill.test new file mode 100644 index 00000000000..9caebc57f12 --- /dev/null +++ b/mysql-test/suite/sql_sequence/kill.test @@ -0,0 +1,20 @@ +--source include/have_innodb.inc + +--echo # +--echo # MDEV-16929 Assertion ... in close_thread_tables upon killing connection +--echo # running SHOW on sequence +--echo # + +CREATE SEQUENCE s ENGINE=InnoDB; +RENAME TABLE s TO s1; +--connect (con1,localhost,root,,test) +--let $conid= `SELECT CONNECTION_ID()` +--send + SHOW CREATE SEQUENCE s1; +--connection default +--replace_result $conid thread_id +--eval KILL $conid + +# Cleanup +--connection default +drop sequence s1; |