MySQL Bugs: #38423: ERROR 1064 using delimiter on mysql/solaris/sparc

Bug #38423	ERROR 1064 using delimiter on mysql/solaris/sparc
Submitted:	29 Jul 2008 6:29	Modified:	29 Jul 2008 9:53
Reporter:	Adina Kalin	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S2 (Serious)
Version:	5.1.26-rc	OS:	Solaris
Assigned to:		CPU Architecture:	Any

Description:
I installed mysql 5.1.26-rc on a Solaris/SPARC machine.
I'm trying to create a procedure, but I'm failing from the beginning when I try to change the delimiter :

mysql> delimiter %%
    -> create procedure Load_Data(r_value int)
    -> begin
    -> declare v_count int default 0;
ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delimiter %%
create procedure Load_Data(r_value int)
begin
decla

How to repeat:
Install mysql from mysql-5.1.26-rc-solaris-sparc.tar on a v440 server running
solaris 10 u5.
Start the client : mysql -uroot -p
then from the command line, run the sequence from the bug description.

Thank you for a problem report. 

Please, make sure you entered "delimiter %%" on a row by itself and hit Enter after that. You should get "mysql>" prompt before trying to enter further statements. Like this:

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -uroot -proot -P3310 test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.26-rc-community MySQL Community Server (GPL)

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

mysql> delimiter %%
mysql>

The problem is that I don't get the mysql prompt.
-bash-3.00$ uname -a 
SunOS mdev440-1 5.10 Generic_127127-11 sun4u sparc SUNW,Sun-Fire-V440
-bash-3.00$ mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11 to server version: 5.1.26-rc

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

mysql> delimiter %%
    ->

OK. What exact binaries you had installed? Please, send URL used to download. Send also the results of:

mysql --version

-bash-3.00$ mysql --version
mysql  Ver 12.22 Distrib 4.0.24, for sun-solaris2.10 (sparc)

For download I used :
http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.26-rc-solaris10-sparc.tar.gz/from/p...

This is the problem:

mysql  Ver 12.22 Distrib 4.0.24, for sun-solaris2.10 (sparc)

4.0.24 client does NOT know DELIMITER command. Please, check/set your PATH environment variable so that mysql from 5.x is used.

thanks.
The problem was the PATH: /usr/bin was before mysql binary path.
it works now.