Bug #14421 Crash on call of procedure with a space in name

• Submitted: 28 Oct 2005 11:04
• Modified: 28 Oct 2005 11:10
• Reporter: sanjeev kumar
• Status: Can't repeat
• Category: MySQL Server: Stored Routines
• Severity: S2 (Serious)
• Version: mysql 5.0.13
• OS: Windows (window 2000)
• CPU Architecture: Any

[28 Oct 2005 11:04] sanjeev kumar

Description:
crash bug on creating procedure give space in procedure name

How to repeat:
when we create the procedure with giving space in  name of procedure.query will be execute.when we call the procedure it's crashing

[28 Oct 2005 11:10] Valeriy Kravchuk

Thank you for a problem report. I've tried to repeat it on 5.0.15-nt, but everything works as expected:

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

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

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

Query OK, 0 rows affected (0.05 sec)

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

Query OK, 0 rows affected (0.04 sec)

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

So, please, try to use 5.0.15. 

Or just provide a complete example, if I misunderstood your problem.

[28 Oct 2005 11:16] Valeriy Kravchuk

Changed synopsis to a more reasonable one.

[28 Oct 2005 11:46] sanjeev kumar

execute this query it will crash
delimiter // ;

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