Bug #26897 delimiter can't handle the delimiter string set by mysqldump

• Submitted: 7 Mar 2007 5:04
• Modified: 7 Mar 2007 7:15
• Reporter: Tobias Asplund
• Status: Can't repeat
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.1.16
• OS: Linux (CentOS)
• CPU Architecture: Any

[7 Mar 2007 5:04] Tobias Asplund

Description:
The mysqldump program uses the delimiter sequence ";;" for most of it's operations with triggers and stored procedures.

However, the server cannot handle that in the 5.1 tree.

How to repeat:
mysql> SELECT VERSION();
+-----------------+
| VERSION()       |
+-----------------+
| 5.1.16-beta-log |
+-----------------+
1 row in set (0.01 sec)

mysql> DELIMITER ;;
ERROR: 
DELIMITER must be followed by a 'delimiter' character or string
ERROR: 
No query specified

Suggested fix:
restore old functionality.

[7 Mar 2007 7:15] Sveta Smirnova

Thank you for the report.

I can not repeat it with current development tree:

$mysql51
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.17-beta-debug Source distribution

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

mysql> delimiter ;;
mysql> select 1;
    -> ;;
+---+
| 1 |
+---+
| 1 | 
+---+
1 row in set (0.01 sec)

mysql>