summaryrefslogtreecommitdiff
path: root/mysql-test/r/alter_table_trans.result
blob: 3dd5c00d3d8b41d076ac851a97e3d8f5f93f32db (plain)
1
2
3
4
5
6
drop table if exists t1,t2;
CREATE TABLE t1 (a INT, INDEX(a)) engine=innodb;
ALTER TABLE t1 RENAME TO t2, DISABLE KEYS;
Warnings:
Note	1031	Table storage engine for 't1' doesn't have this option
DROP TABLE t2;