summaryrefslogtreecommitdiff
path: root/mysql-test/t/enforce_storage_engine_opt.test
blob: 82cc4117cdb99e5fafa2f17bbed9a1cd56d34765 (plain)
1
2
3
4
5
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;