MySQL Bugs: #4483: Error with stored procedure in Mysql 5.0

Bug #4483	Error with stored procedure in Mysql 5.0
Submitted:	9 Jul 2004 12:20	Modified:	17 Jul 2004 12:58
Reporter:	yang bowen	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0 alpha	OS:	Windows (Win2k)
Assigned to:		CPU Architecture:	Any

Description:
Hello

I've installed MySQL 5 and I seem to have a couple of strange problems with it (or it does with me).

After installing into a clean environment I created a new server (rm_development) in the Control Center, and then created a new database.

The first problem/query is after having created a table ('mytable')and inserted a row, when selecting from that table within CC I get:

1 row in set (0.01) sec
[RM_SERVER] ERROR 1146: Table 'rm_development.1' doesn't exist

Any ideas why it's looking for the table .1?
 
Secondly when I try and create a stored procedure :

create procedure sp_test()
BEGIN
select count(*) from mytable;
END
 
I get the following error message:
 
[RM_SERVER] 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 'END' at line 1 

How to repeat:
none

Same error on Linux Suse 9.0.

There are two issues there wich are not bugs:

1) MySQL CC does not not support MySQL 5.0 yet

2) The answer of your second question is in the manual. You need to use different delimiter when creating stored procedures.