MDEV-8220 Server crashes if started with --enforce-storage-engine option

1 files changed, 6 insertions, 0 deletions

diff --git a/mysql-test/t/enforce_storage_engine_opt.test b/mysql-test/t/enforce_storage_engine_opt.test
new file mode 100644
index 00000000000..82cc4117cdb
--- /dev/null
+++ b/mysql-test/t/enforce_storage_engine_opt.test
@@ -0,0 +1,6 @@
+create table t1 (c1 int primary key auto_increment, c2 varchar(10)) engine=memory;
+show create table t1;
+set session sql_mode='no_engine_substitution';
+--error 1286
+create table t2 (c1 int primary key auto_increment, c2 varchar(10)) engine=memory;
+drop table t1;