--source include/have_innodb.inc

CREATE TABLE t1 (id INT, f VARCHAR(64), PRIMARY KEY (id DESC), FULLTEXT ft(f)) ENGINE=InnoDB;

INSERT INTO t1 VALUES (1,'foo'),(2,'bar');

DELETE FROM t1 WHERE id = 2;

ALTER TABLE t1 DROP INDEX ft;

ALTER TABLE t1 ADD FULLTEXT INDEX ft (f);

INSERT INTO t1 values (3,'innodb ft search');

ANALYZE TABLE t1;

SELECT * FROM t1 WHERE MATCH(f) AGAINST("+innodb +search" IN BOOLEAN MODE);

DROP TABLE t1;

SELECT * FROM t1 WHERE MATCH(f) AGAINST("+innodb +search" IN BOOLEAN MODE);

id	f

SELECT * FROM t1 WHERE MATCH(f) AGAINST("+innodb +search" IN BOOLEAN MODE);

id	f

3	innodb ft search