Create 'main' test directory and move 't' and 'r' there

1 files changed, 7 insertions, 0 deletions

diff --git a/mysql-test/main/enforce_storage_engine_opt.test b/mysql-test/main/enforce_storage_engine_opt.test
new file mode 100644
index 00000000000..7ca7f94d3dc
--- /dev/null
+++ b/mysql-test/main/enforce_storage_engine_opt.test
@@ -0,0 +1,7 @@
+SET SQL_MODE="";
+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;