diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/main/flush.result | 25 | ||||
| -rw-r--r-- | mysql-test/main/flush.test | 31 |
2 files changed, 56 insertions, 0 deletions
diff --git a/mysql-test/main/flush.result b/mysql-test/main/flush.result index 941dc63e3da..0630a424e1c 100644 --- a/mysql-test/main/flush.result +++ b/mysql-test/main/flush.result @@ -615,3 +615,28 @@ show status like "Threads_cached"; Variable_name Value Threads_cached 0 set @@global.thread_cache_size=@save_thread_cache_size; +# +# MDEV-25906: SIGSEGV in flush_tables_with_read_lock on FTWRL or FTFE | SIGSEGV in ha_maria::extra +# +CREATE VIEW v AS SELECT 1 FROM (SELECT 1) AS d; +CREATE VIEW v2 AS SELECT * FROM v; +FLUSH TABLE v WITH READ LOCK; +ERROR HY000: 'test.v' is not of type 'BASE TABLE' +FLUSH TABLE v FOR EXPORT; +ERROR HY000: 'test.v' is not of type 'BASE TABLE' +FLUSH TABLE v2 WITH READ LOCK; +ERROR HY000: 'test.v2' is not of type 'BASE TABLE' +DROP VIEW v2; +DROP VIEW v; +CREATE VIEW v(c) AS SELECT column_name FROM information_schema.columns; +FLUSH TABLE v WITH READ LOCK; +ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' +FLUSH TABLE v FOR EXPORT; +ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' +DROP VIEW v; +CREATE VIEW v(u) AS SELECT user FROM performance_schema.accounts; +FLUSH TABLE v WITH READ LOCK; +ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' +FLUSH TABLE v FOR EXPORT; +ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' +DROP VIEW v; 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; |