Re: Error handler not being triggered for multi-table updates

[Peter Brawley]

delimiter go
CREATE PROCEDURE handlerdemo()
BEGIN
  DECLARE CONTINUE HANDLER FOR SQLSTATE '23000' select 'hello';
  update t1
  join t2 on t1.s1=t2.s1
  set t1.s1 = t2.s2 ;
END;
go
delimiter ;
call handlerdemo();
+-------+
| hello |
+-------+
| hello |
+-------+
{/code]