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

2004-01-08 Thread Morten Gulbrandsen
LTER 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: 1

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

2004-01-08 Thread Morten Gulbrandsen
r_b(DNUMBER) ON DELETE SET DEFAULT 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 | +---