Re: getting error 1418 (HY0000)
This happens if you have logging (replication) enabled. Either do as the error message suggest, set the variable mentioned, or simply declare
your routines as deterministic (if they are, which is likely):
delimiter //
Create procedure test (out p1 int)
deterministic
begin
select count(*) into p1 from tbl_test;
end //
pem, Senior Software Dev., MySQL AB
Subject
Views
Written By
Posted
6952
June 17, 2005 07:55AM
5483
June 17, 2005 09:27AM
Re: getting error 1418 (HY0000)
6398
June 20, 2005 05:16AM
3841
July 02, 2005 08:07PM
3983
July 05, 2005 03:44AM
9820
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.