CREATE TABLE bug44571 (foo INT) ENGINE=InnoDB; ALTER TABLE bug44571 CHANGE foo bar INT; ALTER TABLE bug44571 ADD INDEX bug44571b (foo); ERROR 42000: Key column 'foo' doesn't exist in table ALTER TABLE bug44571 ADD INDEX bug44571c (bar); DROP INDEX bug44571c ON bug44571; CREATE INDEX bug44571c ON bug44571 (bar); DROP TABLE bug44571;