MySQL Bugs: #12677: CREATE PROCEDURE makes MySQL crash and disconnect

Bug #12677	CREATE PROCEDURE makes MySQL crash and disconnect
Submitted:	19 Aug 2005 14:50	Modified:	6 Oct 2005 17:03
Reporter:	mark pitsilos	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	5.0.10	OS:	Windows (Windows XP)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
Hello,

As of MySQL Server version 5.0.10 I've had a problem
when creating stored procedures.

Specifically, MySQL crashes and disconnects when I
try to create a new stored procedure using CREATE
PROCEDURE in the command line client.

Version 5.0.11 has the same issue.
It works fine with version 5.0.9.

I installed 5.0.10 on top of a 5.0.9 installation, I do not
know if that has got anything to do with it.

Thank you,

Mark Pitsilos

How to repeat:
Create a stored procedure in the command line client.

Could you provide the CREATE PROCEDURE statement you used and which makes the server crash.
Thanks!

I had the same problem upgrading from version 5.0.4 to 5.0.10.  See Bug #12431: mysqld-max.exe crashes when creating stored procedures.  Basically, the only success I had was to uninstall MySQL and then reinstall version 5.0.10 or 5.0.11.

A clean install did the trick.
Thanks guys!

P.S. It would be useful if the MySQL installer
prompted the user to back up their data and
uninstall previous versions before installing,
in order to avoid similar problems in the
future.

Still happens in 5.0.13-rc-nt.  See below.  Problem occurs when you don't use a database before attempting to enter the procedure.

[dappleya@homer ~/bin]$ !!
mysql -h 10.25.80.170 -u root -p******** ;
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 5.0.13-rc-nt

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

mysql> status
--------------
mysql  Ver 14.7 Distrib 4.1.12, for pc-linux-gnu (i686) using readline 4.3

Connection id:          6
Current database:
Current user:           root@192.168.65.45
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.0.13-rc-nt
Protocol version:       10
Connection:             10.25.80.170 via TCP/IP
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
TCP port:               3306
Uptime:                 1 hour 10 min 0 sec

Threads: 1  Questions: 30155  Slow queries: 0  Opens: 0  Flush tables: 1  Open tables: 9  Queries per second avg: 7.180
--------------

mysql> create procedure test(i int)
    -> begin
    -> end
    -> ;
ERROR 2013 (HY000): Lost connection to MySQL server during query

This is duplicate of:
http://bugs.mysql.com/bug.php?id=12431

and the comment done by Mr. Doug is reported and verified at:
http://bugs.mysql.com/bug.php?id=13514