Debian Codegraph @

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

raw
1 INSTALL PLUGIN simple_parser SONAME 'mypluglib';
2 # Test Part 2: Create Index Test(CREATE TABLE WITH FULLTEXT INDEX)
3 CREATE TABLE articles (
4 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
5 title VARCHAR(200),
6 body TEXT,
7 FULLTEXT (title, body) WITH PARSER simple_parser
8 ) ENGINE=InnoDB;
9 INSERT INTO articles (title, body) VALUES
10 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...'),
11 ('How To Use MySQL Well','After you went through a ...'),
12 ('Optimizing MySQL','In this tutorial we will show ...'),
13 ('1001 MySQL Tricks','How to use full-text search engine'),
14 ('Go MySQL Tricks','How to use full text search engine');
15 SELECT * FROM articles WHERE
16 MATCH(title, body) AGAINST('mysql');
17 id title body
18 1 MySQL Tutorial DBMS stands for MySQL DataBase ...
19 2 How To Use MySQL Well After you went through a ...
20 3 Optimizing MySQL In this tutorial we will show ...
21 4 1001 MySQL Tricks How to use full-text search engine
22 5 Go MySQL Tricks How to use full text search engine
23 SELECT * FROM articles WHERE
24 MATCH(title, body) AGAINST('will go');
25 id title body
26 # Test plugin parser tokenizer difference
27 SELECT * FROM articles WHERE
28 MATCH(title, body) AGAINST('full-text');
29 id title body
30 4 1001 MySQL Tricks How to use full-text search engine
31 SELECT * FROM articles WHERE
32 MATCH(title, body) AGAINST('full text');
33 id title body
34 5 Go MySQL Tricks How to use full text search engine
35 SELECT * FROM articles WHERE
36 MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE);
37 id title body
38 DROP TABLE articles;
39 # Test Part 3: Row Merge Create Index Test(ALTER TABLE ADD FULLTEXT INDEX)
40 CREATE TABLE articles (
41 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
42 title VARCHAR(200),
43 body TEXT
44 ) ENGINE=InnoDB;
45 INSERT INTO articles (title, body) VALUES
46 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...'),
47 ('How To Use MySQL Well','After you went through a ...'),
48 ('Optimizing MySQL','In this tutorial we will show ...'),
49 ('1001 MySQL Tricks','How to use full-text search engine'),
50 ('Go MySQL Tricks','How to use full text search engine');
51 ALTER TABLE articles ADD FULLTEXT INDEX (title, body) WITH PARSER simple_parser;
52 SELECT * FROM articles WHERE
53 MATCH(title, body) AGAINST('mysql');
54 id title body
55 1 MySQL Tutorial DBMS stands for MySQL DataBase ...
56 2 How To Use MySQL Well After you went through a ...
57 3 Optimizing MySQL In this tutorial we will show ...
58 4 1001 MySQL Tricks How to use full-text search engine
59 5 Go MySQL Tricks How to use full text search engine
60 SELECT * FROM articles WHERE
61 MATCH(title, body) AGAINST('will go');
62 id title body
63 # Test plugin parser tokenizer difference
64 SELECT * FROM articles WHERE
65 MATCH(title, body) AGAINST('full-text');
66 id title body
67 4 1001 MySQL Tricks How to use full-text search engine
68 SELECT * FROM articles WHERE
69 MATCH(title, body) AGAINST('full text');
70 id title body
71 5 Go MySQL Tricks How to use full text search engine
72 SELECT * FROM articles WHERE
73 MATCH(title, body) AGAINST('full-text' WITH QUERY EXPANSION);
74 id title body
75 4 1001 MySQL Tricks How to use full-text search engine
76 5 Go MySQL Tricks How to use full text search engine
77 2 How To Use MySQL Well After you went through a ...
78 1 MySQL Tutorial DBMS stands for MySQL DataBase ...
79 3 Optimizing MySQL In this tutorial we will show ...
80 SELECT * FROM articles WHERE
81 MATCH(title, body) AGAINST('full text' WITH QUERY EXPANSION);
82 id title body
83 5 Go MySQL Tricks How to use full text search engine
84 4 1001 MySQL Tricks How to use full-text search engine
85 2 How To Use MySQL Well After you went through a ...
86 1 MySQL Tutorial DBMS stands for MySQL DataBase ...
87 3 Optimizing MySQL In this tutorial we will show ...
88 SELECT * FROM articles WHERE
89 MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE);
90 id title body
91 DROP TABLE articles;
92 # Test Part 3 END
93 SET SESSION debug="+d,fts_instrument_use_default_parser";
94 # Test Part 4: Create Index Test with Default/Internal Parser
95 CREATE TABLE articles (
96 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
97 title VARCHAR(200),
98 body TEXT,
99 FULLTEXT (title, body) WITH PARSER simple_parser
100 ) ENGINE=InnoDB;
101 INSERT INTO articles (title, body) VALUES
102 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...'),
103 ('How To Use MySQL Well','After you went through a ...'),
104 ('Optimizing MySQL','In this tutorial we will show ...'),
105 ('1001 MySQL Tricks','How to use full-text search engine'),
106 ('Go MySQL Tricks','How to use full text search engine');
107 SELECT * FROM articles WHERE
108 MATCH(title, body) AGAINST('mysql');
109 id title body
110 1 MySQL Tutorial DBMS stands for MySQL DataBase ...
111 2 How To Use MySQL Well After you went through a ...
112 3 Optimizing MySQL In this tutorial we will show ...
113 4 1001 MySQL Tricks How to use full-text search engine
114 5 Go MySQL Tricks How to use full text search engine
115 SELECT * FROM articles WHERE
116 MATCH(title, body) AGAINST('will go');
117 id title body
118 # Test plugin parser tokenizer difference
119 SELECT * FROM articles WHERE
120 MATCH(title, body) AGAINST('full-text');
121 id title body
122 4 1001 MySQL Tricks How to use full-text search engine
123 5 Go MySQL Tricks How to use full text search engine
124 SELECT * FROM articles WHERE
125 MATCH(title, body) AGAINST('full text');
126 id title body
127 4 1001 MySQL Tricks How to use full-text search engine
128 5 Go MySQL Tricks How to use full text search engine
129 # simple parser st_mysql_ftparser_boolean_info doesn't
130 # store position of every word in boolean metadata.
131 # This leads to empty result
132 SELECT * FROM articles WHERE
133 MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE);
134 id title body
135 DROP TABLE articles;
136 # Test Part 5: Row Merge Create Index Test with Default/Internal Parser
137 CREATE TABLE articles (
138 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
139 title VARCHAR(200),
140 body TEXT
141 ) ENGINE=InnoDB;
142 INSERT INTO articles (title, body) VALUES
143 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...'),
144 ('How To Use MySQL Well','After you went through a ...'),
145 ('Optimizing MySQL','In this tutorial we will show ...'),
146 ('1001 MySQL Tricks','How to use full-text search engine'),
147 ('Go MySQL Tricks','How to use full text search engine');
148 ALTER TABLE articles ADD FULLTEXT INDEX (title, body) WITH PARSER simple_parser;
149 SELECT * FROM articles WHERE
150 MATCH(title, body) AGAINST('mysql');
151 id title body
152 1 MySQL Tutorial DBMS stands for MySQL DataBase ...
153 2 How To Use MySQL Well After you went through a ...
154 3 Optimizing MySQL In this tutorial we will show ...
155 4 1001 MySQL Tricks How to use full-text search engine
156 5 Go MySQL Tricks How to use full text search engine
157 SELECT * FROM articles WHERE
158 MATCH(title, body) AGAINST('will go');
159 id title body
160 # Test plugin parser tokenizer difference
161 SELECT * FROM articles WHERE
162 MATCH(title, body) AGAINST('full-text');
163 id title body
164 4 1001 MySQL Tricks How to use full-text search engine
165 5 Go MySQL Tricks How to use full text search engine
166 SELECT * FROM articles WHERE
167 MATCH(title, body) AGAINST('full text');
168 id title body
169 4 1001 MySQL Tricks How to use full-text search engine
170 5 Go MySQL Tricks How to use full text search engine
171 # simple parser st_mysql_ftparser_boolean_info doesn't
172 # store position of every word in boolean metadata.
173 # This leads to empty result
174 SELECT * FROM articles WHERE
175 MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE);
176 id title body
177 DROP TABLE articles;
178 # Test Part 6: Test Query Parser with Default/Internal Parser
179 SET GLOBAL innodb_ft_enable_diag_print = 1;
180 CREATE TABLE articles (
181 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
182 title VARCHAR(200),
183 body TEXT,
184 FULLTEXT (title, body) WITH PARSER simple_parser
185 ) ENGINE=InnoDB;
186 INSERT INTO articles (title, body) VALUES
187 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...'),
188 ('MySQL Tutorial','DBMS stands for MySQL good one DataBase ...'),
189 ('How To Use MySQL Well','After you went through a ...'),
190 ('Optimizing MySQL','In this tutorial we will show ...'),
191 ('1001 MySQL Tricks','How to use full-text search engine');
192 SELECT * FROM articles WHERE
193 MATCH(title, body) AGAINST('+mysql -database' IN BOOLEAN MODE);
194 id title body
195 3 How To Use MySQL Well After you went through a ...
196 4 Optimizing MySQL In this tutorial we will show ...
197 5 1001 MySQL Tricks How to use full-text search engine
198 SELECT * FROM articles WHERE
199 MATCH(title, body) AGAINST('>mysql <database ~search' IN BOOLEAN MODE);
200 id title body
201 3 How To Use MySQL Well After you went through a ...
202 4 Optimizing MySQL In this tutorial we will show ...
203 5 1001 MySQL Tricks How to use full-text search engine
204 1 MySQL Tutorial DBMS stands for MySQL DataBase ...
205 2 MySQL Tutorial DBMS stands for MySQL good one DataBase ...
206 SELECT * FROM articles WHERE
207 MATCH(title, body) AGAINST('+(mysql database) -engine' IN BOOLEAN MODE);
208 id title body
209 1 MySQL Tutorial DBMS stands for MySQL DataBase ...
210 2 MySQL Tutorial DBMS stands for MySQL good one DataBase ...
211 3 How To Use MySQL Well After you went through a ...
212 4 Optimizing MySQL In this tutorial we will show ...
213 SELECT * FROM articles WHERE
214 MATCH(title, body) AGAINST('+(mysql database -engine' IN BOOLEAN MODE);
215 id title body
216 SELECT * FROM articles WHERE
217 MATCH(title, body) AGAINST('"mysql"' IN BOOLEAN MODE);
218 id title body
219 1 MySQL Tutorial DBMS stands for MySQL DataBase ...
220 2 MySQL Tutorial DBMS stands for MySQL good one DataBase ...
221 3 How To Use MySQL Well After you went through a ...
222 4 Optimizing MySQL In this tutorial we will show ...
223 5 1001 MySQL Tricks How to use full-text search engine
224 SELECT * FROM articles WHERE
225 MATCH(title, body) AGAINST('"for mysql"' IN BOOLEAN MODE);
226 id title body
227 1 MySQL Tutorial DBMS stands for MySQL DataBase ...
228 2 MySQL Tutorial DBMS stands for MySQL good one DataBase ...
229 3 How To Use MySQL Well After you went through a ...
230 4 Optimizing MySQL In this tutorial we will show ...
231 5 1001 MySQL Tricks How to use full-text search engine
232 # simple parser st_mysql_ftparser_boolean_info doesn't
233 # store position of every word in boolean metadata.
234 # This leads to empty result for the next 3 queries
235 SELECT * FROM articles WHERE
236 MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE);
237 id title body
238 SELECT * FROM articles WHERE
239 MATCH(title, body) AGAINST('"full text search"' IN BOOLEAN MODE);
240 id title body
241 SELECT * FROM articles WHERE
242 MATCH(title, body) AGAINST('"full text search engine"' IN BOOLEAN MODE);
243 id title body
244 SELECT * FROM articles WHERE
245 MATCH(title, body) AGAINST('+"dbms stands" -good' IN BOOLEAN MODE);
246 id title body
247 1 MySQL Tutorial DBMS stands for MySQL DataBase ...
248 SELECT * FROM articles WHERE
249 MATCH(title, body) AGAINST('+("dbms stands") -good' IN BOOLEAN MODE);
250 id title body
251 1 MySQL Tutorial DBMS stands for MySQL DataBase ...
252 SELECT * FROM articles WHERE
253 MATCH(title, body) AGAINST('+("dbms stands" search) -good' IN BOOLEAN MODE);
254 id title body
255 5 1001 MySQL Tricks How to use full-text search engine
256 1 MySQL Tutorial DBMS stands for MySQL DataBase ...
257 SELECT * FROM articles WHERE
258 MATCH(title, body) AGAINST('+("dbms stands" "full text") -good' IN BOOLEAN MODE);
259 id title body
260 1 MySQL Tutorial DBMS stands for MySQL DataBase ...
261 SELECT * FROM articles WHERE
262 MATCH(title, body) AGAINST('("msyql database")@3' IN BOOLEAN MODE);
263 id title body
264 DROP TABLE articles;
265 SET NAMES utf8;
266 # Test Part 7: Test Different Charset
267 CREATE TABLE articles (
268 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
269 title VARCHAR(200),
270 body TEXT,
271 FULLTEXT (title, body) WITH PARSER simple_parser
272 ) ENGINE=InnoDB DEFAULT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;
273 INSERT INTO articles (title, body) VALUES
274 ('数据库 是 数据 的 结构化 集合','它 可以 是 任何 东西'),
275 ('从 简单 的 购物清单 到 画展','或 企业网络 中 的 海量信息'),
276 ('要 想 将 数据 添加 到 数据库','或 访问、处理 计算机 数据库 中 保存 的 数据'),
277 ('需要 使用 数据库 管理系统','计算机 是 处理 大量 数据 的 理想 工具');
278 SELECT * FROM articles WHERE
279 MATCH(title, body) AGAINST('数据库');
280 id title body
281 3 要 想 将 数据 添加 到 数据库 或 访问、处理 计算机 数据库 中 保存 的 数据
282 1 数据库 是 数据 的 结构化 集合 它 可以 是 任何 东西
283 4 需要 使用 数据库 管理系统 计算机 是 处理 大量 数据 的 理想 工具
284 SELECT * FROM articles WHERE
285 MATCH(title, body) AGAINST('数据');
286 id title body
287 SELECT * FROM articles WHERE
288 MATCH(title, body) AGAINST('数据*');
289 id title body
290 3 要 想 将 数据 添加 到 数据库 或 访问、处理 计算机 数据库 中 保存 的 数据
291 1 数据库 是 数据 的 结构化 集合 它 可以 是 任何 东西
292 4 需要 使用 数据库 管理系统 计算机 是 处理 大量 数据 的 理想 工具
293 SELECT * FROM articles WHERE
294 MATCH(title, body) AGAINST('+数据库 -计算机');
295 id title body
296 1 数据库 是 数据 的 结构化 集合 它 可以 是 任何 东西
297 # simple parser st_mysql_ftparser_boolean_info doesn't
298 # store position of every word in boolean metadata.
299 # This leads to empty result
300 SELECT * FROM articles WHERE
301 MATCH(title, body) AGAINST('"计算机 数据库"' IN BOOLEAN MODE);
302 id title body
303 DROP TABLE articles;
304 SET GLOBAL innodb_ft_enable_diag_print = 0;
305 SET SESSION debug="-d,fts_instrument_use_default_parser";
306 # Test Part 9:# Abort the operation in dict_create_index_step
307 CREATE TABLE articles (
308 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
309 title VARCHAR(200),
310 body TEXT,
311 FULLTEXT (title, body) WITH PARSER simple_parser
312 ) ENGINE=InnoDB;
313 SET SESSION debug="+d,ib_dict_create_index_tree_fail";
314 CREATE FULLTEXT INDEX idx ON articles(body);
315 ERROR HY000: Out of memory.
316 SET SESSION debug="-d,ib_dict_create_index_tree_fail";
317 DROP TABLE articles;
318 UNINSTALL PLUGIN simple_parser;