INSTALL SONAME 'ha_mroonga';
CREATE database db;
USE db;
CREATE TABLE table1(pk INT AUTO_INCREMENT, a INT, b INT, c INT, d INT, PRIMARY KEY (pk), KEY (a)) ENGINE=Mroonga;
INSERT INTO table1(a, b) VALUES (0,100),(200,2000);
INSERT INTO table1(c, d) VALUES (0,100),(200,2000);
CREATE TRIGGER tr1 AFTER UPDATE ON table1 FOR EACH ROW SET @a= 100;
UPDATE table1 SET b = 3 WHERE a = 0;