Debian Codegraph @

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

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