Hello.
See: http://dev.mysql.com/doc/mysql/en/temporary-table-problems.html http://bugs.mysql.com/bug.php?id=10105 Jason Pyeron <[EMAIL PROTECTED]> wrote: > any ideas on this? google has not helped. > > can temp tables be innodb? can they have fk? > > mysql> > mysql> create temporary table bvolsetparents > -> ( > -> volset int not null, > -> ancestor int not null, > -> primary key (volset,ancestor), > -> foreign key (volset) REFERENCES bvolset(id), > -> foreign key (ancestor) references bvolset(id) > -> ); > ERROR 1005: Can't create table > 'c:\docume~1\admini~1\locals~1\temp\#sql640_41_0.frm' (errno: 150) > mysql> > mysql> create table bvolsetparents > -> ( > -> volset int not null, > -> ancestor int not null, > -> primary key (volset,ancestor), > -> foreign key (volset) REFERENCES bvolset(id), > -> foreign key (ancestor) references bvolset(id) > -> ); > Query OK, 0 rows affected (0.11 sec) > > mysql> > mysql> drop table bvolsetparents; > Query OK, 0 rows affected (0.07 sec) > > mysql> create temporary table bvolsetparents > -> ( > -> volset int not null, > -> ancestor int not null, > -> primary key (volset,ancestor), > -> foreign key (volset) REFERENCES bvolset(id), > -> foreign key (ancestor) references bvolset(id) > -> ) engine=innodb; > ERROR 1005: Can't create table > 'c:\docume~1\admini~1\locals~1\temp\#sql640_41_1.frm' (errno: 150) > mysql> create temporary table bvolsetparents > -> (id int); > Query OK, 0 rows affected (0.48 sec) > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]