Debian Codegraph @

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

raw
1 CREATE TABLE t1 (
2 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
3 a VARCHAR(200),
4 b TEXT
5 ) ENGINE= InnoDB;
6 CREATE FULLTEXT INDEX idx on t1 (a,b);
7 INSERT INTO t1 (a,b) VALUES
8 ('MySQL from Tutorial','DBMS stands for DataBase ...') ,
9 ('when To Use MySQL Well','After that you went through a ...'),
10 ('where will Optimizing MySQL','what In this tutorial we will show ...');
11 SELECT * FROM t1 WHERE MATCH(a,b) AGAINST ("where will");
12 id a b
13 SELECT * FROM t1 WHERE MATCH(a,b) AGAINST ("when");
14 id a b
15 SELECT * FROM t1 WHERE MATCH(a,b) AGAINST ("what" WITH QUERY EXPANSION);
16 id a b
17 SELECT * FROM t1 WHERE MATCH(a,b) AGAINST("whe*" IN BOOLEAN MODE);
18 id a b
19 SELECT * FROM t1 WHERE MATCH(a,b) AGAINST("+what +will" IN BOOLEAN MODE);
20 id a b
21 SELECT * FROM t1 WHERE MATCH(a,b) AGAINST("+from" IN BOOLEAN MODE);
22 id a b
23 SELECT * FROM t1 WHERE MATCH(a,b) AGAINST("+where +(show what)" IN BOOLEAN MODE);
24 id a b
25 SELECT * FROM t1
26 WHERE MATCH (a,b)
27 AGAINST ('"where will"@6' IN BOOLEAN MODE);
28 id a b
29 SELECT * FROM t1
30 WHERE MATCH (a,b)
31 AGAINST ('"where will"@9' IN BOOLEAN MODE);
32 id a b
33 INSERT INTO t1 (a,b) VALUES
34 ('MySQL Tutorial','request [email protected] ...') ,
35 ('Trial version','query performace @1255 minute on 2.1Hz Memory 2GB...') ,
36 ('when To Use MySQL Well','for free faq [email protected] ...');
37 SELECT * FROM t1
38 WHERE MATCH (a,b)
39 AGAINST ('"request"@10' IN BOOLEAN MODE);
40 id a b
41 4 MySQL Tutorial request [email protected] ...
42 SELECT * FROM t1
43 WHERE MATCH (a,b)
44 AGAINST ('"Trial version"@0' IN BOOLEAN MODE);
45 id a b
46 5 Trial version query performace @1255 minute on 2.1Hz Memory 2GB...
47 SELECT * FROM t1
48 WHERE MATCH (a,b)
49 AGAINST ('"request [email protected]"@10' IN BOOLEAN MODE);
50 id a b
51 4 MySQL Tutorial request [email protected] ...
52 SELECT * FROM t1
53 WHERE MATCH (a,b)
54 AGAINST ('"1255 minute"@1' IN BOOLEAN MODE);
55 id a b
56 SELECT * FROM t1
57 WHERE MATCH (a,b)
58 AGAINST ('"1255 minute"@2' IN BOOLEAN MODE);
59 id a b
60 5 Trial version query performace @1255 minute on 2.1Hz Memory 2GB...
61 SELECT * FROM t1
62 WHERE MATCH (a,b)
63 AGAINST ('"1255"@10' IN BOOLEAN MODE);
64 id a b
65 5 Trial version query performace @1255 minute on 2.1Hz Memory 2GB...
66 SELECT * FROM t1
67 WHERE MATCH (a,b)
68 AGAINST ('1255' WITH QUERY EXPANSION);
69 id a b
70 5 Trial version query performace @1255 minute on 2.1Hz Memory 2GB...
71 SELECT * FROM t1
72 WHERE MATCH (a,b)
73 AGAINST ('"request docteam"@2' IN BOOLEAN MODE);
74 id a b
75 4 MySQL Tutorial request [email protected] ...
76 SELECT * FROM t1
77 WHERE MATCH (a,b)
78 AGAINST ('"1255 minute"' IN BOOLEAN MODE);
79 id a b
80 5 Trial version query performace @1255 minute on 2.1Hz Memory 2GB...
81 SELECT * FROM t1
82 WHERE MATCH (a,b)
83 AGAINST ('request [email protected]');
84 id a b
85 4 MySQL Tutorial request [email protected] ...
86 SELECT * FROM t1
87 WHERE MATCH (a,b)
88 AGAINST ('"MySQL request"@3' IN BOOLEAN MODE);
89 id a b
90 4 MySQL Tutorial request [email protected] ...
91 SELECT * FROM t1
92 WHERE MATCH (a,b)
93 AGAINST ('"Trial memory"@10' IN BOOLEAN MODE);
94 id a b
95 5 Trial version query performace @1255 minute on 2.1Hz Memory 2GB...
96 SELECT * FROM t1
97 WHERE MATCH (a,b)
98 AGAINST ('"Trial memory"@9' IN BOOLEAN MODE);
99 id a b
100 DROP TABLE t1;
101 CREATE TABLE t1 (
102 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
103 a VARCHAR(200),
104 b TEXT
105 ) CHARACTER SET = UTF8, ENGINE= InnoDB;
106 INSERT INTO t1 (a,b) VALUES
107 ('MySQL from Tutorial','DBMS stands for DataBase ...') ,
108 ('when To Use MySQL Well','After that you went through a ...'),
109 ('where will Optimizing MySQL','what In this tutorial we will show ...');
110 CREATE FULLTEXT INDEX idx on t1 (a,b);
111 INSERT INTO t1 (a,b) VALUES
112 ('MySQL Tutorial','request [email protected] ...') ,
113 ('Trial version','query performace @1255 minute on 2.1Hz Memory 2GB...'),
114 ('when To Use MySQL Well','for free faq [email protected] ...');
115 SELECT * FROM t1
116 WHERE MATCH (a,b)
117 AGAINST ('"mysql use"@2' IN BOOLEAN MODE);
118 id a b
119 2 when To Use MySQL Well After that you went through a ...
120 6 when To Use MySQL Well for free faq [email protected] ...
121 SELECT * FROM t1
122 WHERE MATCH (a,b)
123 AGAINST ('"mysql use"@1' IN BOOLEAN MODE);
124 id a b
125 INSERT INTO t1 (a,b) VALUES ('XYZ, long blob', repeat("a", 9000));
126 INSERT IGNORE INTO t1 (a,b) VALUES (repeat("b", 9000), 'XYZ, long blob');
127 Warnings:
128 Warning 1265 Data truncated for column 'a' at row 1
129 SELECT count(*) FROM t1
130 WHERE MATCH (a,b)
131 AGAINST ('"xyz blob"@3' IN BOOLEAN MODE);
132 count(*)
133 2
134 DROP TABLE t1;
135 set names utf8;
136 CREATE TABLE t1 (
137 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
138 a TEXT,
139 b TEXT,
140 c TEXT
141 ) CHARACTER SET = UTF8, ROW_FORMAT=DYNAMIC, ENGINE= InnoDB;
142 INSERT INTO t1 (a,b,c) VALUES (repeat("b", 19000), 'XYZ, long text', 'very long blob');
143 INSERT INTO t1 (a,b,c) VALUES (repeat("b", 19000), 'XYZ, very little long blob very much blob', 'very long blob');
144 INSERT INTO t1 (a,b,c) VALUES (repeat("b", 19000),"very 租车 供 blob","new 供需分析information");
145 CREATE FULLTEXT INDEX idx on t1 (a,b,c);
146 INSERT INTO t1 (a,b,c) VALUES (repeat("x", 19000), 'new, long text', 'very new blob');
147 INSERT INTO t1 (a,b,c) VALUES ('interesting, long text', repeat("x", 19000), 'very very good new blob');
148 SELECT count(*) FROM t1
149 WHERE MATCH (a,b,c)
150 AGAINST ('"very blob"@3' IN BOOLEAN MODE);
151 count(*)
152 3
153 SELECT count(*) FROM t1
154 WHERE MATCH (a,b,c)
155 AGAINST ('"very long blob"@0' IN BOOLEAN MODE);
156 count(*)
157 2
158 SELECT count(*) FROM t1
159 WHERE MATCH (a,b,c)
160 AGAINST ('"very blob"@4' IN BOOLEAN MODE);
161 count(*)
162 5
163 SELECT count(*) FROM t1
164 WHERE MATCH (a,b,c)
165 AGAINST ('"interesting blob"@9' IN BOOLEAN MODE);
166 count(*)
167 1
168 SELECT COUNT(*) FROM t1
169 WHERE MATCH (a,b,c)
170 AGAINST ('"interesting blob"@9 "very long blob"@0' IN BOOLEAN MODE);
171 COUNT(*)
172 3
173 SELECT COUNT(*) FROM t1
174 WHERE MATCH (a,b,c)
175 AGAINST ('"very blob"@4 - "interesting blob"@9' IN BOOLEAN MODE);
176 COUNT(*)
177 4
178 DROP TABLE t1;
179 CREATE TABLE t1 (
180 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
181 a VARCHAR(200),
182 b TEXT
183 ) CHARACTER SET = UTF8, ENGINE= InnoDB;
184 INSERT INTO t1 (a,b) VALUES
185 ('MySQL from Tutorial','DBMS stands for + DataBase ...');
186 CREATE FULLTEXT INDEX idx on t1 (a,b);
187 SELECT * FROM t1
188 WHERE MATCH (a,b)
189 AGAINST ('"stands database"@3' IN BOOLEAN MODE);
190 id a b
191 1 MySQL from Tutorial DBMS stands for + DataBase ...
192 DROP TABLE t1;
193 CREATE TABLE t1 (
194 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
195 a TEXT,
196 b TEXT,
197 c TEXT
198 ) CHARACTER SET = UTF8, ROW_FORMAT=DYNAMIC, ENGINE= InnoDB;
199 INSERT INTO t1 (a,b,c) VALUES (repeat("b", 19000), 'XYZ, long text', 'very long blob');
200 INSERT INTO t1 (a,b,c) VALUES ('XYZ, 租车 very little long blob very much blob', repeat("b", 19000), 'very long but smaller blob');
201 CREATE FULLTEXT INDEX idx on t1 (a,b,c);
202 DELETE FROM t1;
203 INSERT INTO t1 (a,b,c) VALUES (repeat("b", 19000), 'XYZ, long text', 'very long blob');
204 INSERT INTO t1 (a,b,c) VALUES ('XYZ, 租车 very little long blob is a very much longer blob', repeat("b", 19000), 'this is very long but smaller blob');
205 SELECT count(*) FROM t1
206 WHERE MATCH (a,b,c)
207 AGAINST ('"very blob"@4' IN BOOLEAN MODE);
208 count(*)
209 2
210 SELECT count(*) FROM t1
211 WHERE MATCH (a,b,c)
212 AGAINST ('"very blob"@3' IN BOOLEAN MODE);
213 count(*)
214 1
215 DROP TABLE t1;