mysql Error 1291: failed to create function simpleproc

Hi,

i've tried creating a simple stored procedure as per
the manual on mysql-5.0.0-alpha-standard and i get the
following error; i've tried this on linux
(redhat-9.0) and freebsd 4.1. Any help would be much
appreciated!

mysql> delimiter //
mysql> CREATE PROCEDURE simpleproc (OUT param1 INT)
-> BEGIN
-> SELECT COUNT(*) INTO param1 FROM test_db.foo;
-> END
-> //
ERROR 1291 (HY000): Failed to CREATE PROCEDURE
simpleproc



mysql> select count(*) from test_db.foo;
-> //
+----------+
| count(*) |
+----------+
| 48616 |
+----------+
1 row in set (0.02 sec)


i get same error when i try to create a function.

-VY




__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org