Still get lock tables error message in 5.0.10

[Markus Popp]

Hi,

I'm still getting the error message

ERROR 1100 (HY000): Table 't1' was not locked with LOCK TABLES

at some tables using a trigger in MySQL 5.0.10, although this problem should already be solved regarding to the ChangeLog.

I've also tried examples from Andrew Gilfrin's www.mysqldevelopment.com site that worked fine.

Here's the concrete example that failed:

DROP TABLE IF EXISTS `mpopp_test`.`t1`;
CREATE TABLE `t1` (
`id` int(11) NOT NULL auto_increment,
`value` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

delimiter //

drop trigger mpopp_test.bi_t1 //
create trigger bi_t1 before insert on t1 for each row
BEGIN
if new.value > 3 and new.value < 7 then
insert into t1 (id, value) values (new.id, new.value);
end if;
END //

delimiter ;

mysql> insert into t1 values (6, 4);
ERROR 1100 (HY000): Table 't1' was not locked with LOCK TABLES

Any ideas what's wrong?

Markus

--
Markus Popp, Web Developer, mysql.com
Oracle Austria