Crash Mysql 5.0 - Stored Procedure

Hi

Sorry for my english :(

Example of stored procedure:


Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.0-alpha-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> DELIMITER |
mysql> DROP PROCEDURE IF EXISTS  crash|
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE PROCEDURE crash()
    -> BEGIN
    ->    DROP TABLE IF EXISTS test.c1;
    ->    CREATE TABLE test.c1 (id INT DEFAULT '0' NOT NULL);
    ->    INSERT INTO test.c1 select 12;
    -> END|
Query OK, 0 rows affected (0.00 sec)

mysql> DELIMITER ;
mysql> call crash();
Query OK, 0 rows affected (0.01 sec)

mysql> call crash();
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>

It's happend on debian linux and windows xp;

Any sugestion ?
If I use select in insert it crash server.


Szymon Okraska

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]