summaryrefslogtreecommitdiff
path: root/mysql-test/main/log_tables.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/log_tables.test')
-rw-r--r--mysql-test/main/log_tables.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/main/log_tables.test b/mysql-test/main/log_tables.test
index 4ea8a7639ef..0823b3e0eb4 100644
--- a/mysql-test/main/log_tables.test
+++ b/mysql-test/main/log_tables.test
@@ -269,6 +269,14 @@ alter table mysql.slow_log engine=memory;
#alter table mysql.slow_log engine=blackhole;
set storage_engine= @save_storage_engine;
+# Make sure only non-transactional Aria table can be used for logging
+--error ER_UNSUPORTED_LOG_ENGINE
+ALTER TABLE mysql.general_log ENGINE=Aria;
+ALTER TABLE mysql.general_log ENGINE=Aria transactional = 0;
+--error ER_UNSUPORTED_LOG_ENGINE
+ALTER TABLE mysql.slow_log ENGINE=Aria;
+ALTER TABLE mysql.slow_log ENGINE=Aria transactional = 0;
+
drop table mysql.slow_log;
drop table mysql.general_log;