Konstantin Osipov (![[info]](http://l-stat.livejournal.com/img/userinfo.gif){kind=small} kostja_osipov) wrote,@ 2007-07-11 02:38:00 |
|
SHOW CREATE TRIGGGER, Bug#26141, Bug#24989
SHOW CREATE TRIGGER was added two weeks ago into 5.1 branch - it turned out there is no way to do mysqlbackup without this statement when the trigger is defined in a character set that is not UTF-8.
And while we are on triggers, some most painful locking bugs with triggers are being fixed too (in 5.0) - Bug#26141 mixing table types in trigger causes full table lock on innodb table and Bug#24989 'Explicit or implicit commit' error/server crash with concurrent transactions. With these two fixes in, triggers should actually become usable with InnoDB.
SHOW CREATE TRIGGER was added two weeks ago into 5.1 branch - it turned out there is no way to do mysqlbackup without this statement when the trigger is defined in a character set that is not UTF-8.
And while we are on triggers, some most painful locking bugs with triggers are being fixed too (in 5.0) - Bug#26141 mixing table types in trigger causes full table lock on innodb table and Bug#24989 'Explicit or implicit commit' error/server crash with concurrent transactions. With these two fixes in, triggers should actually become usable with InnoDB.
