Debian Codegraph @

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