Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?

2002-03-14 Thread Heikki Tuuri
for the online manual and latest news on InnoDB -Original Message- From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, March 14, 2002 8:57 AM Subject: Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1? Tomasz, are you sure you are running 4.0.1

Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?

2002-03-14 Thread Tomasz Korycki
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

Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?

2002-03-14 Thread Tomasz Korycki
At 07:22 2002-03-14, Heikki Tuuri wrote: Tomasz, are you using a non-latin1 character set? No, didn't change the charset. As You can see from my reply to Victoria yesterday, will need to, eventually (for different reasons, though, not books), but right now I am in a proof-of-concept stage:

Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?

2002-03-14 Thread Heikki Tuuri
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

Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?

2002-03-13 Thread Heikki Tuuri
in InnoDB, or is 3.23.43b _really_ 4.0.1? Here is an excerpt from http://www.innodb.com/ibman.html#InnoDB_distros, section 4.2: Starting from version 3.23.43b InnoDB features foreign key constraints. InnoDB is the first MySQL table type which allows you to define foreign key constraints

Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?

2002-03-13 Thread Tomasz Korycki
, or is 3.23.43b _really_ 4.0.1? Here is an excerpt from http://www.innodb.com/ibman.html#InnoDB_distros, section 4.2: Starting from version 3.23.43b InnoDB features foreign key constraints. InnoDB is the first MySQL table type which allows you to define foreign key constraints... Now, I

Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?

2002-03-13 Thread Rick Flower
Tomasz writes: From section 16 of http://www.innodb.com/ibman.html you find detailed information about every InnoDB version. For example, 4.0.1 == 3.23.47. Foreign keys should work in 4.0.1. Hmmm... That's what I read, too. And after several unsuccesful attempts to create my own tables,

Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?

2002-03-13 Thread Tomasz Korycki
At 16:57 2002-03-13, Rick Flower wrote: Tomasz writes: From section 16 of http://www.innodb.com/ibman.html you find detailed information about every InnoDB version. For example, 4.0.1 == 3.23.47. Foreign keys should work in 4.0.1. Hmmm... That's what I read, too. And after several

Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?

2002-03-13 Thread Heikki Tuuri
| ++++--++-+-- ---+--+---++-+-- ---+ ++-- -+ 2 rows in set (0.03 sec) mysql -Original Message- From: Tomasz Korycki [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Date: Thursday, March 14, 2002 6:53 AM Subject: Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1? At 16:57 2002

constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?

2002-03-12 Thread Tomasz Korycki
Here is an excerpt from http://www.innodb.com/ibman.html#InnoDB_distros, section 4.2: Starting from version 3.23.43b InnoDB features foreign key constraints. InnoDB is the first MySQL table type which allows you to define foreign key constraints... Now, I assumed the version number