diff options
Diffstat (limited to 'mysql-test/main/flush.test')
| -rw-r--r-- | mysql-test/main/flush.test | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/mysql-test/main/flush.test b/mysql-test/main/flush.test index 97830238b0e..dd488070ce8 100644 --- a/mysql-test/main/flush.test +++ b/mysql-test/main/flush.test @@ -1,3 +1,5 @@ +--source include/have_perfschema.inc + connect (con1,localhost,root,,); connect (con2,localhost,root,,); connection con1; @@ -732,3 +734,32 @@ set @@global.thread_cache_size=0; flush threads; show status like "Threads_cached"; set @@global.thread_cache_size=@save_thread_cache_size; + +--echo # +--echo # MDEV-25906: SIGSEGV in flush_tables_with_read_lock on FTWRL or FTFE | SIGSEGV in ha_maria::extra +--echo # + +CREATE VIEW v AS SELECT 1 FROM (SELECT 1) AS d; +CREATE VIEW v2 AS SELECT * FROM v; +--error ER_WRONG_OBJECT +FLUSH TABLE v WITH READ LOCK; +--error ER_WRONG_OBJECT +FLUSH TABLE v FOR EXPORT; +--error ER_WRONG_OBJECT +FLUSH TABLE v2 WITH READ LOCK; +DROP VIEW v2; +DROP VIEW v; + +CREATE VIEW v(c) AS SELECT column_name FROM information_schema.columns; +--error ER_DBACCESS_DENIED_ERROR +FLUSH TABLE v WITH READ LOCK; +--error ER_DBACCESS_DENIED_ERROR +FLUSH TABLE v FOR EXPORT; +DROP VIEW v; + +CREATE VIEW v(u) AS SELECT user FROM performance_schema.accounts; +--error ER_DBACCESS_DENIED_ERROR +FLUSH TABLE v WITH READ LOCK; +--error ER_DBACCESS_DENIED_ERROR +FLUSH TABLE v FOR EXPORT; +DROP VIEW v; |