Bug #10879 trigger when update will occur fatal error
Submitted: 26 May 2005 8:31 Modified: 8 Oct 2005 1:44
Reporter: jordan kuan Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:GA OS:Windows (XP)
Assigned to: CPU Architecture:Any

[26 May 2005 8:31] jordan kuan 
Description:
I had encounted that made me crazy....
I am using mysql-5.0.4-beta-win32.exe
I created TABLE a, and it has 3 coloums, that is 
ratio,
click_through_time,
total_search_time
when I create a trigger and doing update.

CREATE TRIGGER in_a_ratio
before UPDATE ON a
FOR EACH ROW
BEGIN
SET @ratio = OLD.click_through_time/OLD.total_search_time;
END;

after update the sever will be down immediately. 
if you have a solution, please send e-mail to me
jordan.kuan@gmail.com
thank you very much for your kindly attention.

How to repeat:
trigger when update will occur fatal error
[4 Oct 2005 21:57] Hartmut Holzgraefe 
can you please check whether this still happens with current MySQL 5.0.13 
and add a full reproducing example if so?
[5 Oct 2005 1:36] jordan kuan 
I don't know whether that will occur in 5.0.13, but I have been waiting the response so long. And now that problem is useless. I had completed the project long time ago.
[8 Oct 2005 1:44] MySQL Verification Team 
I was unable to repeat this issue with current 5.0.15-rc Windows server.