Hi! There was some confusion in the making of the 4.0.0 binaries. The Intel rpm contains InnoDB-.43 which does not support foreign keys, while the source distribution and the Intel .tar.gz binary contains .43b which supports foreign keys. Sorry for the confusion!
Some things are broken in all 4.0.0 versions. Multi-table delete does not work for transactional tables. This has been fixed for 4.0.1. The syntax LOCK IN SHARE MODE does not work either. Regards, Heikki http://www.innodb.com --------------------------------------------------------------------- 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