Tomasz, I tested also with mysql-4.0.1 and it worked.
But are you using a non-latin1 character set? If yes, the bug which was fixed in 3.23.49 might cause the problem. Did you compile MySQL yourself? If yes, what compiler? Please download the official MySQL-Max-3.23.49a binary from www.mysql.com and test it with a freshly created InnoDB database. .49a is the recommended stable version. Regards, Heikki -----Original Message----- From: Tomasz Korycki <[EMAIL PROTECTED]> To: Heikki Tuuri <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Thursday, March 14, 2002 5:52 PM Subject: Re: constraints in InnoDB, or is 3.23.43b _really_ < 4.0.1? >At 01:57 2002-03-14, Heikki Tuuri wrote: >>Tomasz, >> >>are you sure you are running 4.0.1? In the rpm of 4.0.0 there were no >>foreign keys. >> >>I tested this on mysql-max-4.0.1, and it worked. > >Well... >[root@flow11 httpd]# mysqladmin -p version >Enter password: >mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i686 >Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB >This software comes with ABSOLUTELY NO WARRANTY. This is free software, >and you are welcome to modify and redistribute it under the GPL license > >Server version 4.0.1-alpha-log >Protocol version 10 >Connection Localhost via UNIX socket >UNIX socket /var/lib/mysql/mysql.sock >Uptime: 9 days 6 hours 12 min 44 sec > >Threads: 1 Questions: 2261 Slow queries: 0 Opens: 108 Flush tables: >1 Open >tables: 14 Queries per second avg: 0.003 > > >>Best regards, >> >>Heikki Tuuri >>Innobase Oy >>--- >------------------------- >sql, query --------------------------------------------------------------------- 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