1INSTALL PLUGIN simple_parser SONAME 'mypluglib.so';
2CREATE TABLE articles (
3id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
4title VARCHAR(200),
5body TEXT,
6FULLTEXT (title) WITH PARSER simple_parser
7) ENGINE=MyISAM;
8ALTER TABLE articles ENGINE=InnoDB;
9ERROR HY000: Cannot CREATE FULLTEXT INDEX WITH PARSER on InnoDB table
10DROP TABLE articles;
11CREATE TABLE articles (
12id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
13title VARCHAR(200),
14body TEXT,
15FULLTEXT (title) WITH PARSER simple_parser
16) ENGINE=InnoDB;
17ERROR HY000: Cannot CREATE FULLTEXT INDEX WITH PARSER on InnoDB table
18CREATE TABLE articles (
19id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
20title VARCHAR(200),
21body TEXT,
22FULLTEXT (title)
23) ENGINE=InnoDB;
24ALTER TABLE articles ADD FULLTEXT INDEX (body) WITH PARSER simple_parser;
25ERROR HY000: Cannot CREATE FULLTEXT INDEX WITH PARSER on InnoDB table
26CREATE FULLTEXT INDEX ft_index ON articles(body) WITH PARSER simple_parser;
27ERROR HY000: Cannot CREATE FULLTEXT INDEX WITH PARSER on InnoDB table
28DROP TABLE articles;
29UNINSTALL PLUGIN simple_parser;
30