TEMPORARY + InnoDB + select coun(*) + Bye = mysqld crash with signal 11.

2001-04-25 Thread BAUMEISTER Alexandre
Heikki, Mysql-3.23.36, Solaris 2.8. My mysqld crashes when I create a TEMPORARY InnoDB table from the console if I do a SELECT COUNT(*) before exiting from the console. No problem with MyISAM tables, no problem with no TEMPORARY table. mysql CREATE TEMPORARY TABLE mybuffer ( id int

Re: TEMPORARY + InnoDB + select coun(*) + Bye = mysqld crash with signal 11.

2001-04-25 Thread Heikki Tuuri
Alex, MySQL obviously tries to drop the table when you exit from the mysql client, since the table is temporary. I have not tested TEMPORARY tables. I just tried on prerelease .38 and it does not work in that version either. I will fix it in .38 if Monty has not yet put out it. Regards,