Hi! >With InnoDB tables under 3.23.4x, if you perform an ALTER TABLE on >a table, any foreign key declarations that point to that table fail >to work (they always return a failure). > >Is this a known bug? I don't see it on the InnoDB todo or bug >list, but I seem to remember hearing about it already.
This is a feature (= documented bug). Look at http://www.innodb.com/ibman.html: ... Updated December 13, 2001: Added a note that you should not do an ALTER TABLE to a table which has or is referenced in a foreign key constraint, but use DROP TABLE + CREATE TABLE to modify the schema ... >* Philip Molter >* Texas.net Internet >* http://www.texas.net/ >* [EMAIL PROTECTED] Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php