Bug #3769 Delimiter Command Missing in 5.0 alpha
Submitted: 15 May 2004 4:00 Modified: 15 May 2004 17:00
Reporter: Paul Tremblett Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S2 (Serious)
Version:5.0 alpha OS:Windows (Windows XP Pro)
Assigned to: CPU Architecture:Any

[15 May 2004 4:00] Paul Tremblett
Description:
Delimiter command not recognized and missing from command list.

How to repeat:
\?
List of all MySQL commands:
   (Commands must appear first on line and end with ';')

help    (\h)    Display this help.
?       (\?)    Synonym for `help'.
clear   (\c)    Clear command.
connect (\r)    Reconnect to the server. Optional arguments are db and host.
ego     (\G)    Send command to mysql server, display result vertically.
exit    (\q)    Exit mysql. Same as quit.
go      (\g)    Send command to mysql server.
notee   (\t)    Don't write into outfile.
print   (\p)    Print current command.
prompt  (\R)    Change your mysql prompt.
quit    (\q)    Quit mysql.
rehash  (\#)    Rebuild completion hash.
source  (\.)    Execute a SQL script file. Takes a file name as an argument.
status  (\s)    Get status information from the server.
tee     (\T)    Set outfile [to_outfile]. Append everything into given outfile.
use     (\u)    Use another database. Takes database name as argument.
[15 May 2004 5:28] MySQL Verification Team
Microsoft Windows XP [versão 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

c:\servers\5.0.0\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.0-alpha-nt

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

mysql> delimiter |
mysql> select version()|
+----------------+
| version()      |
+----------------+
| 5.0.0-alpha-nt |
+----------------+
1 row in set (0.13 sec)

mysql> delimiter ;
mysql> select version();
+----------------+
| version()      |
+----------------+
| 5.0.0-alpha-nt |
+----------------+
1 row in set (0.00 sec)

mysql>
[15 May 2004 6:17] Paul DuBois
It's true that the delimiter command isn't listed in
the 5.0.0 help message. But the command does work.
The omission from the help message has been corrected
and it will appear in 5.0.1.
[15 May 2004 6:30] MySQL Verification Team
New Comment: Paul the version I have on my machine which was installed
using our package is already included:

C:\servers\5.0.0\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.0-alpha-nt

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

mysql> \?

For the complete MySQL Manual online visit:
   http://www.mysql.com/documentation

For info on technical support from MySQL developers visit:
   http://www.mysql.com/support

For info on MySQL books, utilities, consultants, etc. visit:
   http://www.mysql.com/portal

List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
help    (\h)    Display this help.
?       (\?)    Synonym for `help'.
clear   (\c)    Clear command.
connect (\r)    Reconnect to the server. Optional arguments are db and host.
ego     (\G)    Send command to mysql server, display result vertically.
exit    (\q)    Exit mysql. Same as quit.
go      (\g)    Send command to mysql server.
notee   (\t)    Don't write into outfile.
print   (\p)    Print current command.
prompt  (\R)    Change your mysql prompt.
quit    (\q)    Quit mysql.
rehash  (\#)    Rebuild completion hash.
source  (\.)    Execute a SQL script file. Takes a file name as an argument.
status  (\s)    Get status information from the server.
tee     (\T)    Set outfile [to_outfile]. Append everything into given outfile.
use     (\u)    Use another database. Takes database name as argument.
delimiter       (\d)    Set query delimiter.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
For server side help, type 'help all'

mysql>
[15 May 2004 15:11] Paul DuBois
Miguel: I see, you're right. But it's included at the end
of the list of commands (it's out of order), so it's easy
to miss.
[15 May 2004 15:51] Paul Tremblett
When I start the command line client, it says my connection is to version 5.

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.0-alpha-nt

When I try the delimiter command, it does not work but simply displays
->
indicating it's waiting for the delimiter

\s shows:
mysql  Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)

Connection id:          3
Current database:
Current user:           root@localhost
SSL:                    Not in use
Server version:         5.0.0-alpha-nt
Protocol version:       10
Connection:             localhost via TCP/IP
Client characterset:    latin1
Server characterset:    latin1
TCP port:               3306
Uptime:                 6 min 22 sec

Threads: 2  Questions: 46  Slow queries: 0  Opens: 6  Flush tables: 1  Open tabl
es: 0  Queries per second avg: 0.120

Does the following look right for the contents of C:\mysql\bin?
02/11/2004  01:11 AM           155,648 comp-err.exe
02/11/2004  01:58 AM           669,150 cygwinb19.dll
02/11/2004  01:57 AM           282,624 isamchk.exe
12/22/2003  08:27 PM           937,984 libmySQL.dll
02/11/2004  01:57 AM           372,736 myisamchk.exe
02/11/2004  01:57 AM           290,816 myisamlog.exe
02/10/2004  10:26 PM           290,816 myisampack.exe
02/10/2004  10:26 PM           241,664 myisam_ftdump.exe
02/11/2004  01:57 AM           294,980 mysql.exe
02/11/2004  01:57 AM           249,856 mysqladmin.exe
02/11/2004  01:57 AM           258,048 mysqlbinlog.exe
02/11/2004  01:58 AM           334,712 mysqlc.exe
02/11/2004  01:57 AM           245,760 mysqlcheck.exe
12/22/2003  08:27 PM         3,907,584 mysqld-max-nt.exe
12/22/2003  08:27 PM         3,903,488 mysqld-max.exe
12/22/2003  08:27 PM         3,432,448 mysqld-nt.exe
12/22/2003  08:27 PM         3,428,352 mysqld-opt.exe
12/22/2003  08:27 PM         5,226,569 mysqld.exe
02/11/2004  01:58 AM           258,048 mysqldump.exe
02/11/2004  01:58 AM           241,664 mysqlimport.exe
02/11/2004  01:58 AM           241,664 mysqlshow.exe
02/11/2004  01:58 AM            45,056 mysqlwatch.exe
02/10/2004  10:26 PM           172,032 my_print_defaults.exe
02/11/2004  01:58 AM           241,664 pack_isam.exe
02/11/2004  01:58 AM           159,744 perror.exe
02/11/2004  01:58 AM           176,128 replace.exe
02/11/2004  01:58 AM               818 winmysqladmin.cnt
02/11/2004  01:58 AM           936,448 winmysqladmin.exe
06/19/2000  04:52 AM         1,856,816 WINMYSQLADMIN.HLP
              29 File(s)     28,853,317 bytes
[15 May 2004 17:00] Sergei Golubchik
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

duplicate of bug#3436
[15 May 2004 17:50] Paul DuBois
Paul, you're connecting to a MySQL 5 server, but the
client that you're using is too old. This is shown by what
\s displays:

\s shows:
mysql  Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)

Please try it with the mysql client from 5.0.0, not the
4.0.18 client. The delimiter command is a client program
command, not a server command.
[15 May 2004 22:04] Paul Tremblett
Don't know why but the client I was running surely must have been older. I reinstalled 5.0 from scratch and now everything is working fine.

Thanks