Debian Codegraph @

mysql-test/suite/innodb_fts/t/phrase.test

raw
1
2 #
3 # BUG#20465273 - FULLTEXT SEARCH BEHAVIOUR WITH MYISAM VS. INNODB (WRONG RESULT WITH INNODB)
4 #
5
6 CREATE TABLE articles (
7 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
8 title VARCHAR(200),
9 body TEXT,
10 FULLTEXT (title,body)
11 ) ENGINE=InnoDB;
12
13 INSERT INTO articles (title,body) VALUES
14 (NULL, 'mysql good database'),
15 (NULL, ' mysql good database'),
16 ('', 'mysql good database'),
17 ('', ' mysql good database'),
18 (' ', 'mysql good database'),
19 ('mysql', 'good database'),
20 ('mysql ', 'good database'),
21 ('mysql', ' good database'),
22 ('mysql good database', ''),
23 ('mysql good database', NULL);
24
25
26 SET GLOBAL innodb_ft_aux_table="test/articles";
27 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
28 SET GLOBAL innodb_ft_aux_table=default;
29
30 SELECT * FROM articles;
31
32 SELECT * FROM articles WHERE MATCH(title, body)
33 AGAINST('"mysql good database"' IN BOOLEAN MODE);
34
35 SELECT * FROM articles WHERE MATCH(title, body)
36 AGAINST('("mysql good database")' IN BOOLEAN MODE);
37
38 DROP TABLE articles;