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/[email protected]