summaryrefslogtreecommitdiff
path: root/mysql-test/main/flush.result
diff options
context:
space:
mode:
authorAlexey Botchkov <holyfoot@askmonty.org>2021-06-29 16:03:26 +0400
committerAlexey Botchkov <holyfoot@askmonty.org>2021-06-29 16:03:26 +0400
commitc2ebe8147d72f62ee10ec0a0815971ebd21aa8ff (patch)
treed6c9d22461e702b1e26f422bb901605832ca03e3 /mysql-test/main/flush.result
parent0237e9bb65a9a70303bd59c3febc4e738df1b72a (diff)
downloadmariadb-git-c2ebe8147d72f62ee10ec0a0815971ebd21aa8ff.tar.gz
MDEV-25837 Assertion `thd->locked_tables_mode == LTM_NONE' failed in Locked_tables_list::init_locked_tables.
don't do prelocking for the FLUSH command.
Diffstat (limited to 'mysql-test/main/flush.result')
-rw-r--r--mysql-test/main/flush.result11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/main/flush.result b/mysql-test/main/flush.result
index 941dc63e3da..c73125e3420 100644
--- a/mysql-test/main/flush.result
+++ b/mysql-test/main/flush.result
@@ -606,6 +606,17 @@ drop view v1, v2;
drop table t1;
disconnect con1;
#
+# MDEV-25837 Assertion `thd->locked_tables_mode == LTM_NONE' failed in Locked_tables_list::init_locked_tables.
+#
+CREATE FUNCTION f() RETURNS INTEGER RETURN 1;
+CREATE TABLE t (a INT);
+CREATE VIEW v AS SELECT 2 FROM t WHERE f() < 3;
+FLUSH TABLE v WITH READ LOCK;
+UNLOCK TABLES;
+DROP VIEW v;
+DROP FUNCTION f;
+DROP TABLE t;
+#
# Test FLUSH THREADS
#
set @save_thread_cache_size=@@global.thread_cache_size;