ERROR 1005 at line 38: Can't create table '.\test\#sql-748_17.frm' (errno: 150)

[Morten Gulbrandsen]

Hello, 

please help me solve this problem,
ON DELETE SET DEFAULT  should be supported, 


======


USE test;

DROP TABLE IF EXISTS relvar_a;

CREATE TABLE  relvar_a
(
#PK
SSN    CHAR(9)   NOT NULL,
#FK
SUPERSSN  CHAR(9),
DNO    INT         NOT NULL  DEFAULT 1,

PRIMARY KEY (SSN),
INDEX (SUPERSSN),
INDEX (DNO)
)ENGINE = INNODB;

SHOW WARNINGS;

DESCRIBE relvar_a;

DROP TABLE IF EXISTS relvar_b;

CREATE TABLE relvar_b
(
#PK
DNUMBER   INT    NOT NULL,
#FK
MGRSSN   CHAR(9)   NOT NULL DEFAULT '888665555',

PRIMARY KEY (DNUMBER),
INDEX(MGRSSN)
)ENGINE = INNODB;

SHOW INNODB STATUS;

 
ALTER TABLE relvar_a        #  won't do  line 38
ADD FOREIGN KEY (DNO)       REFERENCES relvar_b(DNUMBER)
ON DELETE SET DEFAULT       #  is supported in 5.0.0 alpha
ON UPDATE CASCADE;

=========

ERROR 1005 at line 38: Can't create table '.\test\#sql-748_17.frm' (errno: 150)
Bye

mysql> select version();
+--------------------+
| version()          |
+--------------------+
| 5.0.0-alpha-max-nt |
+--------------------+
1 row in set (0.11 sec)

Microsoft Windows 2000 [Version 5.00.2195]


What can I do, please ?

Yours Sincerely

Morten Gulbrandsen