re: Foreign keys in InnoDB tables

2002-10-22 Thread Victoria Reznichenko
Christos, Monday, October 21, 2002, 5:46:07 AM, you wrote: CS Hello I am a brand new user of MySql, and have some questions about CS using InnoDB tables. CS I noticed in the manual that you can only specify CS - ON DELETE SET NULL CS Or CS - ON DELETE CASCADE CS What is the default

Re: Re: Foreign keys in InnoDB tables

2002-02-16 Thread Heikki Tuuri
Martin, -Original Message- From: Martin Bratbo [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Date: Saturday, February 16, 2002 4:46 PM Subject: Re: Re: Foreign keys in InnoDB tables Heikki here is the statements that i cant get to work: first I create one innoDB table: fk1

Re: Foreign keys in InnoDB tables

2002-02-10 Thread Heikki Tuuri
Martin, there is a bug in 4.0.1 which can make a foreign key definition to fail in an assertion failure in dict0crea.c, if you have set default-character-set to something else than latin1 in my.cnf. Harald Fuchs reported the bug on this mailing list a couple of days ago, and the bug is now