Bug #10402 TRIGGERS NOT FIRING.AFTER INSERT..BEFORE INSERT

• Submitted: 6 May 2005 6:19
• Modified: 6 May 2005 10:32
• Reporter: raj k
• Status: Closed
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: mysql 5.0.3 beta
• OS: Windows (windows)
• CPU Architecture: Any

[6 May 2005 6:19] raj k

Description:
CREATE TRIGGER new AFTER INSERT ON table1 FOR EACH ROW
BEGIN
   DECLARE DAY1  VARCHAR(8);
   DECLARE i DOUBLE;  
SET I = 1;
  WHILE(I <= 7) DO
  
  IF I=1 THEN
    SET DAY1 ='MON';
  END IF;

  IF I=2 THEN
   SET  DAY1 ='TUE';
  END IF;

  IF I=3 THEN
   SET  DAY1 ='WED';
  END IF;

  IF I=4 THEN
    SET DAY1 ='THU';
  END IF;

  IF I=5 THEN
   SET DAY1 ='FRI';
  END IF;

  IF I=6 THEN
    SET DAY1 ='SAT';
  END IF;

  IF I=7 THEN
    SET DAY1 ='SUN';
  END IF;

   INSERT INTO table2 (daay,name)
       ) VALUES(day1,raj);
  SET I = I+1;
END WHILE;

END ;
this trigger not at all working...

How to repeat:
try to fix it

[6 May 2005 10:32] Geert Vanderkelen

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

Hi,

Check the note on the following URL:
http://dev.mysql.com/doc/mysql/en/create-trigger.html

Regards,

Geert