summaryrefslogtreecommitdiff
path: root/mysql-test/main/warnings_engine_disabled.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/warnings_engine_disabled.result')
-rw-r--r--mysql-test/main/warnings_engine_disabled.result16
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/main/warnings_engine_disabled.result b/mysql-test/main/warnings_engine_disabled.result
new file mode 100644
index 00000000000..d9e490ba18f
--- /dev/null
+++ b/mysql-test/main/warnings_engine_disabled.result
@@ -0,0 +1,16 @@
+set sql_mode="";
+create table t1 (id int) engine=InnoDB;
+Warnings:
+Warning 1286 Unknown storage engine 'InnoDB'
+Warning 1266 Using storage engine MyISAM for table 't1'
+alter table t1 engine=InnoDB;
+Warnings:
+Warning 1286 Unknown storage engine 'InnoDB'
+drop table t1;
+set sql_mode=default;
+SELECT ENGINE, SUPPORT FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='InnoDB';
+ENGINE SUPPORT
+InnoDB NO
+SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME='InnoDB';
+PLUGIN_NAME PLUGIN_STATUS
+InnoDB DISABLED