Hi, Markus!
I just tried your example in 5.0.10-beta using both MyISAM and InnoDB tables and got the same problem.
The issue seems to be that you're trying to insert into the same table that the trigger is defined on, and what you actually want to do is something like this:
IF NEW.value <= 2 AND NEW.value >= 8 THEN
ABANDON...
which, unfortunately, MySQL doesn't support at this time. :(
You might in the meantime try something like what's suggested here:
http://forums.mysql.com/read.php?99,22523 - I know it's not very "clean", but Riccardo's solution does seem to work for now. I'm going to talk to some people here about the ABANDON and error-handling issues and see if I can find out what's being planned for these.
Jon Stephens
MySQL Documentation Team @ Oracle
MySQL Dev Zone
MySQL Server Documentation
Oracle