MySQL Bugs: #10346: Problem with delimiter \\

Bug #10346	Problem with delimiter \\
Submitted:	3 May 2005 19:16	Modified:	24 May 2005 18:51
Reporter:	Guillaume Lebur	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S2 (Serious)
Version:	5.0.4-beta-nt	OS:	Windows (Windows XP SP2)
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
Stored procedure creation causes an error when the delimiter is \\ but not with other delimiters.

Also, MySQL Query Browser accepts neither \\ nor any other delimiter (I'll  submit another bug report for that).

How to repeat:
mysql> status
--------------
mysql  Ver 14.9 Distrib 5.0.4-beta, for Win32 (ia32)

mysql> delimiter \\
mysql> create procedure tutoriel.test ()
    -> BEGIN
    -> DECLARE a INT;
    -> SET a = 0;
    -> END\\
ERROR:
Unknown command '\\'.
    -> \\
ERROR:
Unknown command '\\'.
    -> Aborted

**********************************************************

mysql> delimiter :
mysql> create procedure tutoriel.TEST()
    -> BEGIN
    -> DECLARE a INT;
    -> SET a = 0;
    -> END:
Query OK, 0 rows affected (0.00 sec)

The backslash ('\') is the escape character for MySQL. I was unable for to
find in our Manual instructions for to avoid the use of \\ as delimiter.

Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).