summaryrefslogtreecommitdiff
path: root/mysql-test/r/alter_table_trans.result
blob: 6e034e47e760cdc2dbd099ababa2a795f21568f7 (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	Storage engine InnoDB of the table `test`.`t1` doesn't have this option
DROP TABLE t2;