Debian Codegraph @

mysql-test/suite/maria/fulltext2.result

raw
1 CREATE TABLE t1 (
2 i int(10) unsigned not null auto_increment primary key,
3 a varchar(255) not null,
4 FULLTEXT KEY (a)
5 ) ENGINE=Aria ROW_FORMAT=DYNAMIC MAX_ROWS=2000000000000;
6 repair table t1 quick;
7 Table Op Msg_type Msg_text
8 test.t1 repair status OK
9 check table t1;
10 Table Op Msg_type Msg_text
11 test.t1 check status OK
12 repair table t1;
13 Table Op Msg_type Msg_text
14 test.t1 repair status OK
15 check table t1;
16 Table Op Msg_type Msg_text
17 test.t1 check status OK
18 repair table t1;
19 Table Op Msg_type Msg_text
20 test.t1 repair status OK
21 select count(*) from t1 where match a against ('aaaxxx');
22 count(*)
23 0
24 select count(*) from t1 where match a against ('aaayyy');
25 count(*)
26 150
27 select count(*) from t1 where match a against ('aaaxxx' in boolean mode);
28 count(*)
29 1024
30 select count(*) from t1 where match a against ('aaayyy' in boolean mode);
31 count(*)
32 150
33 select count(*) from t1 where match a against ('aaax*' in boolean mode);
34 count(*)
35 1024
36 select count(*) from t1 where match a against ('aaay*' in boolean mode);
37 count(*)
38 150
39 select count(*) from t1 where match a against ('aaa*' in boolean mode);
40 count(*)
41 1174
42 insert t1 (a) values ('aaaxxx'),('aaayyy');
43 select count(*) from t1 where match a against ('aaaxxx' in boolean mode);
44 count(*)
45 1025
46 select count(*) from t1 where match a against ('aaayyy');
47 count(*)
48 151
49 insert t1 (a) values ('aaaxxx 000000');
50 select count(*) from t1 where match a against ('000000');
51 count(*)
52 1
53 delete from t1 where match a against ('000000');
54 select count(*) from t1 where match a against ('000000');
55 count(*)
56 0
57 select count(*) from t1 where match a against ('aaaxxx');
58 count(*)
59 0
60 select count(*) from t1 where match a against ('aaaxxx' in boolean mode);
61 count(*)
62 1025
63 select count(*) from t1 where match a against ('aaayyy' in boolean mode);
64 count(*)
65 151
66 select count(*) from t1 where a = 'aaaxxx';
67 count(*)
68 1025
69 select count(*) from t1 where a = 'aaayyy';
70 count(*)
71 151
72 insert t1 (a) values ('aaaxxx 000000');
73 select count(*) from t1 where match a against ('000000');
74 count(*)
75 1
76 select count(*) from t1 where match a against ('aaaxxx' in boolean mode);
77 count(*)
78 1026
79 update t1 set a='aaaxxx' where a = 'aaayyy';
80 select count(*) from t1 where match a against ('aaaxxx' in boolean mode);
81 count(*)
82 1177
83 select count(*) from t1 where match a against ('aaayyy' in boolean mode);
84 count(*)
85 0
86 drop table t1;
87 set names utf8mb4;
88 create table t1 (a int, b text, fulltext (b)) charset=utf8mb4 collate=utf8mb4_unicode_ci engine=aria;
89 insert t1 values (1000, 'C͓̙̯͔̩ͅͅi̩̘̜̲a̯̲̬̳̜̖̤o͕͓̜͓̺̖̗,̠̬͚ ̺T͇̲h͈̱e ̬̜D̖o̦̖͔̗͖̩̘c̣̼t̝͉̫̮̗o͉̫̭r̙͎̗.͓̪̥');
90 select a from t1 where match(b) against ('ciao' in boolean mode);
91 a
92 1000
93 drop table t1;