Bug #1032 store procedure with begin and end block does not work
Submitted: 11 Aug 2003 11:02 Modified: 21 Aug 2003 7:05
Reporter: Anthony Tam Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0 OS:Solaris (Solaris)
Assigned to: Per-Erik Martin CPU Architecture:Any

[11 Aug 2003 11:02] Anthony Tam 
Description:
Store procedure in 5.0 (development) tree does not work with begin and end block.  The test suite in mysql-5.0/mysql-test/t/sp.test also fails.

How to repeat:
This error can be reproduced easily as shown:

mysql> create procedure locset(x char(16), y int)
    -> begin
    -> declare z1, z2 int;
ERROR 1064 (42000): You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
mysql> Aborted
[21 Aug 2003 7:05] Per-Erik Martin 
The test sp works for me (as do sp-error).

The suggested "How to repeat" is not repeatable if one sets a different delimiter
in the client (which is necessary with multi statement procedures; see sp.test).
A popular choice is "|" (the command "delimiter |;").
The error shown in the "How to repeat" occurs when the default delimiter ";" is
used.