Debian Codegraph @

mysql-test/suite/innodb_fts/r/phrase.result

raw
1 CREATE TABLE articles (
2 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
3 title VARCHAR(200),
4 body TEXT,
5 FULLTEXT (title,body)
6 ) ENGINE=InnoDB;
7 INSERT INTO articles (title,body) VALUES
8 (NULL, 'mysql good database'),
9 (NULL, ' mysql good database'),
10 ('', 'mysql good database'),
11 ('', ' mysql good database'),
12 (' ', 'mysql good database'),
13 ('mysql', 'good database'),
14 ('mysql ', 'good database'),
15 ('mysql', ' good database'),
16 ('mysql good database', ''),
17 ('mysql good database', NULL);
18 SET GLOBAL innodb_ft_aux_table="test/articles";
19 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
20 WORD FIRST_DOC_ID LAST_DOC_ID DOC_COUNT DOC_ID POSITION
21 database 2 11 10 2 11
22 database 2 11 10 3 12
23 database 2 11 10 4 11
24 database 2 11 10 5 12
25 database 2 11 10 6 13
26 database 2 11 10 7 11
27 database 2 11 10 8 12
28 database 2 11 10 9 12
29 database 2 11 10 10 11
30 database 2 11 10 11 11
31 good 2 11 10 2 6
32 good 2 11 10 3 7
33 good 2 11 10 4 6
34 good 2 11 10 5 7
35 good 2 11 10 6 8
36 good 2 11 10 7 6
37 good 2 11 10 8 7
38 good 2 11 10 9 7
39 good 2 11 10 10 6
40 good 2 11 10 11 6
41 mysql 2 11 10 2 0
42 mysql 2 11 10 3 1
43 mysql 2 11 10 4 0
44 mysql 2 11 10 5 1
45 mysql 2 11 10 6 2
46 mysql 2 11 10 7 0
47 mysql 2 11 10 8 0
48 mysql 2 11 10 9 0
49 mysql 2 11 10 10 0
50 mysql 2 11 10 11 0
51 SET GLOBAL innodb_ft_aux_table=default;
52 SELECT * FROM articles;
53 id title body
54 1 NULL mysql good database
55 2 NULL mysql good database
56 3 mysql good database
57 4 mysql good database
58 5 mysql good database
59 6 mysql good database
60 7 mysql good database
61 8 mysql good database
62 9 mysql good database
63 10 mysql good database NULL
64 SELECT * FROM articles WHERE MATCH(title, body)
65 AGAINST('"mysql good database"' IN BOOLEAN MODE);
66 id title body
67 1 NULL mysql good database
68 2 NULL mysql good database
69 3 mysql good database
70 4 mysql good database
71 5 mysql good database
72 9 mysql good database
73 10 mysql good database NULL
74 SELECT * FROM articles WHERE MATCH(title, body)
75 AGAINST('("mysql good database")' IN BOOLEAN MODE);
76 id title body
77 1 NULL mysql good database
78 2 NULL mysql good database
79 3 mysql good database
80 4 mysql good database
81 5 mysql good database
82 9 mysql good database
83 10 mysql good database NULL
84 DROP TABLE articles;