Debian Codegraph @

mysql-test/suite/innodb_fts/r/versioning,prepare.result

raw
1 # Upgrade test
2 CREATE TEMPORARY TABLE articles (
3 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
4 title VARCHAR(200),
5 body TEXT,
6 FULLTEXT (title,body)
7 ) ENGINE=InnoDB;
8 ERROR HY000: Cannot create FULLTEXT index on temporary InnoDB table
9 CREATE TABLE articles (
10 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
11 title VARCHAR(200),
12 body TEXT,
13 FULLTEXT (title,body)
14 )with system versioning ENGINE=InnoDB;
15 INSERT INTO articles (title,body) VALUES
16 ('MySQL Tutorial','DBMS stands for DataBase ...') ,
17 ('How To Use MySQL Well','After you went through a ...'),
18 ('Optimizing MySQL','In this tutorial we will show ...'),
19 ('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
20 ('MySQL vs. YourSQL','In the following database comparison ...'),
21 ('MySQL Security','When configured properly, MySQL ...');
22 INSERT INTO articles (title,body) VALUES
23 ('test query expansion','for database ...');
24 INSERT INTO articles (title,body) VALUES
25 ('test proximity search, test, proximity and phrase',
26 'search, with proximity innodb');
27 INSERT INTO articles (title,body) VALUES
28 ('test my proximity fts new search, test, proximity and phrase',
29 'search, with proximity innodb');
30 INSERT INTO articles (title,body) VALUES
31 ('test more of proximity fts search, test, more proximity and phrase',
32 'search, with proximity innodb');
33 call mtr.add_suppression("\\[ERROR\\] InnoDB: user stopword table not_defined does not exist.");
34 call mtr.add_suppression("\\[ERROR\\] InnoDB: user stopword table test/user_stopword_session does not exist.");
35 select * from information_schema.innodb_ft_default_stopword;
36 value
37 a
38 about
39 an
40 are
41 as
42 at
43 be
44 by
45 com
46 de
47 en
48 for
49 from
50 how
51 i
52 in
53 is
54 it
55 la
56 of
57 on
58 or
59 that
60 the
61 this
62 to
63 was
64 what
65 when
66 where
67 who
68 will
69 with
70 und
71 the
72 www
73 CREATE TABLE articles2 (
74 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
75 title VARCHAR(200),
76 body TEXT,
77 FULLTEXT (title,body)
78 )with system versioning ENGINE=InnoDB;
79 INSERT INTO articles2 (title,body) VALUES
80 ('MySQL Tutorial','DBMS stands for DataBase ...') ,
81 ('How To Use MySQL Well','After you went through a ...'),
82 ('Optimizing MySQL','In this tutorial we will show ...'),
83 ('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
84 ('MySQL vs. YourSQL','In the following database comparison ...'),
85 ('MySQL Security','When configured properly, MySQL ...');
86 SELECT * FROM articles2 WHERE MATCH (title,body)
87 AGAINST ('the' IN NATURAL LANGUAGE MODE);
88 id title body
89 set global innodb_ft_server_stopword_table = "not_defined";
90 ERROR 42000: Variable 'innodb_ft_server_stopword_table' can't be set to the value of 'not_defined'
91 set global innodb_ft_server_stopword_table = NULL;
92 create table user_stopword(value varchar(30)) engine = innodb;
93 set global innodb_ft_server_stopword_table = "test/user_stopword";
94 drop index title on articles2;
95 create fulltext index idx on articles2(title, body);
96 insert into articles2 (title, body)
97 values ('test for stopwords','this is it...');
98 insert into user_stopword values("the");
99 delete from user_stopword;
100 insert into user_stopword values("this");
101 SELECT * FROM articles WHERE MATCH (title,body)
102 AGAINST ('Database' IN NATURAL LANGUAGE MODE);
103 ERROR HY000: Index articles is corrupted
104 call mtr.add_suppression("test/articles.? contains 3 indexes inside InnoDB");
105 alter table articles force;
106 Warnings:
107 Warning 1082 InnoDB: Table test/articles contains 3 indexes inside InnoDB, which is different from the number of indexes 2 defined in the MariaDB
108 flush tables;
109 show create table articles;
110 Table Create Table
111 articles CREATE TABLE `articles` (
112 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
113 `title` varchar(200) DEFAULT NULL,
114 `body` text DEFAULT NULL,
115 PRIMARY KEY (`id`),
116 FULLTEXT KEY `title` (`title`,`body`)
117 ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci WITH SYSTEM VERSIONING
118 SELECT * FROM articles
119 WHERE MATCH (title,body)
120 AGAINST ('Database' IN NATURAL LANGUAGE MODE);
121 id title body
122 1 MySQL Tutorial DBMS stands for DataBase ...
123 5 MySQL vs. YourSQL In the following database comparison ...
124 7 test query expansion for database ...
125 SELECT COUNT(*) FROM articles
126 WHERE MATCH (title,body)
127 AGAINST ('database' IN NATURAL LANGUAGE MODE);
128 COUNT(*)
129 3
130 SELECT * FROM articles
131 WHERE MATCH (title, body)
132 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
133 id title body
134 1 MySQL Tutorial DBMS stands for DataBase ...
135 3 Optimizing MySQL In this tutorial we will show ...
136 SELECT COUNT(IF(MATCH (title,body)
137 AGAINST ('database' IN NATURAL LANGUAGE MODE), 1, NULL))
138 AS count FROM articles;
139 count
140 3
141 SELECT id, body, MATCH (title,body)
142 AGAINST ('Database' IN NATURAL LANGUAGE MODE) AS score
143 FROM articles;
144 id body score
145 1 DBMS stands for DataBase ... 0.2734021842479706
146 2 After you went through a ... 0
147 3 In this tutorial we will show ... 0
148 4 1. Never run mysqld as root. 2. ... 0
149 5 In the following database comparison ... 0.2734021842479706
150 6 When configured properly, MySQL ... 0
151 7 for database ... 0.2734021842479706
152 8 search, with proximity innodb 0
153 9 search, with proximity innodb 0
154 10 search, with proximity innodb 0
155 SELECT * FROM articles
156 WHERE MATCH (title,body)
157 AGAINST ('MySQL' IN NATURAL LANGUAGE MODE);
158 id title body
159 6 MySQL Security When configured properly, MySQL ...
160 1 MySQL Tutorial DBMS stands for DataBase ...
161 2 How To Use MySQL Well After you went through a ...
162 3 Optimizing MySQL In this tutorial we will show ...
163 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
164 5 MySQL vs. YourSQL In the following database comparison ...
165 SELECT * FROM articles WHERE MATCH (title,body)
166 AGAINST ('+MySQL -YourSQL' IN BOOLEAN MODE);
167 id title body
168 6 MySQL Security When configured properly, MySQL ...
169 1 MySQL Tutorial DBMS stands for DataBase ...
170 2 How To Use MySQL Well After you went through a ...
171 3 Optimizing MySQL In this tutorial we will show ...
172 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
173 SELECT * FROM articles WHERE MATCH (title,body)
174 AGAINST ('DBMS Security' IN BOOLEAN MODE);
175 id title body
176 1 MySQL Tutorial DBMS stands for DataBase ...
177 6 MySQL Security When configured properly, MySQL ...
178 SELECT * FROM articles WHERE MATCH (title,body)
179 AGAINST ('+MySQL +YourSQL' IN BOOLEAN MODE);
180 id title body
181 5 MySQL vs. YourSQL In the following database comparison ...
182 SELECT * FROM articles WHERE MATCH (title,body)
183 AGAINST ('+MySQL YourSQL' IN BOOLEAN MODE);
184 id title body
185 5 MySQL vs. YourSQL In the following database comparison ...
186 6 MySQL Security When configured properly, MySQL ...
187 1 MySQL Tutorial DBMS stands for DataBase ...
188 2 How To Use MySQL Well After you went through a ...
189 3 Optimizing MySQL In this tutorial we will show ...
190 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
191 SELECT * FROM articles WHERE MATCH (title,body)
192 AGAINST ('+MySQL ~YourSQL' IN BOOLEAN MODE);
193 id title body
194 6 MySQL Security When configured properly, MySQL ...
195 1 MySQL Tutorial DBMS stands for DataBase ...
196 2 How To Use MySQL Well After you went through a ...
197 3 Optimizing MySQL In this tutorial we will show ...
198 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
199 5 MySQL vs. YourSQL In the following database comparison ...
200 SELECT * FROM articles WHERE MATCH (title,body)
201 AGAINST ('t*' IN BOOLEAN MODE);
202 id title body
203 8 test proximity search, test, proximity and phrase search, with proximity innodb
204 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
205 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
206 1 MySQL Tutorial DBMS stands for DataBase ...
207 2 How To Use MySQL Well After you went through a ...
208 3 Optimizing MySQL In this tutorial we will show ...
209 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
210 7 test query expansion for database ...
211 SELECT * FROM articles WHERE MATCH (title,body)
212 AGAINST ('MY*' IN BOOLEAN MODE);
213 id title body
214 6 MySQL Security When configured properly, MySQL ...
215 1 MySQL Tutorial DBMS stands for DataBase ...
216 2 How To Use MySQL Well After you went through a ...
217 3 Optimizing MySQL In this tutorial we will show ...
218 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
219 5 MySQL vs. YourSQL In the following database comparison ...
220 SELECT * FROM articles WHERE MATCH (title,body)
221 AGAINST ('ru*' IN BOOLEAN MODE);
222 id title body
223 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
224 SELECT * FROM articles WHERE MATCH (title,body)
225 AGAINST ('+ MySQL >Well < stands' IN BOOLEAN MODE);
226 id title body
227 2 How To Use MySQL Well After you went through a ...
228 6 MySQL Security When configured properly, MySQL ...
229 1 MySQL Tutorial DBMS stands for DataBase ...
230 3 Optimizing MySQL In this tutorial we will show ...
231 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
232 5 MySQL vs. YourSQL In the following database comparison ...
233 SELECT * FROM articles WHERE MATCH (title,body)
234 AGAINST ('+ MySQL - (Well stands)' IN BOOLEAN MODE);
235 id title body
236 6 MySQL Security When configured properly, MySQL ...
237 3 Optimizing MySQL In this tutorial we will show ...
238 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
239 5 MySQL vs. YourSQL In the following database comparison ...
240 SELECT * FROM articles WHERE MATCH (title,body) AGAINST
241 ('(((((((((((((((((((((((((((((((((Security)))))))))))))))))))))))))))))))))'
242 IN BOOLEAN MODE);
243 ERROR HY000: Table handler out of memory
244 SELECT * FROM articles WHERE MATCH (title,body) AGAINST
245 ('((((((((((((((((((((((((((((((((Security))))))))))))))))))))))))))))))))'
246 IN BOOLEAN MODE);
247 id title body
248 6 MySQL Security When configured properly, MySQL ...
249 SELECT * FROM articles WHERE MATCH (title,body) AGAINST
250 ('(((((((((((((((((((((((((((((((vs))))))))))))))))))))))))))))))),(((to)))'
251 IN BOOLEAN MODE);
252 id title body
253 SELECT * FROM articles WHERE MATCH (title,body) AGAINST
254 ('((((((((((((((((((((((((((((((((Security)))))))))))))))))))))))))))))))'
255 IN BOOLEAN MODE);
256 ERROR 42000: syntax error, unexpected $end
257 SELECT * FROM articles WHERE MATCH (title,body) AGAINST
258 ('(((((((((((((((((((((((((((((((((Security))))))))))))))))))))))))))))))))'
259 IN BOOLEAN MODE);
260 ERROR 42000: syntax error, unexpected $end
261 SELECT * FROM articles WHERE MATCH (title,body)
262 AGAINST ('+ MySQL + (>Well < stands)' IN BOOLEAN MODE);
263 id title body
264 2 How To Use MySQL Well After you went through a ...
265 1 MySQL Tutorial DBMS stands for DataBase ...
266 SELECT * FROM articles WHERE MATCH (title,body)
267 AGAINST ('YourSQL + (+MySQL - (Tricks Security))' IN BOOLEAN MODE);
268 id title body
269 5 MySQL vs. YourSQL In the following database comparison ...
270 1 MySQL Tutorial DBMS stands for DataBase ...
271 2 How To Use MySQL Well After you went through a ...
272 3 Optimizing MySQL In this tutorial we will show ...
273 SELECT * FROM articles WHERE MATCH (title,body)
274 AGAINST ('(+MySQL - (Tricks Security)) - YourSQL' IN BOOLEAN MODE);
275 id title body
276 1 MySQL Tutorial DBMS stands for DataBase ...
277 2 How To Use MySQL Well After you went through a ...
278 3 Optimizing MySQL In this tutorial we will show ...
279 SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('mysql - Security&DBMS' IN BOOLEAN MODE);
280 id title body
281 2 How To Use MySQL Well After you went through a ...
282 3 Optimizing MySQL In this tutorial we will show ...
283 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
284 5 MySQL vs. YourSQL In the following database comparison ...
285 SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('mysql - (Security DBMS)' IN BOOLEAN MODE);
286 id title body
287 2 How To Use MySQL Well After you went through a ...
288 3 Optimizing MySQL In this tutorial we will show ...
289 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
290 5 MySQL vs. YourSQL In the following database comparison ...
291 SELECT * FROM articles WHERE MATCH (title,body) AGAINST (' - Security&DBMS + YourSQL' IN BOOLEAN MODE);
292 id title body
293 5 MySQL vs. YourSQL In the following database comparison ...
294 SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+YourSQL - Security&DBMS' IN BOOLEAN MODE);
295 id title body
296 5 MySQL vs. YourSQL In the following database comparison ...
297 SELECT COUNT(*) FROM articles
298 WHERE MATCH (title,body)
299 AGAINST ('database' WITH QUERY EXPANSION);
300 COUNT(*)
301 10
302 SELECT * FROM articles
303 WHERE MATCH (title,body)
304 AGAINST ('test' WITH QUERY EXPANSION);
305 id title body
306 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
307 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
308 8 test proximity search, test, proximity and phrase search, with proximity innodb
309 7 test query expansion for database ...
310 1 MySQL Tutorial DBMS stands for DataBase ...
311 5 MySQL vs. YourSQL In the following database comparison ...
312 SELECT * FROM articles
313 WHERE MATCH (title,body)
314 AGAINST ('"following comparison"@3' IN BOOLEAN MODE);
315 id title body
316 5 MySQL vs. YourSQL In the following database comparison ...
317 SELECT * FROM articles
318 WHERE MATCH (title,body)
319 AGAINST ('"following comparison"@2' IN BOOLEAN MODE);
320 id title body
321 SELECT * FROM articles
322 WHERE MATCH (title,body)
323 AGAINST ('"following database"' IN BOOLEAN MODE);
324 id title body
325 5 MySQL vs. YourSQL In the following database comparison ...
326 SELECT * FROM articles
327 WHERE MATCH (title,body)
328 AGAINST ('"proximity search"@3' IN BOOLEAN MODE);
329 id title body
330 8 test proximity search, test, proximity and phrase search, with proximity innodb
331 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
332 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
333 SELECT * FROM articles
334 WHERE MATCH (title,body)
335 AGAINST ('"proximity search"@2' IN BOOLEAN MODE);
336 id title body
337 8 test proximity search, test, proximity and phrase search, with proximity innodb
338 SELECT * FROM articles
339 WHERE MATCH (title,body)
340 AGAINST ('"proximity search"@5' IN BOOLEAN MODE);
341 id title body
342 8 test proximity search, test, proximity and phrase search, with proximity innodb
343 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
344 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
345 SELECT * FROM articles
346 WHERE MATCH (title,body)
347 AGAINST ('"test proximity"@5' IN BOOLEAN MODE);
348 id title body
349 8 test proximity search, test, proximity and phrase search, with proximity innodb
350 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
351 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
352 SELECT * FROM articles
353 WHERE MATCH (title,body)
354 AGAINST ('"test proximity"@1' IN BOOLEAN MODE);
355 id title body
356 SELECT * FROM articles
357 WHERE MATCH (title,body)
358 AGAINST ('"test proximity"@4' IN BOOLEAN MODE);
359 id title body
360 8 test proximity search, test, proximity and phrase search, with proximity innodb
361 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
362 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
363 SELECT * FROM articles
364 WHERE MATCH (title,body)
365 AGAINST ('"test proximity"@3' IN BOOLEAN MODE);
366 id title body
367 8 test proximity search, test, proximity and phrase search, with proximity innodb
368 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
369 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
370 SELECT * FROM articles
371 WHERE MATCH (title,body)
372 AGAINST ('"more test proximity"@4' IN BOOLEAN MODE);
373 id title body
374 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
375 SELECT * FROM articles
376 WHERE MATCH (title,body)
377 AGAINST ('"more test proximity"@3' IN BOOLEAN MODE);
378 id title body
379 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
380 SELECT * FROM articles
381 WHERE MATCH (title,body)
382 AGAINST ('"more test proximity"' IN BOOLEAN MODE);
383 id title body
384 set global innodb_ft_server_stopword_table= "test/user_stopword";
385 SELECT * FROM articles2 WHERE MATCH (title,body)
386 AGAINST ('the' IN NATURAL LANGUAGE MODE);
387 SELECT * FROM articles2 WHERE MATCH (title,body)
388 AGAINST ('this' IN NATURAL LANGUAGE MODE);
389 drop index idx on articles2;
390 Warnings:
391 Warning 1082 InnoDB: Table test/articles2 contains 3 indexes inside InnoDB, which is different from the number of indexes 1 defined in the MariaDB
392 create fulltext index idx on articles2(title, body);
393 SELECT * FROM articles2 WHERE MATCH (title,body)
394 AGAINST ('the' IN NATURAL LANGUAGE MODE);
395 id title body
396 5 MySQL vs. YourSQL In the following database comparison ...
397 SELECT * FROM articles2 WHERE MATCH (title,body)
398 AGAINST ('this' IN NATURAL LANGUAGE MODE);
399 id title body
400 # Downgrade test
401 alter table articles force;
402 Warnings:
403 Warning 1082 InnoDB: Table test/articles contains 3 indexes inside InnoDB, which is different from the number of indexes 2 defined in the MariaDB
404 Warning 1082 InnoDB: Table test/articles contains 3 indexes inside InnoDB, which is different from the number of indexes 2 defined in the MariaDB
405 flush tables;
406 show create table articles;
407 Table Create Table
408 articles CREATE TABLE `articles` (
409 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
410 `title` varchar(200) DEFAULT NULL,
411 `body` text DEFAULT NULL,
412 PRIMARY KEY (`id`),
413 FULLTEXT KEY `title` (`title`,`body`)
414 ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci WITH SYSTEM VERSIONING
415 SELECT * FROM articles
416 WHERE MATCH (title,body)
417 AGAINST ('Database' IN NATURAL LANGUAGE MODE);
418 id title body
419 1 MySQL Tutorial DBMS stands for DataBase ...
420 5 MySQL vs. YourSQL In the following database comparison ...
421 7 test query expansion for database ...
422 SELECT COUNT(*) FROM articles
423 WHERE MATCH (title,body)
424 AGAINST ('database' IN NATURAL LANGUAGE MODE);
425 COUNT(*)
426 3
427 SELECT * FROM articles
428 WHERE MATCH (title, body)
429 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
430 id title body
431 1 MySQL Tutorial DBMS stands for DataBase ...
432 3 Optimizing MySQL In this tutorial we will show ...
433 SELECT COUNT(IF(MATCH (title,body)
434 AGAINST ('database' IN NATURAL LANGUAGE MODE), 1, NULL))
435 AS count FROM articles;
436 count
437 3
438 SELECT id, body, MATCH (title,body)
439 AGAINST ('Database' IN NATURAL LANGUAGE MODE) AS score
440 FROM articles;
441 id body score
442 1 DBMS stands for DataBase ... 0.2734021842479706
443 2 After you went through a ... 0
444 3 In this tutorial we will show ... 0
445 4 1. Never run mysqld as root. 2. ... 0
446 5 In the following database comparison ... 0.2734021842479706
447 6 When configured properly, MySQL ... 0
448 7 for database ... 0.2734021842479706
449 8 search, with proximity innodb 0
450 9 search, with proximity innodb 0
451 10 search, with proximity innodb 0
452 SELECT * FROM articles
453 WHERE MATCH (title,body)
454 AGAINST ('MySQL' IN NATURAL LANGUAGE MODE);
455 id title body
456 6 MySQL Security When configured properly, MySQL ...
457 1 MySQL Tutorial DBMS stands for DataBase ...
458 2 How To Use MySQL Well After you went through a ...
459 3 Optimizing MySQL In this tutorial we will show ...
460 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
461 5 MySQL vs. YourSQL In the following database comparison ...
462 SELECT * FROM articles WHERE MATCH (title,body)
463 AGAINST ('+MySQL -YourSQL' IN BOOLEAN MODE);
464 id title body
465 6 MySQL Security When configured properly, MySQL ...
466 1 MySQL Tutorial DBMS stands for DataBase ...
467 2 How To Use MySQL Well After you went through a ...
468 3 Optimizing MySQL In this tutorial we will show ...
469 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
470 SELECT * FROM articles WHERE MATCH (title,body)
471 AGAINST ('DBMS Security' IN BOOLEAN MODE);
472 id title body
473 1 MySQL Tutorial DBMS stands for DataBase ...
474 6 MySQL Security When configured properly, MySQL ...
475 SELECT * FROM articles WHERE MATCH (title,body)
476 AGAINST ('+MySQL +YourSQL' IN BOOLEAN MODE);
477 id title body
478 5 MySQL vs. YourSQL In the following database comparison ...
479 SELECT * FROM articles WHERE MATCH (title,body)
480 AGAINST ('+MySQL YourSQL' IN BOOLEAN MODE);
481 id title body
482 5 MySQL vs. YourSQL In the following database comparison ...
483 6 MySQL Security When configured properly, MySQL ...
484 1 MySQL Tutorial DBMS stands for DataBase ...
485 2 How To Use MySQL Well After you went through a ...
486 3 Optimizing MySQL In this tutorial we will show ...
487 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
488 SELECT * FROM articles WHERE MATCH (title,body)
489 AGAINST ('+MySQL ~YourSQL' IN BOOLEAN MODE);
490 id title body
491 6 MySQL Security When configured properly, MySQL ...
492 1 MySQL Tutorial DBMS stands for DataBase ...
493 2 How To Use MySQL Well After you went through a ...
494 3 Optimizing MySQL In this tutorial we will show ...
495 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
496 5 MySQL vs. YourSQL In the following database comparison ...
497 SELECT * FROM articles WHERE MATCH (title,body)
498 AGAINST ('t*' IN BOOLEAN MODE);
499 id title body
500 8 test proximity search, test, proximity and phrase search, with proximity innodb
501 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
502 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
503 1 MySQL Tutorial DBMS stands for DataBase ...
504 2 How To Use MySQL Well After you went through a ...
505 3 Optimizing MySQL In this tutorial we will show ...
506 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
507 7 test query expansion for database ...
508 SELECT * FROM articles WHERE MATCH (title,body)
509 AGAINST ('MY*' IN BOOLEAN MODE);
510 id title body
511 6 MySQL Security When configured properly, MySQL ...
512 1 MySQL Tutorial DBMS stands for DataBase ...
513 2 How To Use MySQL Well After you went through a ...
514 3 Optimizing MySQL In this tutorial we will show ...
515 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
516 5 MySQL vs. YourSQL In the following database comparison ...
517 SELECT * FROM articles WHERE MATCH (title,body)
518 AGAINST ('ru*' IN BOOLEAN MODE);
519 id title body
520 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
521 SELECT * FROM articles WHERE MATCH (title,body)
522 AGAINST ('+ MySQL >Well < stands' IN BOOLEAN MODE);
523 id title body
524 2 How To Use MySQL Well After you went through a ...
525 6 MySQL Security When configured properly, MySQL ...
526 1 MySQL Tutorial DBMS stands for DataBase ...
527 3 Optimizing MySQL In this tutorial we will show ...
528 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
529 5 MySQL vs. YourSQL In the following database comparison ...
530 SELECT * FROM articles WHERE MATCH (title,body)
531 AGAINST ('+ MySQL - (Well stands)' IN BOOLEAN MODE);
532 id title body
533 6 MySQL Security When configured properly, MySQL ...
534 3 Optimizing MySQL In this tutorial we will show ...
535 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
536 5 MySQL vs. YourSQL In the following database comparison ...
537 SELECT * FROM articles WHERE MATCH (title,body) AGAINST
538 ('(((((((((((((((((((((((((((((((((Security)))))))))))))))))))))))))))))))))'
539 IN BOOLEAN MODE);
540 ERROR HY000: Table handler out of memory
541 SELECT * FROM articles WHERE MATCH (title,body) AGAINST
542 ('((((((((((((((((((((((((((((((((Security))))))))))))))))))))))))))))))))'
543 IN BOOLEAN MODE);
544 id title body
545 6 MySQL Security When configured properly, MySQL ...
546 SELECT * FROM articles WHERE MATCH (title,body) AGAINST
547 ('(((((((((((((((((((((((((((((((vs))))))))))))))))))))))))))))))),(((to)))'
548 IN BOOLEAN MODE);
549 id title body
550 SELECT * FROM articles WHERE MATCH (title,body) AGAINST
551 ('((((((((((((((((((((((((((((((((Security)))))))))))))))))))))))))))))))'
552 IN BOOLEAN MODE);
553 ERROR 42000: syntax error, unexpected $end
554 SELECT * FROM articles WHERE MATCH (title,body) AGAINST
555 ('(((((((((((((((((((((((((((((((((Security))))))))))))))))))))))))))))))))'
556 IN BOOLEAN MODE);
557 ERROR 42000: syntax error, unexpected $end
558 SELECT * FROM articles WHERE MATCH (title,body)
559 AGAINST ('+ MySQL + (>Well < stands)' IN BOOLEAN MODE);
560 id title body
561 2 How To Use MySQL Well After you went through a ...
562 1 MySQL Tutorial DBMS stands for DataBase ...
563 SELECT * FROM articles WHERE MATCH (title,body)
564 AGAINST ('YourSQL + (+MySQL - (Tricks Security))' IN BOOLEAN MODE);
565 id title body
566 5 MySQL vs. YourSQL In the following database comparison ...
567 1 MySQL Tutorial DBMS stands for DataBase ...
568 2 How To Use MySQL Well After you went through a ...
569 3 Optimizing MySQL In this tutorial we will show ...
570 SELECT * FROM articles WHERE MATCH (title,body)
571 AGAINST ('(+MySQL - (Tricks Security)) - YourSQL' IN BOOLEAN MODE);
572 id title body
573 1 MySQL Tutorial DBMS stands for DataBase ...
574 2 How To Use MySQL Well After you went through a ...
575 3 Optimizing MySQL In this tutorial we will show ...
576 SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('mysql - Security&DBMS' IN BOOLEAN MODE);
577 id title body
578 2 How To Use MySQL Well After you went through a ...
579 3 Optimizing MySQL In this tutorial we will show ...
580 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
581 5 MySQL vs. YourSQL In the following database comparison ...
582 SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('mysql - (Security DBMS)' IN BOOLEAN MODE);
583 id title body
584 2 How To Use MySQL Well After you went through a ...
585 3 Optimizing MySQL In this tutorial we will show ...
586 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
587 5 MySQL vs. YourSQL In the following database comparison ...
588 SELECT * FROM articles WHERE MATCH (title,body) AGAINST (' - Security&DBMS + YourSQL' IN BOOLEAN MODE);
589 id title body
590 5 MySQL vs. YourSQL In the following database comparison ...
591 SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+YourSQL - Security&DBMS' IN BOOLEAN MODE);
592 id title body
593 5 MySQL vs. YourSQL In the following database comparison ...
594 SELECT COUNT(*) FROM articles
595 WHERE MATCH (title,body)
596 AGAINST ('database' WITH QUERY EXPANSION);
597 COUNT(*)
598 10
599 SELECT * FROM articles
600 WHERE MATCH (title,body)
601 AGAINST ('test' WITH QUERY EXPANSION);
602 id title body
603 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
604 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
605 8 test proximity search, test, proximity and phrase search, with proximity innodb
606 7 test query expansion for database ...
607 1 MySQL Tutorial DBMS stands for DataBase ...
608 5 MySQL vs. YourSQL In the following database comparison ...
609 SELECT * FROM articles
610 WHERE MATCH (title,body)
611 AGAINST ('"following comparison"@3' IN BOOLEAN MODE);
612 id title body
613 5 MySQL vs. YourSQL In the following database comparison ...
614 SELECT * FROM articles
615 WHERE MATCH (title,body)
616 AGAINST ('"following comparison"@2' IN BOOLEAN MODE);
617 id title body
618 SELECT * FROM articles
619 WHERE MATCH (title,body)
620 AGAINST ('"following database"' IN BOOLEAN MODE);
621 id title body
622 5 MySQL vs. YourSQL In the following database comparison ...
623 SELECT * FROM articles
624 WHERE MATCH (title,body)
625 AGAINST ('"proximity search"@3' IN BOOLEAN MODE);
626 id title body
627 8 test proximity search, test, proximity and phrase search, with proximity innodb
628 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
629 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
630 SELECT * FROM articles
631 WHERE MATCH (title,body)
632 AGAINST ('"proximity search"@2' IN BOOLEAN MODE);
633 id title body
634 8 test proximity search, test, proximity and phrase search, with proximity innodb
635 SELECT * FROM articles
636 WHERE MATCH (title,body)
637 AGAINST ('"proximity search"@5' IN BOOLEAN MODE);
638 id title body
639 8 test proximity search, test, proximity and phrase search, with proximity innodb
640 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
641 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
642 SELECT * FROM articles
643 WHERE MATCH (title,body)
644 AGAINST ('"test proximity"@5' IN BOOLEAN MODE);
645 id title body
646 8 test proximity search, test, proximity and phrase search, with proximity innodb
647 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
648 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
649 SELECT * FROM articles
650 WHERE MATCH (title,body)
651 AGAINST ('"test proximity"@1' IN BOOLEAN MODE);
652 id title body
653 SELECT * FROM articles
654 WHERE MATCH (title,body)
655 AGAINST ('"test proximity"@4' IN BOOLEAN MODE);
656 id title body
657 8 test proximity search, test, proximity and phrase search, with proximity innodb
658 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
659 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
660 SELECT * FROM articles
661 WHERE MATCH (title,body)
662 AGAINST ('"test proximity"@3' IN BOOLEAN MODE);
663 id title body
664 8 test proximity search, test, proximity and phrase search, with proximity innodb
665 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
666 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
667 SELECT * FROM articles
668 WHERE MATCH (title,body)
669 AGAINST ('"more test proximity"@4' IN BOOLEAN MODE);
670 id title body
671 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
672 SELECT * FROM articles
673 WHERE MATCH (title,body)
674 AGAINST ('"more test proximity"@3' IN BOOLEAN MODE);
675 id title body
676 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
677 SELECT * FROM articles
678 WHERE MATCH (title,body)
679 AGAINST ('"more test proximity"' IN BOOLEAN MODE);
680 id title body
681 set global innodb_ft_server_stopword_table= "test/user_stopword";
682 drop index idx on articles2;
683 Warnings:
684 Warning 1082 InnoDB: Table test/articles2 contains 3 indexes inside InnoDB, which is different from the number of indexes 2 defined in the MariaDB
685 Warning 1082 InnoDB: Table test/articles2 contains 3 indexes inside InnoDB, which is different from the number of indexes 1 defined in the MariaDB
686 create fulltext index idx on articles2(title, body);
687 SELECT * FROM articles2 WHERE MATCH (title,body)
688 AGAINST ('the' IN NATURAL LANGUAGE MODE);
689 id title body
690 SELECT * FROM articles2 WHERE MATCH (title,body)
691 AGAINST ('this' IN NATURAL LANGUAGE MODE);
692 id title body
693 # Cleanup
694 drop tables articles, articles2, user_stopword;
695 set global innodb_ft_server_stopword_table= default;