MySQL Forums
Forum List  »  Stored Procedures

Re: getting error 1418 (HY0000)
Posted by: Andrew Gilfrin
Date: June 17, 2005 09:27AM

The deterministic part is related to the fact the procedure can return a different value each time (this makes in non-deterministic). This is realted to the way the optimizer deals with it so isn't an error so not sure why it's kicking up a fuss.

What it might be worth doing is to put in an intermediate variable in the select so that it's not writing directly into the parameter like so.

delimiter //
Create procedure test (out p1 int)
begin

decalare v_count int;

select count(*) into v_count from tbl_test;

set p1 = v_count;

end //

See if it works and if it does then raise a bug for the initial issue.

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information

Options: ReplyQuote


Subject
Views
Written By
Posted
6919
June 17, 2005 07:55AM
Re: getting error 1418 (HY0000)
5468
June 17, 2005 09:27AM
3830
July 02, 2005 08:07PM
9808
October 13, 2005 11:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.