MySQL Bugs: #9886: Mysql client hangs if delimiter is not used in an intermediate step

Bug #9886	Mysql client hangs if delimiter is not used in an intermediate step
Submitted:	14 Apr 2005 5:57	Modified:	28 May 2005 0:39
Reporter:	Disha	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.3/5.0.5 BK	OS:	Windows (Windows 2003)
Assigned to:	Jim Winstead	CPU Architecture:	Any

Description:
Description:

This bug might be similar to 9870. However, the repro steps we have are different and hence filing this. Moreover, in 9870, a delimiter is used and hence the hang. In this bug, the delimiter is not used, and therefore might be a different issue.
 
The hanged client's status is 'Sleep', when we checked from another client.

How to repeat:

1. delimiter //
2. Set @a=1;
    Set @b=1
    Set @c=1//

ACTUAL RESULT:
Client hangs.

EXPECTED RESULT:
Syntax error. ERROR 1064 , should be displayed

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.5-beta-nt

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

mysql> delimiter //
mysql> Set @a=1;
    ->     Set @b=1
    ->     Set @c=1//
Query OK, 0 rows affected (0.03 sec)

Aborted

c:\mysql\bin>

I wasn't able to repeat this on Linux/x86_64.