Hello.
> Have anyone an hind for, why this trigger Lock the Table Customer ??
I was unable to reproduce this problem on my ALT Linux system, but
I've noticed one server crash during my tests. Please, could you
send a reproducible test case. Use the output of SHOW CREATE TABLE
to provide ex
System Linux SUSE 9.1 with mysql-max-5.0.11-beta-linux-i686.tar.gz
Trigger:
create trigger CustomerHistoryUPD
BEFORE Update
on Customer
For each ROW BEGIN
insert into CustomerHist select * from Customer where FD_ID = OLD.FD_ID;
Update CustomerHist set HistDate = NOW() where FD_ID = OLD.FD_I
System Linux SUSE 9.1 with mysql-max-5.0.11-beta-linux-i686.tar.gz
Trigger:
create trigger CustomerHistoryUPD
BEFORE Update
on Customer
For each ROW BEGIN
insert into CustomerHist select * from Customer where FD_ID = OLD.FD_ID;
Update CustomerHist set HistDate = NOW() where FD_ID = OLD.FD_I