MySQL Bugs: #14424: Procedure and function named ` ` crashes the server

Bug #14424	Procedure and function named ` ` crashes the server
Submitted:	28 Oct 2005 11:51	Modified:	28 Oct 2005 12:06
Reporter:	sanjeev kumar	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Stored Routines	Severity:	S1 (Critical)
Version:	5.0.13	OS:	Windows (window 2000)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
crash is reproducable 
and same in functions

How to repeat:
folow this query for procedure and same for functions it will crash

delimiter // ;

create procedure ` `()
begin
select 1;
end//

Sorry, but still can't repeat on 5.0.15 on Windows XP:

mysql> delimiter //
mysql> create procedure ` `() begin select 1; end //
Query OK, 0 rows affected (0.02 sec)

mysql> create function ` `() returns integer
    -> begin return 1; end//
Query OK, 0 rows affected (0.00 sec)

mysql> call ` `()//
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.04 sec)

mysql> select ` `()//
+-------+
| ` `() |
+-------+
|     1 |
+-------+
1 row in set (0.01 sec)

mysql> select version()//
+-----------+
| version() |
+-----------+
| 5.0.15-nt |
+-----------+
1 row in set (0.00 sec)

If you can do it on 5.0.13, please, send a comment with all the actions (as I did), as well as the appropriate part of the error log (there may be something useful, if it is a crash). You may upload your error log using the File tab.

I was unable to repeat with 5.0.13/5.0.15/5.0.16

c:\mysql\bin>mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.13-rc-nt

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

mysql> delimiter // ;
mysql>
mysql> create procedure ` `()
    -> begin
    -> select 1;
    -> end//
Query OK, 0 rows affected (0.19 sec)

mysql> call ` `() //
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.03 sec)

Query OK, 0 rows affected (0.03 sec)

c:\mysql\bin>mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.15-nt

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

mysql> delimiter // ;
mysql>
mysql> create procedure ` `()
    -> begin
    -> select 1;
    -> end//
Query OK, 0 rows affected (0.11 sec)

mysql> call ` `() //
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.01 sec)

Query OK, 0 rows affected (0.01 sec)

mysql>

c:\mysql\bin>mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.16-nt

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

mysql> delimiter // ;
mysql>
mysql> create procedure ` `()
    -> begin
    -> select 1;
    -> end//
Query OK, 0 rows affected (0.09 sec)

mysql> call ` `() //
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.02 sec)

Query OK, 0 rows affected (0.02 sec)

mysql>

it's reproducable  with windows 2000

I am using windows 2000

just few minutes before I download latest version 5.0.15 and it's crash with that also

screen shot on crashing

Attachment: mysql crash.jpg (image/pjpeg, text), 49.41 KiB.