As reported by J.M., there is a problem when copying databases with constraints in some cases. For instance, trying to duplicate the sakila database gives this message:
ALTER TABLE address
ADD CONSTRAINT fk_address_city FOREIGN KEY (city_id) REFERENCES city (city_id) ON UPDATE CASCADE;
8cf74b688d882a9545a651498664de912c7fb659 is the first bad commit.
Hi,
"ALTER TABLE address
ADD CONSTRAINT fk_address_city FOREIGN KEY (city_id) REFERENCES city (city_id) ON UPDATE CASCADE;"
This is not an error message. Isn't that ?
I believe this is the error.
"#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.
actor
MODIFYactor_id
smallint( 5 ) unsigned NOT NULL AUTO_INCREMENT ' at line 1"Can you confirm ?
I am able to reproduce this in 4.2.1, but it has been fixed in 4.2.2 along with another bug fix. I'm marking this fixed for 4.2.3 as 4.2.2 has already been released.