Bug #3436 There is no such thing as \d or "delimiter" on my system :))
Submitted: 10 Apr 2004 11:57 Modified: 14 May 2004 17:59
Reporter: victor vatamanescu-hanga Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.0 OS:Windows (WinXP)
Assigned to: CPU Architecture:Any

[10 Apr 2004 11:57] victor vatamanescu-hanga
Description:
Just a stupid question: I wanted to try a little the stored procedures support in mysql and I just installed mysql 5.0 on my win xp system. Has anyone missed the lack of \d or "delimiter" keywords? Apparently not...

How to repeat:

C:\mysql\bin>mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 19 to server version: 5.0.0-alpha-max-debug

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

mysql> use test5;
Database changed
mysql> delimiter !
    -> create procedure test_sp()
    -> begin
    -> declare v_var int;
ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresp
onds to your MySQL server version for the right syntax to use near 'delimiter !
create procedure test_sp()
begin
declare v_var int'
mysql>

Suggested fix:
Add delimiter keyword as stated in your doc.
[10 Apr 2004 12:28] MySQL Verification Team
D:\start\5.0.0>"d:\arquivos de programas\5.0.0\bin\mysql" --defaults-file="d:\ar
quivos de programas\5.0.0\my.cnf" -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.0-alpha-max-debug

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

mysql> use test;
Database changed
mysql> delimiter |
mysql> create procedure test_sp()
    -> begin
    -> declare v_var int;
    -> end
    -> |
Query OK, 0 rows affected (0.15 sec)

mysql>
[10 Apr 2004 12:40] victor vatamanescu-hanga
Hello Miguel!

As you can see bellow, there is no such thing as \d option on my system. I just installed mysql using the 'typical' profile and this is the result.

mysql> \h

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:
   (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.

Connection id: 19  (Can be used with mysqladmin kill)

mysql>
[10 Apr 2004 13:12] MySQL Verification Team
Hi Victor,

Strange I utilized the package:

mysql-5.0.0a-alpha-win-noinstall.zip

then I need to verify the package with installer.
[10 Apr 2004 13:22] victor vatamanescu-hanga
Hi Miguel!

This is indeed strange. Let me know if I can help you with something for determining whats causing this behaviour (if you need access to this station for instance). 

Regards,
Victor
[11 Apr 2004 1:03] Sergei Golubchik
what is the output from \s command ?
[11 Apr 2004 11:50] victor vatamanescu-hanga
Hello Sergei!

This is the output of the \s command:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\victor>cd \mysql\bin

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

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

mysql> \s
--------------
mysql  Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)

Connection id:          1
Current database:
Current user:           ODBC@localhost
SSL:                    Not in use
Server version:         5.0.0-alpha-max-debug
Protocol version:       10
Connection:             localhost via TCP/IP
Client characterset:    latin1
Server characterset:    latin1
TCP port:               3306
Uptime:                 23 sec

Threads: 1  Questions: 2  Slow queries: 0  Opens: 6  Flush tables: 1  Open table
s: 0  Queries per second avg: 0.087  Memory in use: 8334K  Max memory used: 8342
K
--------------

mysql>

Regards,

Victor
[13 Apr 2004 0:51] Sergei Golubchik
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

See the line:

mysql  Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)

you use mysql command-line client from 4.0.18, it does not know anything about "delimiter" command.
[13 Apr 2004 11:34] victor vatamanescu-hanga
Hello Sergei!

This doesnt really matter. What matters is I installed a packaged software and I found a bug inside (ok, I understand, it's a versioning issue but still, I think more attention should be paid when packaging a release, no matter how alpha would it be).

Best wishes,
Victor
[13 Apr 2004 13:41] MySQL Verification Team
Hi Victor,

What is exactly the package you have installed, because I installed and tested
the packages 5.0.0/5.0.0a with and noinstall without to be able for to repeat
what are you reporting.
[14 Apr 2004 17:59] Sergei Golubchik
> This doesnt really matter. What matters is I installed a packaged
> software and I found a bug inside (ok, I understand, it's a versioning
> issue but still, I think more attention should be paid when packaging a
> release, no matter how alpha would it be).

I'm sorry for this.
I believed that you used mysql.exe that was somehow laying around on your computer, not the one that came with 5.0.0 distribution, that's why my reply.
Now I see that you mean that mysql.exe that corresponds to MySQL 4.0.18 came with MySQL 5.0.0 distribution - then this is definitely a bug in the packaging and alpha status is no excuse, of course.

Could you please double-check that you use mysql.exe that came with the MySQL-5.0 distribution, that there is no other mysql.exe in your system ?
[14 Apr 2004 20:54] Victor Vatamanescu
Hello Sergei!

No, MySQL was not previously installed on my system.

Regards,
Victor
[14 Feb 2005 22:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".