MySQL Bugs: #10849: DELIMITER used multiple times in Batch fails

Bug #10849	DELIMITER used multiple times in Batch fails
Submitted:	25 May 2005 1:47	Modified:	31 May 2005 17:30
Reporter:	Steve K	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S3 (Non-critical)
Version:	5.0.4	OS:	Windows (Windows 2000)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
When using the Delimiter command multiple times in a Batch file it appears to not finish and does return to a command prompt.

How to repeat:
### Start Here ###
SELECT 'Got Here';
DELIMITER //
SELECT 'Testing First Delimiter'//
DELIMITER ;/
SELECT 'Testing End First Delimiter';
DELIMITER //
SELECT 'Testing Second Delimiter'//
DELIMITER ;/
Select 'Testing End Second Delimiter';
### End here ###

Run the above script will execute correctly, however, it does not return to a prompt.  It could be stuck or just creates the appearance that it is stuck.

Actually the client hangs in both Linux and Windows with
that sequence.
Tested with BK 5.0.7 source.

Your mistake is that after DELIMITER ;/ you should use SELECT 'test';/  not SELECT 'test';
when fixing your script to use the correct delimiter it does not hang.

Of course it's still a bug that it hangs, a simplified test case is:

mysql> delimiter //
mysql> select 1; delimiter //

A duplicate of

http://bugs.mysql.com/bug.php?id=9870
http://bugs.mysql.com/bug.php?id=9992