1204
1204
deallocate prepare stmt1;
1208
--echo # Bug#11815557 60269: MYSQL SHOULD REJECT ATTEMPTS TO CREATE SYSTEM
1209
--echo # TABLES IN INCORRECT ENGINE
1211
--echo # Note: This test assumes that only MyISAM supports system tables.
1212
--echo # If other engines are made to support system tables,
1213
--echo # then this test needs to be updated
1217
--error ER_UNSUPPORTED_ENGINE
1218
ALTER TABLE db ENGINE=innodb;
1219
--error ER_UNSUPPORTED_ENGINE
1220
ALTER TABLE user ENGINE=memory;
1221
--error ER_UNSUPPORTED_ENGINE
1222
ALTER TABLE proc ENGINE=heap;
1223
--error ER_UNSUPPORTED_ENGINE
1224
ALTER TABLE func ENGINE=csv;
1225
--error ER_UNSUPPORTED_ENGINE
1226
ALTER TABLE event ENGINE=merge;
1227
--error ER_UNSUPPORTED_ENGINE
1228
ALTER TABLE servers ENGINE=innodb;
1229
--error ER_UNSUPPORTED_ENGINE
1230
ALTER TABLE procs_priv ENGINE=memory;
1231
--error ER_UNSUPPORTED_ENGINE
1232
ALTER TABLE tables_priv ENGINE=heap;
1233
--error ER_UNSUPPORTED_ENGINE
1234
ALTER TABLE columns_priv ENGINE=csv;
1235
--error ER_UNSUPPORTED_ENGINE
1236
ALTER TABLE time_zone ENGINE=merge;
1237
--error ER_UNSUPPORTED_ENGINE
1238
ALTER TABLE help_topic ENGINE=innodb;
1240
--error ER_UNSUPPORTED_ENGINE
1241
CREATE TABLE db (dummy int) ENGINE=innodb;
1242
--error ER_UNSUPPORTED_ENGINE
1243
CREATE TABLE user (dummy int) ENGINE=memory;
1244
--error ER_UNSUPPORTED_ENGINE
1245
CREATE TABLE proc (dummy int) ENGINE=heap;
1246
--error ER_UNSUPPORTED_ENGINE
1247
CREATE TABLE func (dummy int) ENGINE=csv;
1248
--error ER_UNSUPPORTED_ENGINE
1249
CREATE TABLE event (dummy int) ENGINE=merge;
1250
--error ER_UNSUPPORTED_ENGINE
1251
CREATE TABLE servers (dummy int) ENGINE=innodb;
1252
--error ER_UNSUPPORTED_ENGINE
1253
CREATE TABLE procs_priv (dummy int) ENGINE=memory;
1254
--error ER_UNSUPPORTED_ENGINE
1255
CREATE TABLE tables_priv (dummy int) ENGINE=heap;
1256
--error ER_UNSUPPORTED_ENGINE
1257
CREATE TABLE columns_priv (dummy int) ENGINE=csv;
1258
--error ER_UNSUPPORTED_ENGINE
1259
CREATE TABLE time_zone (dummy int) ENGINE=merge;
1260
--error ER_UNSUPPORTED_ENGINE
1261
CREATE TABLE help_topic (dummy int) ENGINE=innodb;
1263
--echo # End of Bug#11815557