DELIMITER $$;

CREATE PROCEDURE P1 ()

BEGIN NOT ATOMIC

  IF (SELECT 2) THEN

    SELECT 4;

  END IF ;

END;

$$

DELIMITER ;$$

select name,db,body from mysql.proc where name = "P1";

update mysql.proc set body_utf8="BEGIN NOT ATOMIC

IF (SELECT 2) OR foo = 3 THEN

SELECT 4;

END IF ;

END", body="BEGIN NOT ATOMIC

IF (SELECT 2) OR foo = 3 THEN

SELECT 4;

END IF ;

END"where name = "P1";

show create procedure P1;

drop procedure P1;

mysqltest: At line 25: query 'show create procedure P1' failed: 1457: Failed to load routine test.P1. The table mysql.proc is missing, corrupt, or contains bad data (internal code -6)