Bug #8922 The deilimeter cannot be reset after it is set as word 'delimiter'
Submitted: 3 Mar 2005 14:49 Modified: 8 Mar 2005 15:12
Reporter: Disha Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.2 OS:Any (All)
Assigned to: Jani Tolonen CPU Architecture:Any

[3 Mar 2005 14:49] Disha
Description:
When we specify a delimiter as word 'delimiter' and then again try to reset it back to some other character, it fails.

How to repeat:
Repro Steps   
 1. Delimiter  delimiter 
 2. Show tables delimiter
 3. delimiter //
		 			
Expected Results : It should disallow setting a delimiter as word 'delimiter' because it cannot be reset later
   
Actual Results : The deilimeter cannot be reset after it is set as word 'delimiter' and after Step 3 the following error is displayed: 

ERROR: No query specified
[3 Mar 2005 15:15] Jorge del Conde
Verified using 5.0.3 from our bk tree

Thanks for your bug report
[8 Mar 2005 15:12] Jani Tolonen
Fixed in 5.0 source. mysql client will now regard delimiter as a command
instead of a delimiter, if delimiter value is "delimiter" and it is in the beginning
of the command line.

Please note that even without the fix, one can reset the value of delimiter
with the short command \d.
[8 Mar 2005 16:15] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/22777