MySQL Forums
Forum List  »  Stored Procedures

getting error 1418 (HY0000)
Posted by: development
Date: June 17, 2005 07:55AM

Dear all,

I've recently installed MySQL 5.0.7 in linux machine. I was testing the major feature of 5.0 stored procedure.

I've written very simple procedure for testing

delimiter //
Create procedure test (out p1 int)
begin
select count(*) into p1 from tbl_test;
end //

but it is showing
Error 1418 (HY0000) This routine is declared to be non-deterministic and to modify data and binary logging is enabled (you *might* want to use the less safe log_bin_trust_routine_creators variable)

can anyone explain me what exactly is happening? what should i do for succefully execution of the query?

Thanks in advance

Rushik.

Options: ReplyQuote


Subject
Views
Written By
Posted
getting error 1418 (HY0000)
6931
June 17, 2005 07:55AM
5473
June 17, 2005 09:27AM
3833
July 02, 2005 08:07PM
9810
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.