Debian Codegraph @

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

raw
1 drop table if exists t1;
2 CREATE TABLE t1 (
3 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
4 a VARCHAR(200),
5 b TEXT
6 ) ENGINE = InnoDB STATS_PERSISTENT=0;
7 CREATE FULLTEXT INDEX idx on t1 (a,b);
8 INSERT INTO t1 (a,b) VALUES
9 ('MySQL from Tutorial','DBMS stands for DataBase ...') ,
10 ('when To Use MySQL Well','After that you went through a ...'),
11 ('where will Optimizing MySQL','what In this tutorial we will show ...');
12 START TRANSACTION;
13 INSERT INTO t1 (a,b) VALUES
14 ('MySQL Tutorial','request docteam for oraclehelp.');
15 SELECT * FROM t1
16 WHERE MATCH (a,b)
17 AGAINST ('tutorial' IN NATURAL LANGUAGE MODE);
18 id a b
19 1 MySQL from Tutorial DBMS stands for DataBase ...
20 3 where will Optimizing MySQL what In this tutorial we will show ...
21 SELECT * FROM t1
22 WHERE MATCH (a,b)
23 AGAINST ('request' IN NATURAL LANGUAGE MODE);
24 id a b
25 SELECT * FROM t1
26 WHERE MATCH (a,b)
27 AGAINST ('request MySQL' IN BOOLEAN MODE);
28 id a b
29 1 MySQL from Tutorial DBMS stands for DataBase ...
30 2 when To Use MySQL Well After that you went through a ...
31 3 where will Optimizing MySQL what In this tutorial we will show ...
32 SELECT * FROM t1
33 WHERE MATCH (a,b)
34 AGAINST ('-request +MySQL' IN BOOLEAN MODE);
35 id a b
36 1 MySQL from Tutorial DBMS stands for DataBase ...
37 2 when To Use MySQL Well After that you went through a ...
38 3 where will Optimizing MySQL what In this tutorial we will show ...
39 SELECT * FROM t1
40 WHERE MATCH (a,b)
41 AGAINST ('+MySQL -(Tutorial Optimizing)' IN BOOLEAN MODE);
42 id a b
43 2 when To Use MySQL Well After that you went through a ...
44 SELECT * FROM t1
45 WHERE MATCH (a,b)
46 AGAINST ('"stands Database"@11' IN BOOLEAN MODE) ORDER BY 1;
47 id a b
48 1 MySQL from Tutorial DBMS stands for DataBase ...
49 SELECT * FROM t1
50 WHERE MATCH (a,b)
51 AGAINST ('tutorial' WITH QUERY EXPANSION);
52 id a b
53 1 MySQL from Tutorial DBMS stands for DataBase ...
54 3 where will Optimizing MySQL what In this tutorial we will show ...
55 2 when To Use MySQL Well After that you went through a ...
56 COMMIT;
57 SELECT * FROM t1
58 WHERE MATCH (a,b)
59 AGAINST ('tutorial' IN NATURAL LANGUAGE MODE);
60 id a b
61 1 MySQL from Tutorial DBMS stands for DataBase ...
62 3 where will Optimizing MySQL what In this tutorial we will show ...
63 4 MySQL Tutorial request docteam for oraclehelp.
64 SELECT * FROM t1
65 WHERE MATCH (a,b)
66 AGAINST ('request MySQL' IN BOOLEAN MODE);
67 id a b
68 4 MySQL Tutorial request docteam for oraclehelp.
69 1 MySQL from Tutorial DBMS stands for DataBase ...
70 2 when To Use MySQL Well After that you went through a ...
71 3 where will Optimizing MySQL what In this tutorial we will show ...
72 SELECT * FROM t1
73 WHERE MATCH (a,b)
74 AGAINST ('tutorial' WITH QUERY EXPANSION);
75 id a b
76 1 MySQL from Tutorial DBMS stands for DataBase ...
77 4 MySQL Tutorial request docteam for oraclehelp.
78 3 where will Optimizing MySQL what In this tutorial we will show ...
79 2 when To Use MySQL Well After that you went through a ...
80 START TRANSACTION;
81 INSERT INTO t1 (a,b) VALUES (NULL,NULL);
82 SELECT * FROM t1
83 WHERE MATCH (a,b)
84 AGAINST ('+request +MySQL' IN BOOLEAN MODE);
85 id a b
86 4 MySQL Tutorial request docteam for oraclehelp.
87 UPDATE t1 SET a = 'Trial version' , b = 'query performace 1255 minute on 2.1Hz Memory 2GB...'
88 WHERE MATCH (a,b) AGAINST ('+request +MySQL' IN BOOLEAN MODE);
89 SELECT * FROM t1
90 WHERE MATCH (a,b)
91 AGAINST ('request');
92 id a b
93 SELECT * FROM t1
94 WHERE MATCH (a,b)
95 AGAINST ('query performace' IN BOOLEAN MODE);
96 id a b
97 UPDATE t1 SET a = 'when To Use MySQL Well' , b = 'for free faq xyz.com ...'
98 WHERE MATCH (a,b) AGAINST ('+query +performace' IN BOOLEAN MODE);
99 SELECT * FROM t1
100 WHERE MATCH (a,b)
101 AGAINST ('performace');
102 id a b
103 SELECT * FROM t1
104 WHERE MATCH (a,b)
105 AGAINST ('+mail +MySQL' IN BOOLEAN MODE);
106 id a b
107 COMMIT;
108 DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('+MySQL' IN BOOLEAN MODE);
109 SELECT * FROM t1;
110 id a b
111 4 Trial version query performace 1255 minute on 2.1Hz Memory 2GB...
112 5 NULL NULL
113 INSERT INTO t1 (a,b) VALUES
114 ('Trial version','query performace 1255 minute on 2.1Hz Memory 2GB...') ,
115 ('when To Use MySQL Well','for free faq [email protected] ...');
116 SELECT * FROM t1;
117 id a b
118 4 Trial version query performace 1255 minute on 2.1Hz Memory 2GB...
119 5 NULL NULL
120 6 Trial version query performace 1255 minute on 2.1Hz Memory 2GB...
121 7 when To Use MySQL Well for free faq [email protected] ...
122 DROP TABLE t1;
123 CREATE TABLE t1 (
124 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
125 a VARCHAR(200),
126 b TEXT
127 ) ENGINE = InnoDB;
128 CREATE FULLTEXT INDEX idx on t1 (a,b);
129 INSERT INTO t1 (a,b) VALUES
130 ('MySQL from Tutorial','DBMS stands for DataBase ...') ,
131 ('when To Use MySQL Well','After that you went through a ...'),
132 ('where will Optimizing MySQL','what In this tutorial we will show ...');
133 START TRANSACTION;
134 INSERT INTO t1 (a,b) VALUES
135 ('MySQL Tutorial','request docteam for oraclehelp.');
136 SELECT * FROM t1
137 WHERE MATCH (a,b)
138 AGAINST ('tutorial' IN NATURAL LANGUAGE MODE);
139 id a b
140 1 MySQL from Tutorial DBMS stands for DataBase ...
141 3 where will Optimizing MySQL what In this tutorial we will show ...
142 SELECT * FROM t1
143 WHERE MATCH (a,b)
144 AGAINST ('request' IN NATURAL LANGUAGE MODE);
145 id a b
146 SELECT * FROM t1
147 WHERE MATCH (a,b)
148 AGAINST ('request MySQL' IN BOOLEAN MODE);
149 id a b
150 1 MySQL from Tutorial DBMS stands for DataBase ...
151 2 when To Use MySQL Well After that you went through a ...
152 3 where will Optimizing MySQL what In this tutorial we will show ...
153 SELECT * FROM t1
154 WHERE MATCH (a,b)
155 AGAINST ('-request +MySQL' IN BOOLEAN MODE);
156 id a b
157 1 MySQL from Tutorial DBMS stands for DataBase ...
158 2 when To Use MySQL Well After that you went through a ...
159 3 where will Optimizing MySQL what In this tutorial we will show ...
160 SELECT * FROM t1
161 WHERE MATCH (a,b)
162 AGAINST ('+MySQL -(Tutorial Optimizing)' IN BOOLEAN MODE);
163 id a b
164 2 when To Use MySQL Well After that you went through a ...
165 SELECT * FROM t1
166 WHERE MATCH (a,b)
167 AGAINST ('tutorial' WITH QUERY EXPANSION);
168 id a b
169 1 MySQL from Tutorial DBMS stands for DataBase ...
170 3 where will Optimizing MySQL what In this tutorial we will show ...
171 2 when To Use MySQL Well After that you went through a ...
172 SELECT * FROM t1
173 WHERE MATCH (a,b)
174 AGAINST ('tutorial' WITH QUERY EXPANSION);
175 id a b
176 1 MySQL from Tutorial DBMS stands for DataBase ...
177 3 where will Optimizing MySQL what In this tutorial we will show ...
178 2 when To Use MySQL Well After that you went through a ...
179 ROLLBACK;
180 SELECT * FROM t1
181 WHERE MATCH (a,b)
182 AGAINST ('tutorial' IN NATURAL LANGUAGE MODE);
183 id a b
184 1 MySQL from Tutorial DBMS stands for DataBase ...
185 3 where will Optimizing MySQL what In this tutorial we will show ...
186 SELECT * FROM t1
187 WHERE MATCH (a,b)
188 AGAINST ('request MySQL' IN BOOLEAN MODE);
189 id a b
190 1 MySQL from Tutorial DBMS stands for DataBase ...
191 2 when To Use MySQL Well After that you went through a ...
192 3 where will Optimizing MySQL what In this tutorial we will show ...
193 SELECT * FROM t1
194 WHERE MATCH (a,b)
195 AGAINST ('tutorial' WITH QUERY EXPANSION);
196 id a b
197 1 MySQL from Tutorial DBMS stands for DataBase ...
198 3 where will Optimizing MySQL what In this tutorial we will show ...
199 2 when To Use MySQL Well After that you went through a ...
200 START TRANSACTION;
201 INSERT INTO t1 (a,b) VALUES (NULL,NULL);
202 UPDATE t1 SET a = 'Trial version' , b = 'query performace 1255 minute on 2.1Hz Memory 2GB...'
203 WHERE MATCH (a,b) AGAINST ('+request +MySQL' IN BOOLEAN MODE);
204 SELECT * FROM t1
205 WHERE MATCH (a,b)
206 AGAINST ('request');
207 id a b
208 SELECT * FROM t1
209 WHERE MATCH (a,b)
210 AGAINST ('query performace' IN BOOLEAN MODE);
211 id a b
212 UPDATE t1 SET a = 'when To Use MySQL Well' , b = 'for free faq xyz.com ...'
213 WHERE MATCH (a,b) AGAINST ('+query +performace' IN BOOLEAN MODE);
214 SELECT * FROM t1
215 WHERE MATCH (a,b)
216 AGAINST ('performace');
217 id a b
218 SELECT * FROM t1
219 WHERE MATCH (a,b)
220 AGAINST ('+mail +MySQL' IN BOOLEAN MODE);
221 id a b
222 ROLLBACK;
223 DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('+MySQL' IN BOOLEAN MODE);
224 SELECT * FROM t1;
225 id a b
226 INSERT INTO t1 (a,b) VALUES
227 ('Trial version','query performace 1255 minute on 2.1Hz Memory 2GB...') ,
228 ('when To Use MySQL Well','for free faq [email protected] ...');
229 SELECT * FROM t1;
230 id a b
231 6 Trial version query performace 1255 minute on 2.1Hz Memory 2GB...
232 7 when To Use MySQL Well for free faq [email protected] ...
233 DROP TABLE t1;
234 CREATE TABLE t1 (
235 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
236 a VARCHAR(200),
237 b TEXT
238 ) ENGINE = InnoDB;
239 CREATE FULLTEXT INDEX idx on t1 (a,b);
240 INSERT INTO t1 (a,b) VALUES
241 ('MySQL from Tutorial','DBMS stands for DataBase ...') ,
242 ('when To Use MySQL Well','After that you went through a ...'),
243 ('where will Optimizing MySQL','what In this tutorial we will show ...');
244 INSERT INTO t1 (a,b) VALUES
245 ('MySQL Tutorial','request docteam for oraclehelp.');
246 START TRANSACTION;
247 INSERT INTO t1 (a,b) VALUES (NULL,NULL);
248 SELECT * FROM t1
249 WHERE MATCH (a,b)
250 AGAINST ('+request +MySQL' IN BOOLEAN MODE);
251 id a b
252 4 MySQL Tutorial request docteam for oraclehelp.
253 UPDATE t1 SET a = 'Trial version' , b = 'query performace 1255 minute on 2.1Hz Memory 2GB...' WHERE MATCH (a,b) AGAINST ('+request +MySQL' IN BOOLEAN MODE);
254 SELECT * from t1;
255 id a b
256 1 MySQL from Tutorial DBMS stands for DataBase ...
257 2 when To Use MySQL Well After that you went through a ...
258 3 where will Optimizing MySQL what In this tutorial we will show ...
259 4 Trial version query performace 1255 minute on 2.1Hz Memory 2GB...
260 5 NULL NULL
261 SELECT * FROM t1
262 WHERE MATCH (a,b)
263 AGAINST ('request');
264 id a b
265 SELECT * FROM t1
266 WHERE MATCH (a,b)
267 AGAINST ('query performace' IN BOOLEAN MODE);
268 id a b
269 UPDATE t1 SET a = 'when To Use MySQL Well' , b = 'for free faq mail xyz.com ...' WHERE MATCH (a,b) AGAINST ('+query +performace' IN BOOLEAN MODE);
270 UPDATE t1 SET a = 'when To Use MySQL Well' , b = 'for free faq mail xyz.com ...' WHERE b like '%query performace%';
271 SELECT * FROM t1
272 WHERE MATCH (a,b)
273 AGAINST ('performace');
274 id a b
275 SELECT * FROM t1
276 WHERE MATCH (a,b)
277 AGAINST ('+mail +MySQL' IN BOOLEAN MODE);
278 id a b
279 SELECT * from t1;
280 id a b
281 1 MySQL from Tutorial DBMS stands for DataBase ...
282 2 when To Use MySQL Well After that you went through a ...
283 3 where will Optimizing MySQL what In this tutorial we will show ...
284 4 when To Use MySQL Well for free faq mail xyz.com ...
285 5 NULL NULL
286 COMMIT;
287 SELECT * from t1;
288 id a b
289 1 MySQL from Tutorial DBMS stands for DataBase ...
290 2 when To Use MySQL Well After that you went through a ...
291 3 where will Optimizing MySQL what In this tutorial we will show ...
292 4 when To Use MySQL Well for free faq mail xyz.com ...
293 5 NULL NULL
294 DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('+MySQL' IN BOOLEAN MODE);
295 SELECT * FROM t1;
296 id a b
297 5 NULL NULL
298 INSERT INTO t1 (a,b) VALUES
299 ('Trial version','query performace 1255 minute on 2.1Hz Memory 2GB...') ,
300 ('when To Use MySQL Well','for free faq [email protected] ...');
301 SELECT * FROM t1;
302 id a b
303 5 NULL NULL
304 6 Trial version query performace 1255 minute on 2.1Hz Memory 2GB...
305 7 when To Use MySQL Well for free faq [email protected] ...
306 DROP TABLE t1;
307 SET NAMES UTF8;
308 CREATE TABLE t1 (
309 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
310 a VARCHAR(200),
311 b TEXT
312 ) CHARACTER SET = UTF8,ENGINE = InnoDB;
313 connect con1,localhost,root,,;
314 SET NAMES UTF8;
315 INSERT INTO t1 (a,b) VALUES
316 ('MySQL from Tutorial','DBMS stands for DataBase ...') ,
317 ('when To Use MySQL Well','After that you went through a ...'),
318 ('where will Optimizing MySQL','what In this tutorial we will show ...'),
319 ('Я могу есть стекло', 'оно мне Mне вредит'),
320 ('Μπορῶ νὰ φάω σπασμένα' ,'γυαλιὰ χωρὶς νὰ πάθω τίποτα'),
321 ('Sævör grét', 'áðan því úlpan var ónýt');
322 connect con2,localhost,root,,;
323 SET NAMES UTF8;
324 CREATE FULLTEXT INDEX idx on t1 (a,b);
325 connection con1;
326 SELECT * FROM t1
327 WHERE MATCH (a,b)
328 AGAINST ('tutorial' IN NATURAL LANGUAGE MODE);
329 id a b
330 1 MySQL from Tutorial DBMS stands for DataBase ...
331 3 where will Optimizing MySQL what In this tutorial we will show ...
332 INSERT INTO t1 (a,b) VALUES
333 ('adding record using session 1','for verifying multiple concurrent transactions'),
334 ('Мога да ям стъкло', 'то Mне ми вреди');
335 SELECT * FROM t1
336 WHERE MATCH (a,b)
337 AGAINST ('+γυαλιὰ +χωρὶ*' IN BOOLEAN MODE);
338 id a b
339 5 Μπορῶ νὰ φάω σπασμένα γυαλιὰ χωρὶς νὰ πάθω τίποτα
340 START TRANSACTION;
341 INSERT INTO t1 (a,b) VALUES
342 ('MySQL Tutorial','request docteam for oraclehelp.'),
343 ('Příliš žluťoučký kůň', 'úpěl ďábelské kódy');
344 SELECT * FROM t1
345 WHERE MATCH (a,b)
346 AGAINST ('request ďábelské' IN BOOLEAN MODE);
347 id a b
348 SELECT * FROM t1
349 WHERE MATCH (a,b)
350 AGAINST ('tutorial' WITH QUERY EXPANSION) ORDER BY 1;
351 id a b
352 1 MySQL from Tutorial DBMS stands for DataBase ...
353 2 when To Use MySQL Well After that you went through a ...
354 3 where will Optimizing MySQL what In this tutorial we will show ...
355 SELECT * FROM t1
356 WHERE MATCH (a,b)
357 AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
358 id a b
359 6 Sævör grét áðan því úlpan var ónýt
360 connection con2;
361 SELECT * FROM t1
362 WHERE MATCH (a,b)
363 AGAINST ('+record +multiple' IN BOOLEAN MODE);
364 id a b
365 7 adding record using session 1 for verifying multiple concurrent transactions
366 SELECT * FROM t1
367 WHERE MATCH (a,b)
368 AGAINST ('tutor* Sævö*' IN BOOLEAN MODE) ORDER BY 1;
369 id a b
370 1 MySQL from Tutorial DBMS stands for DataBase ...
371 3 where will Optimizing MySQL what In this tutorial we will show ...
372 6 Sævör grét áðan því úlpan var ónýt
373 SELECT * FROM t1
374 WHERE MATCH (a,b)
375 AGAINST ('usin* multipl*' IN BOOLEAN MODE);
376 id a b
377 7 adding record using session 1 for verifying multiple concurrent transactions
378 SELECT * FROM t1
379 WHERE MATCH (a,b)
380 AGAINST ('"request docteam"@08' IN BOOLEAN MODE);
381 id a b
382 SELECT * FROM t1
383 WHERE MATCH (a,b)
384 AGAINST ('request' IN NATURAL LANGUAGE MODE);
385 id a b
386 SELECT * FROM t1
387 WHERE MATCH (a,b)
388 AGAINST ('request MySQL' IN BOOLEAN MODE);
389 id a b
390 1 MySQL from Tutorial DBMS stands for DataBase ...
391 2 when To Use MySQL Well After that you went through a ...
392 3 where will Optimizing MySQL what In this tutorial we will show ...
393 SELECT * FROM t1
394 WHERE MATCH (a,b)
395 AGAINST ('-request +MySQL' IN BOOLEAN MODE);
396 id a b
397 1 MySQL from Tutorial DBMS stands for DataBase ...
398 2 when To Use MySQL Well After that you went through a ...
399 3 where will Optimizing MySQL what In this tutorial we will show ...
400 SELECT * FROM t1
401 WHERE MATCH (a,b)
402 AGAINST ('+MySQL -(Tutorial Optimizing)' IN BOOLEAN MODE);
403 id a b
404 2 when To Use MySQL Well After that you went through a ...
405 SELECT * FROM t1
406 WHERE MATCH (a,b)
407 AGAINST ('"stands Database"@11' IN BOOLEAN MODE) ORDER BY 1;
408 id a b
409 1 MySQL from Tutorial DBMS stands for DataBase ...
410 SELECT * FROM t1
411 WHERE MATCH (a,b)
412 AGAINST ('tutorial' WITH QUERY EXPANSION) ORDER BY 1;
413 id a b
414 1 MySQL from Tutorial DBMS stands for DataBase ...
415 2 when To Use MySQL Well After that you went through a ...
416 3 where will Optimizing MySQL what In this tutorial we will show ...
417 connection con1;
418 COMMIT;
419 SELECT * FROM t1
420 WHERE MATCH (a,b)
421 AGAINST ('+request +MySQL' IN BOOLEAN MODE);
422 id a b
423 9 MySQL Tutorial request docteam for oraclehelp.
424 SELECT * FROM t1
425 WHERE MATCH (a,b)
426 AGAINST ('Příliš žluťoučký' IN BOOLEAN MODE);
427 id a b
428 10 Příliš žluťoučký kůň úpěl ďábelské kódy
429 SELECT * FROM t1
430 WHERE MATCH (a,b)
431 AGAINST ('Příliš');
432 id a b
433 10 Příliš žluťoučký kůň úpěl ďábelské kódy
434 INSERT INTO t1 (a,b) VALUES (NULL,NULL);
435 SELECT * FROM t1 WHERE a IS NULL AND b IS NULL;
436 id a b
437 11 NULL NULL
438 connection con2;
439 SELECT * FROM t1
440 WHERE MATCH (a,b)
441 AGAINST ('usin* multipl*' IN BOOLEAN MODE);
442 id a b
443 7 adding record using session 1 for verifying multiple concurrent transactions
444 SELECT * FROM t1
445 WHERE MATCH (a,b)
446 AGAINST ('+request +MySQL' IN BOOLEAN MODE);
447 id a b
448 9 MySQL Tutorial request docteam for oraclehelp.
449 SELECT * FROM t1 WHERE a IS NULL AND b IS NULL;
450 id a b
451 11 NULL NULL
452 ALTER TABLE t1 DROP INDEX idx;
453 CREATE FULLTEXT INDEX idx on t1 (a,b);
454 START TRANSACTION;
455 UPDATE t1 SET a = 'Trial version Příliš žluťoučký' , b = 'query performace 1255 minute on 2.1Hz Memory 2GB...'
456 WHERE MATCH (a,b) AGAINST ('+request +MySQL' IN BOOLEAN MODE);
457 SELECT * FROM t1
458 WHERE MATCH (a,b)
459 AGAINST ('request');
460 id a b
461 SELECT * FROM t1
462 WHERE MATCH (a,b)
463 AGAINST ('+query +performace' IN BOOLEAN MODE);
464 id a b
465 UPDATE t1 SET a = UPPER(a) WHERE MATCH (a,b) AGAINST ('+Příliš +žluťoučký' IN BOOLEAN MODE);
466 SELECT * FROM t1
467 WHERE MATCH (a,b)
468 AGAINST ('+Příliš +žluťoučký' IN BOOLEAN MODE);
469 id a b
470 UPDATE t1 SET a = UPPER(a) WHERE a LIKE '%version Příliš%';
471 SELECT * FROM t1
472 WHERE MATCH (a,b)
473 AGAINST ('+query +performace' IN BOOLEAN MODE);
474 id a b
475 SELECT * FROM t1 WHERE b LIKE '%query performace%';
476 id a b
477 9 TRIAL VERSION PŘÍLIŠ ŽLUŤOUČKÝ query performace 1255 minute on 2.1Hz Memory 2GB...
478 SELECT * FROM t1
479 WHERE MATCH (a,b)
480 AGAINST ('request');
481 id a b
482 connection con1;
483 SELECT * FROM t1
484 WHERE MATCH (a,b)
485 AGAINST ('query performace' IN BOOLEAN MODE);
486 id a b
487 SELECT * FROM t1
488 WHERE MATCH (a,b)
489 AGAINST ('performace');
490 id a b
491 SELECT * FROM t1
492 WHERE MATCH (a,b)
493 AGAINST ('+mail +MySQL' IN BOOLEAN MODE);
494 id a b
495 connection con2;
496 COMMIT;
497 SELECT * FROM t1
498 WHERE MATCH (a,b)
499 AGAINST ('+query +performace' IN BOOLEAN MODE);
500 id a b
501 9 TRIAL VERSION PŘÍLIŠ ŽLUŤOUČKÝ query performace 1255 minute on 2.1Hz Memory 2GB...
502 connection con1;
503 SELECT * FROM t1
504 WHERE MATCH (a,b)
505 AGAINST ('+query +performace' IN BOOLEAN MODE);
506 id a b
507 9 TRIAL VERSION PŘÍLIŠ ŽLUŤOUČKÝ query performace 1255 minute on 2.1Hz Memory 2GB...
508 UPDATE t1 SET a = 'when To Use MySQL Well' , b = 'for free faq xyz.com ...'
509 WHERE MATCH (a,b) AGAINST ('+πάθω +τίποτα' IN BOOLEAN MODE);
510 SELECT * FROM t1
511 WHERE MATCH (a,b)
512 AGAINST ('well free') ORDER BY 1;
513 id a b
514 2 when To Use MySQL Well After that you went through a ...
515 5 when To Use MySQL Well for free faq xyz.com ...
516 disconnect con1;
517 disconnect con2;
518 connection default;
519 DROP TABLE t1;
520 SET NAMES UTF8;
521 CREATE TABLE t1 (
522 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
523 a VARCHAR(200),
524 b TEXT
525 ) CHARACTER SET = UTF8,ENGINE = InnoDB;
526 connect con1,localhost,root,,;
527 SET NAMES UTF8;
528 INSERT INTO t1 (a,b) VALUES
529 ('MySQL from Tutorial','DBMS stands for DataBase ...') ,
530 ('when To Use MySQL Well','After that you went through a ...'),
531 ('where will Optimizing MySQL','what In this tutorial we will show ...'),
532 ('Я могу есть стекло', 'оно мне Mне вредит'),
533 ('Μπορῶ νὰ φάω σπασμένα' ,'γυαλιὰ χωρὶς νὰ πάθω τίποτα'),
534 ('Sævör grét', 'áðan því úlpan var ónýt');
535 connect con2,localhost,root,,;
536 SET NAMES UTF8;
537 select @@session.transaction_isolation;
538 @@session.transaction_isolation
539 REPEATABLE-READ
540 CREATE FULLTEXT INDEX idx on t1 (a,b);
541 INSERT INTO t1 (a,b) VALUES
542 ('adding record using session 1','for verifying multiple concurrent transactions'),
543 ('Мога да ям стъкло', 'то Mне ми вреди');
544 connection con1;
545 SELECT * FROM t1;
546 id a b
547 1 MySQL from Tutorial DBMS stands for DataBase ...
548 2 when To Use MySQL Well After that you went through a ...
549 3 where will Optimizing MySQL what In this tutorial we will show ...
550 4 Я могу есть стекло оно мне Mне вредит
551 5 Μπορῶ νὰ φάω σπασμένα γυαλιὰ χωρὶς νὰ πάθω τίποτα
552 6 Sævör grét áðan því úlpan var ónýt
553 7 adding record using session 1 for verifying multiple concurrent transactions
554 8 Мога да ям стъкло то Mне ми вреди
555 START TRANSACTION;
556 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Мога +Mне' IN BOOLEAN MODE);
557 id a b
558 8 Мога да ям стъкло то Mне ми вреди
559 DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('+Мога +Mне' IN BOOLEAN MODE);
560 DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
561 SELECT * FROM t1;
562 id a b
563 1 MySQL from Tutorial DBMS stands for DataBase ...
564 2 when To Use MySQL Well After that you went through a ...
565 3 where will Optimizing MySQL what In this tutorial we will show ...
566 4 Я могу есть стекло оно мне Mне вредит
567 5 Μπορῶ νὰ φάω σπασμένα γυαλιὰ χωρὶς νὰ πάθω τίποτα
568 7 adding record using session 1 for verifying multiple concurrent transactions
569 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
570 id a b
571 4 Я могу есть стекло оно мне Mне вредит
572 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
573 id a b
574 4 Я могу есть стекло оно мне Mне вредит
575 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
576 id a b
577 SELECT * FROM t1;
578 id a b
579 1 MySQL from Tutorial DBMS stands for DataBase ...
580 2 when To Use MySQL Well After that you went through a ...
581 3 where will Optimizing MySQL what In this tutorial we will show ...
582 4 Я могу есть стекло оно мне Mне вредит
583 5 Μπορῶ νὰ φάω σπασμένα γυαλιὰ χωρὶς νὰ πάθω τίποτα
584 7 adding record using session 1 for verifying multiple concurrent transactions
585 connection con2;
586 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
587 id a b
588 4 Я могу есть стекло оно мне Mне вредит
589 8 Мога да ям стъкло то Mне ми вреди
590 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
591 id a b
592 4 Я могу есть стекло оно мне Mне вредит
593 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
594 id a b
595 6 Sævör grét áðan því úlpan var ónýt
596 SELECT * FROM t1;
597 id a b
598 1 MySQL from Tutorial DBMS stands for DataBase ...
599 2 when To Use MySQL Well After that you went through a ...
600 3 where will Optimizing MySQL what In this tutorial we will show ...
601 4 Я могу есть стекло оно мне Mне вредит
602 5 Μπορῶ νὰ φάω σπασμένα γυαλιὰ χωρὶς νὰ πάθω τίποτα
603 6 Sævör grét áðan því úlpan var ónýt
604 7 adding record using session 1 for verifying multiple concurrent transactions
605 8 Мога да ям стъкло то Mне ми вреди
606 connection con1;
607 COMMIT;
608 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
609 id a b
610 4 Я могу есть стекло оно мне Mне вредит
611 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
612 id a b
613 4 Я могу есть стекло оно мне Mне вредит
614 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
615 id a b
616 connection con2;
617 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
618 id a b
619 4 Я могу есть стекло оно мне Mне вредит
620 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
621 id a b
622 4 Я могу есть стекло оно мне Mне вредит
623 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
624 id a b
625 SELECT * FROM t1;
626 id a b
627 1 MySQL from Tutorial DBMS stands for DataBase ...
628 2 when To Use MySQL Well After that you went through a ...
629 3 where will Optimizing MySQL what In this tutorial we will show ...
630 4 Я могу есть стекло оно мне Mне вредит
631 5 Μπορῶ νὰ φάω σπασμένα γυαλιὰ χωρὶς νὰ πάθω τίποτα
632 7 adding record using session 1 for verifying multiple concurrent transactions
633 disconnect con1;
634 disconnect con2;
635 connection default;
636 DROP TABLE t1;
637 SET NAMES UTF8;
638 CREATE TABLE t1 (
639 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
640 a VARCHAR(200),
641 b TEXT
642 ) CHARACTER SET = UTF8,ENGINE = InnoDB;
643 connect con1,localhost,root,,;
644 SET NAMES UTF8;
645 INSERT INTO t1 (a,b) VALUES
646 ('MySQL from Tutorial','DBMS stands for DataBase ...') ,
647 ('when To Use MySQL Well','After that you went through a ...'),
648 ('where will Optimizing MySQL','what In this tutorial we will show ...'),
649 ('Я могу есть стекло', 'оно мне Mне вредит');
650 connect con2,localhost,root,,;
651 SET NAMES UTF8;
652 select @@session.transaction_isolation;
653 @@session.transaction_isolation
654 REPEATABLE-READ
655 CREATE FULLTEXT INDEX idx on t1 (a,b);
656 INSERT INTO t1 (a,b) VALUES
657 ('adding record using session 1','for verifying multiple concurrent transactions'),
658 ('Мога да ям стъкло', 'то Mне ми вреди');
659 connection con1;
660 SELECT * FROM t1;
661 id a b
662 1 MySQL from Tutorial DBMS stands for DataBase ...
663 2 when To Use MySQL Well After that you went through a ...
664 3 where will Optimizing MySQL what In this tutorial we will show ...
665 4 Я могу есть стекло оно мне Mне вредит
666 5 adding record using session 1 for verifying multiple concurrent transactions
667 6 Мога да ям стъкло то Mне ми вреди
668 START TRANSACTION;
669 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Мога +Mне' IN BOOLEAN MODE);
670 id a b
671 6 Мога да ям стъкло то Mне ми вреди
672 UPDATE t1 SET a = 'Μπορῶ νὰ φάω σπασμένα' , b = 'γυαλιὰ χωρὶς νὰ πάθω τίποτα' WHERE MATCH (a,b) AGAINST ('+могу +Mне' IN BOOLEAN MODE);
673 INSERT INTO t1(a,b) VALUES ('Sævör grét', 'áðan því úlpan var ónýt');
674 SELECT * FROM t1;
675 id a b
676 1 MySQL from Tutorial DBMS stands for DataBase ...
677 2 when To Use MySQL Well After that you went through a ...
678 3 where will Optimizing MySQL what In this tutorial we will show ...
679 4 Μπορῶ νὰ φάω σπασμένα γυαλιὰ χωρὶς νὰ πάθω τίποτα
680 5 adding record using session 1 for verifying multiple concurrent transactions
681 6 Мога да ям стъкло то Mне ми вреди
682 7 Sævör grét áðan því úlpan var ónýt
683 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
684 id a b
685 6 Мога да ям стъкло то Mне ми вреди
686 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
687 id a b
688 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
689 id a b
690 1 MySQL from Tutorial DBMS stands for DataBase ...
691 SELECT * FROM t1;
692 id a b
693 1 MySQL from Tutorial DBMS stands for DataBase ...
694 2 when To Use MySQL Well After that you went through a ...
695 3 where will Optimizing MySQL what In this tutorial we will show ...
696 4 Μπορῶ νὰ φάω σπασμένα γυαλιὰ χωρὶς νὰ πάθω τίποτα
697 5 adding record using session 1 for verifying multiple concurrent transactions
698 6 Мога да ям стъкло то Mне ми вреди
699 7 Sævör grét áðan því úlpan var ónýt
700 connection con2;
701 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
702 id a b
703 4 Я могу есть стекло оно мне Mне вредит
704 6 Мога да ям стъкло то Mне ми вреди
705 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
706 id a b
707 4 Я могу есть стекло оно мне Mне вредит
708 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
709 id a b
710 1 MySQL from Tutorial DBMS stands for DataBase ...
711 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
712 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
713 id a b
714 6 Мога да ям стъкло то Mне ми вреди
715 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
716 id a b
717 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
718 id a b
719 1 MySQL from Tutorial DBMS stands for DataBase ...
720 SELECT * FROM t1;
721 id a b
722 1 MySQL from Tutorial DBMS stands for DataBase ...
723 2 when To Use MySQL Well After that you went through a ...
724 3 where will Optimizing MySQL what In this tutorial we will show ...
725 4 Μπορῶ νὰ φάω σπασμένα γυαλιὰ χωρὶς νὰ πάθω τίποτα
726 5 adding record using session 1 for verifying multiple concurrent transactions
727 6 Мога да ям стъкло то Mне ми вреди
728 7 Sævör grét áðan því úlpan var ónýt
729 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
730 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
731 id a b
732 4 Я могу есть стекло оно мне Mне вредит
733 6 Мога да ям стъкло то Mне ми вреди
734 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
735 id a b
736 4 Я могу есть стекло оно мне Mне вредит
737 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
738 id a b
739 1 MySQL from Tutorial DBMS stands for DataBase ...
740 SELECT * FROM t1;
741 id a b
742 1 MySQL from Tutorial DBMS stands for DataBase ...
743 2 when To Use MySQL Well After that you went through a ...
744 3 where will Optimizing MySQL what In this tutorial we will show ...
745 4 Я могу есть стекло оно мне Mне вредит
746 5 adding record using session 1 for verifying multiple concurrent transactions
747 6 Мога да ям стъкло то Mне ми вреди
748 connection con1;
749 COMMIT;
750 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
751 id a b
752 6 Мога да ям стъкло то Mне ми вреди
753 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
754 id a b
755 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
756 id a b
757 7 Sævör grét áðan því úlpan var ónýt
758 connection con2;
759 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
760 id a b
761 6 Мога да ям стъкло то Mне ми вреди
762 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
763 id a b
764 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
765 id a b
766 7 Sævör grét áðan því úlpan var ónýt
767 SELECT * FROM t1;
768 id a b
769 1 MySQL from Tutorial DBMS stands for DataBase ...
770 2 when To Use MySQL Well After that you went through a ...
771 3 where will Optimizing MySQL what In this tutorial we will show ...
772 4 Μπορῶ νὰ φάω σπασμένα γυαλιὰ χωρὶς νὰ πάθω τίποτα
773 5 adding record using session 1 for verifying multiple concurrent transactions
774 6 Мога да ям стъкло то Mне ми вреди
775 7 Sævör grét áðan því úlpan var ónýt
776 disconnect con1;
777 disconnect con2;
778 connection default;
779 DROP TABLE t1;
780 SET NAMES UTF8;
781 CREATE TABLE t1 (
782 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
783 a VARCHAR(200),
784 b TEXT
785 ) CHARACTER SET = UTF8,ENGINE = InnoDB;
786 connect con1,localhost,root,,;
787 SET NAMES UTF8;
788 INSERT INTO t1 (a,b) VALUES
789 ('MySQL from Tutorial','DBMS stands for DataBase ...') ,
790 ('when To Use MySQL Well','After that you went through a ...'),
791 ('where will Optimizing MySQL','what In this tutorial we will show ...'),
792 ('Я могу есть стекло', 'оно мне Mне вредит'),
793 ('Μπορῶ νὰ φάω σπασμένα' ,'γυαλιὰ χωρὶς νὰ πάθω τίποτα'),
794 ('Sævör grét', 'áðan því úlpan var ónýt');
795 connect con2,localhost,root,,;
796 SET NAMES UTF8;
797 select @@session.transaction_isolation;
798 @@session.transaction_isolation
799 REPEATABLE-READ
800 CREATE FULLTEXT INDEX idx on t1 (a,b);
801 INSERT INTO t1 (a,b) VALUES
802 ('adding record using session 1','for verifying multiple concurrent transactions'),
803 ('Мога да ям стъкло', 'то Mне ми вреди');
804 connection con1;
805 SELECT * FROM t1;
806 id a b
807 1 MySQL from Tutorial DBMS stands for DataBase ...
808 2 when To Use MySQL Well After that you went through a ...
809 3 where will Optimizing MySQL what In this tutorial we will show ...
810 4 Я могу есть стекло оно мне Mне вредит
811 5 Μπορῶ νὰ φάω σπασμένα γυαλιὰ χωρὶς νὰ πάθω τίποτα
812 6 Sævör grét áðan því úlpan var ónýt
813 7 adding record using session 1 for verifying multiple concurrent transactions
814 8 Мога да ям стъкло то Mне ми вреди
815 START TRANSACTION;
816 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Мога +Mне' IN BOOLEAN MODE);
817 id a b
818 8 Мога да ям стъкло то Mне ми вреди
819 DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('+Мога +Mне' IN BOOLEAN MODE);
820 DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
821 SELECT * FROM t1;
822 id a b
823 1 MySQL from Tutorial DBMS stands for DataBase ...
824 2 when To Use MySQL Well After that you went through a ...
825 3 where will Optimizing MySQL what In this tutorial we will show ...
826 4 Я могу есть стекло оно мне Mне вредит
827 5 Μπορῶ νὰ φάω σπασμένα γυαλιὰ χωρὶς νὰ πάθω τίποτα
828 7 adding record using session 1 for verifying multiple concurrent transactions
829 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
830 id a b
831 4 Я могу есть стекло оно мне Mне вредит
832 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
833 id a b
834 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
835 id a b
836 SELECT * FROM t1;
837 id a b
838 1 MySQL from Tutorial DBMS stands for DataBase ...
839 2 when To Use MySQL Well After that you went through a ...
840 3 where will Optimizing MySQL what In this tutorial we will show ...
841 4 Я могу есть стекло оно мне Mне вредит
842 5 Μπορῶ νὰ φάω σπασμένα γυαλιὰ χωρὶς νὰ πάθω τίποτα
843 7 adding record using session 1 for verifying multiple concurrent transactions
844 connection con2;
845 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
846 id a b
847 4 Я могу есть стекло оно мне Mне вредит
848 8 Мога да ям стъкло то Mне ми вреди
849 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
850 id a b
851 8 Мога да ям стъкло то Mне ми вреди
852 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
853 id a b
854 6 Sævör grét áðan því úlpan var ónýt
855 SELECT * FROM t1;
856 id a b
857 1 MySQL from Tutorial DBMS stands for DataBase ...
858 2 when To Use MySQL Well After that you went through a ...
859 3 where will Optimizing MySQL what In this tutorial we will show ...
860 4 Я могу есть стекло оно мне Mне вредит
861 5 Μπορῶ νὰ φάω σπασμένα γυαλιὰ χωρὶς νὰ πάθω τίποτα
862 6 Sævör grét áðan því úlpan var ónýt
863 7 adding record using session 1 for verifying multiple concurrent transactions
864 8 Мога да ям стъкло то Mне ми вреди
865 connection con1;
866 ROLLBACK;
867 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
868 id a b
869 4 Я могу есть стекло оно мне Mне вредит
870 8 Мога да ям стъкло то Mне ми вреди
871 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
872 id a b
873 8 Мога да ям стъкло то Mне ми вреди
874 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
875 id a b
876 6 Sævör grét áðan því úlpan var ónýt
877 connection con2;
878 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
879 id a b
880 4 Я могу есть стекло оно мне Mне вредит
881 8 Мога да ям стъкло то Mне ми вреди
882 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
883 id a b
884 8 Мога да ям стъкло то Mне ми вреди
885 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
886 id a b
887 6 Sævör grét áðan því úlpan var ónýt
888 SELECT * FROM t1;
889 id a b
890 1 MySQL from Tutorial DBMS stands for DataBase ...
891 2 when To Use MySQL Well After that you went through a ...
892 3 where will Optimizing MySQL what In this tutorial we will show ...
893 4 Я могу есть стекло оно мне Mне вредит
894 5 Μπορῶ νὰ φάω σπασμένα γυαλιὰ χωρὶς νὰ πάθω τίποτα
895 6 Sævör grét áðan því úlpan var ónýt
896 7 adding record using session 1 for verifying multiple concurrent transactions
897 8 Мога да ям стъкло то Mне ми вреди
898 disconnect con1;
899 disconnect con2;
900 connection default;
901 DROP TABLE t1;
902 SET NAMES UTF8;
903 CREATE TABLE t1 (
904 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
905 a VARCHAR(200),
906 b TEXT
907 ) CHARACTER SET = UTF8,ENGINE = InnoDB;
908 connect con1,localhost,root,,;
909 SET NAMES UTF8;
910 INSERT INTO t1 (a,b) VALUES
911 ('MySQL from Tutorial','DBMS stands for DataBase ...') ,
912 ('when To Use MySQL Well','After that you went through a ...'),
913 ('where will Optimizing MySQL','what In this tutorial we will show ...'),
914 ('Я могу есть стекло', 'оно мне Mне вредит');
915 connect con2,localhost,root,,;
916 SET NAMES UTF8;
917 select @@session.transaction_isolation;
918 @@session.transaction_isolation
919 REPEATABLE-READ
920 CREATE FULLTEXT INDEX idx on t1 (a,b);
921 INSERT INTO t1 (a,b) VALUES
922 ('adding record using session 1','for verifying multiple concurrent transactions'),
923 ('Мога да ям стъкло', 'то Mне ми вреди');
924 connection con1;
925 SELECT * FROM t1;
926 id a b
927 1 MySQL from Tutorial DBMS stands for DataBase ...
928 2 when To Use MySQL Well After that you went through a ...
929 3 where will Optimizing MySQL what In this tutorial we will show ...
930 4 Я могу есть стекло оно мне Mне вредит
931 5 adding record using session 1 for verifying multiple concurrent transactions
932 6 Мога да ям стъкло то Mне ми вреди
933 START TRANSACTION;
934 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+могу +Mне' IN BOOLEAN MODE);
935 id a b
936 4 Я могу есть стекло оно мне Mне вредит
937 UPDATE t1 SET a = 'Μπορῶ νὰ φάω σπασμένα' , b = 'γυαλιὰ χωρὶς νὰ πάθω τίποτα' WHERE MATCH (a,b) AGAINST ('+могу +Mне' IN BOOLEAN MODE);
938 INSERT INTO t1(a,b) VALUES ('Sævör grét', 'áðan því úlpan var ónýt');
939 SELECT * FROM t1;
940 id a b
941 1 MySQL from Tutorial DBMS stands for DataBase ...
942 2 when To Use MySQL Well After that you went through a ...
943 3 where will Optimizing MySQL what In this tutorial we will show ...
944 4 Μπορῶ νὰ φάω σπασμένα γυαλιὰ χωρὶς νὰ πάθω τίποτα
945 5 adding record using session 1 for verifying multiple concurrent transactions
946 6 Мога да ям стъкло то Mне ми вреди
947 7 Sævör grét áðan því úlpan var ónýt
948 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
949 id a b
950 6 Мога да ям стъкло то Mне ми вреди
951 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
952 id a b
953 6 Мога да ям стъкло то Mне ми вреди
954 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
955 id a b
956 1 MySQL from Tutorial DBMS stands for DataBase ...
957 SELECT * FROM t1;
958 id a b
959 1 MySQL from Tutorial DBMS stands for DataBase ...
960 2 when To Use MySQL Well After that you went through a ...
961 3 where will Optimizing MySQL what In this tutorial we will show ...
962 4 Μπορῶ νὰ φάω σπασμένα γυαλιὰ χωρὶς νὰ πάθω τίποτα
963 5 adding record using session 1 for verifying multiple concurrent transactions
964 6 Мога да ям стъкло то Mне ми вреди
965 7 Sævör grét áðan því úlpan var ónýt
966 connection con2;
967 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
968 id a b
969 4 Я могу есть стекло оно мне Mне вредит
970 6 Мога да ям стъкло то Mне ми вреди
971 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
972 id a b
973 6 Мога да ям стъкло то Mне ми вреди
974 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
975 id a b
976 1 MySQL from Tutorial DBMS stands for DataBase ...
977 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
978 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
979 id a b
980 6 Мога да ям стъкло то Mне ми вреди
981 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
982 id a b
983 6 Мога да ям стъкло то Mне ми вреди
984 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
985 id a b
986 1 MySQL from Tutorial DBMS stands for DataBase ...
987 SELECT * FROM t1;
988 id a b
989 1 MySQL from Tutorial DBMS stands for DataBase ...
990 2 when To Use MySQL Well After that you went through a ...
991 3 where will Optimizing MySQL what In this tutorial we will show ...
992 4 Μπορῶ νὰ φάω σπασμένα γυαλιὰ χωρὶς νὰ πάθω τίποτα
993 5 adding record using session 1 for verifying multiple concurrent transactions
994 6 Мога да ям стъкло то Mне ми вреди
995 7 Sævör grét áðan því úlpan var ónýt
996 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
997 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
998 id a b
999 4 Я могу есть стекло оно мне Mне вредит
1000 6 Мога да ям стъкло то Mне ми вреди
1001 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
1002 id a b
1003 6 Мога да ям стъкло то Mне ми вреди
1004 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
1005 id a b
1006 1 MySQL from Tutorial DBMS stands for DataBase ...
1007 SELECT * FROM t1;
1008 id a b
1009 1 MySQL from Tutorial DBMS stands for DataBase ...
1010 2 when To Use MySQL Well After that you went through a ...
1011 3 where will Optimizing MySQL what In this tutorial we will show ...
1012 4 Я могу есть стекло оно мне Mне вредит
1013 5 adding record using session 1 for verifying multiple concurrent transactions
1014 6 Мога да ям стъкло то Mне ми вреди
1015 connection con1;
1016 ROLLBACK;
1017 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
1018 id a b
1019 4 Я могу есть стекло оно мне Mне вредит
1020 6 Мога да ям стъкло то Mне ми вреди
1021 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
1022 id a b
1023 6 Мога да ям стъкло то Mне ми вреди
1024 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
1025 id a b
1026 connection con2;
1027 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
1028 id a b
1029 4 Я могу есть стекло оно мне Mне вредит
1030 6 Мога да ям стъкло то Mне ми вреди
1031 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
1032 id a b
1033 6 Мога да ям стъкло то Mне ми вреди
1034 SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
1035 id a b
1036 SELECT * FROM t1;
1037 id a b
1038 1 MySQL from Tutorial DBMS stands for DataBase ...
1039 2 when To Use MySQL Well After that you went through a ...
1040 3 where will Optimizing MySQL what In this tutorial we will show ...
1041 4 Я могу есть стекло оно мне Mне вредит
1042 5 adding record using session 1 for verifying multiple concurrent transactions
1043 6 Мога да ям стъкло то Mне ми вреди
1044 disconnect con1;
1045 disconnect con2;
1046 connection default;
1047 DROP TABLE t1;