2 messages in com.mysql.lists.mysqlRe: Foreign keys
FromSent OnAttachments
Pierre Radulescu15 Jan 2002 09:52 
Heikki Tuuri15 Jan 2002 10:10 
Subject:Re: Foreign keys
From:Heikki Tuuri (Heik@innodb.com)
Date:01/15/2002 10:10:13 AM
List:com.mysql.lists.mysql

Pierre,

I tested this with versions 3.23.46 and .48 on Linux and they worked ok:

mysql> CREATE TABLE FIRST (NAME VARCHAR(15), COD VARCHAR(10) NOT NULL, PRIMARY -> KEY(COD)) TYPE=INNODB; Query OK, 0 rows affected (0.02 sec)

mysql> CREATE TABLE SECOND (ID INT NOT NULL, F_COD VARCHAR(10), PRIMARY -> KEY(ID), INDEX PAR_IND(F_COD), FOREIGN KEY(F_COD) REFERENCES FIRST(COD)) -> TYPE=INNODB; Query OK, 0 rows affected (0.04 sec)

mysql>

But on Windows there was bug in database case in some earlier versions. See http://www.innodb.com/bugfixes.html

Are you running on Windows? Check also with SHOW TABLE STATUS that the table FIRST was really created in your test.

Best regards,

Heikki Tuuri Innobase Oy

--- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB

Pierre Radulescu wrote in message ...

Hi,

I am trying two create two innodb tables:

1. CREATE TABLE FIRST (NAME VARCHAR(15), COD VARCHAR(10) NOT NULL, PRIMARY KEY(COD)) TYPE=INNODB;

2. CREATE TABLE SECOND (ID INT NOT NULL, F_COD VARCHAR(10), PRIMARY KEY(ID), INDEX PAR_IND(F_COD), FOREIGN KEY(F_COD) REFERENCES FIRST(COD)) TYPE=INNODB;

The second table cannot be created (errno: 150)

Thanks in advance for help!

Pierre