Bug #9879 delimiter command discrepancy (4.1 vs. 5.0, mysql vs. mysqltest)
Submitted: 13 Apr 2005 18:19 Modified: 20 Jun 2005 22:01
Reporter: Konstantin Osipov (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.0 OS:
Assigned to: Magnus Blåudd CPU Architecture:Any

[13 Apr 2005 18:19] Konstantin Osipov 
Description:
Delimiter coomand does not work in the same way in 4.1 and 5.0, mysql and mysqltest.
For example, this works fine in 4.1 and in mysqltest (as of 5.0): 
mysql> delimiter :;
mysql> show tables:
+----------------+
| Tables_in_test |
+----------------+
| V_T1           |
| t2             |
+----------------+
2 rows in set (0.01 sec)

But doesn't work with mysql command line client of 5.0, where delimiter :; sets delimiter to ":;", not to ":".

This discrepancy should be removed, and preferrably, the old behaviour should be restored.

How to repeat:
See description.
[17 May 2005 19:14] 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/24987
[26 May 2005 9:28] Magnus Blåudd 
Pushed to 5.0.7
[20 Jun 2005 22:01] Mike Hillyer 
Documented in 5.0.7 changelog.