CREATE TABLE th1(a TEXT,FULLTEXT INDEX(a)) ENGINE=MyISAM;
CREATE TABLE th2(a TEXT,FULLTEXT INDEX(a)) ENGINE=MyISAM;
CREATE TRIGGER trg_bi BEFORE INSERT ON th1
FOR EACH ROW
BEGIN
INSERT IGNORE INTO th2 SELECT 1 FROM th1
WHERE MATCH(a) AGAINST ( 'test'   IN BOOLEAN MODE);
END $
SET @@debug='+d,simulate_bug18831513';
INSERT INTO th1 VALUES(1);
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MODE)' at line 2
SET @@debug='-d,simulate_bug18831513';
INSERT INTO th1 VALUES(1);
DROP TRIGGER trg_bi;
DROP TABLE th1;
DROP TABLE th2;