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

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

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 stag

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

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

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

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

2002-03-13 Thread Heikki Tuuri
|| InnoDB free: 700416 kB | ++++--++-+-- ---+--+---++-+-- ---+ ++-- -+ 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: constraint

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 afte

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 ow

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

2002-03-13 Thread Tomasz Korycki
ginal Message- >From: Tomasz Korycki <[EMAIL PROTECTED]> >Newsgroups: mailing.database.mysql >Date: Wednesday, March 13, 2002 1:05 AM >Subject: constraints in InnoDB, or is 3.23.43b _really_ < 4.0.1? > > > > Here is an excerpt from http://www.innodb.com/ibman

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

2002-03-13 Thread Heikki Tuuri
arch 13, 2002 1:05 AM Subject: constraints 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

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 abo