Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (
3 FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
4 a TEXT,
5 b TEXT
6 ) ENGINE = InnoDB;
7 CREATE UNIQUE INDEX FTS_DOC_ID_INDEX on t1(FTS_DOC_ID);
8 "Loading data using LOAD DATA Command , File <MYSQLTEST_VARDIR>/tmp/fts_input_data1.txt"
9 CREATE FULLTEXT INDEX idx on t1 (a,b);
10 SELECT COUNT(*) FROM t1;
11 COUNT(*)
12 49
13 SELECT FTS_DOC_ID FROM t1 WHERE MATCH (a,b)
14 AGAINST ('row35col2word49' IN NATURAL LANGUAGE MODE);
15 FTS_DOC_ID
16 35
17 SELECT COUNT(*) from t1
18 WHERE MATCH(a,b) AGAINST("+row5col2word49 +row5col1word49" IN BOOLEAN MODE);
19 COUNT(*)
20 1
21 SELECT COUNT(*) from t1
22 WHERE MATCH(a,b) AGAINST("+row5col2word49" IN BOOLEAN MODE);
23 COUNT(*)
24 1
25 SELECT COUNT(*) from t1
26 WHERE MATCH(a,b) AGAINST("+row35col2word49 +(row35col1word49 row35col2word40)" IN BOOLEAN MODE);
27 COUNT(*)
28 1
29 SELECT COUNT(*) from t1
30 WHERE MATCH(a,b) AGAINST("+row35col2word49 -(row45col2word49)" IN BOOLEAN MODE);
31 COUNT(*)
32 1
33 SELECT COUNT(*) from t1
34 WHERE MATCH(a,b) AGAINST("row5col2word49 row5col2word40" IN BOOLEAN MODE);
35 COUNT(*)
36 1
37 SELECT COUNT(*) from t1
38 WHERE MATCH a,b AGAINST ("+row5col2word* +row5col1word49*" IN BOOLEAN MODE);
39 COUNT(*)
40 1
41 SELECT COUNT(*) from t1
42 WHERE MATCH a,b AGAINST ('"row35col2word49"' IN BOOLEAN MODE);
43 COUNT(*)
44 1
45 SELECT COUNT(*) from t1
46 WHERE MATCH a,b AGAINST ('"ROW35col2WORD49"' IN BOOLEAN MODE);
47 COUNT(*)
48 1
49 SELECT COUNT(*) from t1
50 WHERE MATCH(a,b) AGAINST ("row5col2word49" WITH QUERY EXPANSION);
51 COUNT(*)
52 1
53 SELECT FTS_DOC_ID FROM t1
54 WHERE MATCH (a,b)
55 AGAINST ('"row5col2word48 row5col2word49"@2' IN BOOLEAN MODE);
56 FTS_DOC_ID
57 5
58 SELECT * FROM t1
59 WHERE MATCH (a,b)
60 AGAINST ('"row5col2word48 row5col2word49"@1' IN BOOLEAN MODE);
61 FTS_DOC_ID a b
62 UPDATE t1 SET a = "using update" , b = "changing fulltext index record", FTS_DOC_ID = FTS_DOC_ID + 10000
63 WHERE MATCH(a,b) AGAINST("+row5col2word49 +row5col1word49" IN BOOLEAN MODE);
64 SELECT a,b FROM t1 WHERE MATCH(a,b) AGAINST("+row5col2word49 +row5col1word49" IN BOOLEAN MODE);
65 a b
66 SELECT a,b FROM t1 WHERE MATCH(a,b) AGAINST("changing fulltext" IN BOOLEAN MODE);
67 a b
68 using update changing fulltext index record
69 SELECT a,b FROM t1 WHERE MATCH(a,b) AGAINST("+chang* +fulltext" IN BOOLEAN MODE);
70 a b
71 using update changing fulltext index record
72 DELETE FROM t1 WHERE MATCH(a,b) AGAINST("+chang* +fulltext" IN BOOLEAN MODE);
73 SELECT a,b FROM t1 WHERE MATCH(a,b) AGAINST("+chang* +fulltext" IN BOOLEAN MODE);
74 a b
75 DROP TABLE t1;
76 CREATE TABLE t1 (
77 FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
78 a TEXT,
79 b TEXT
80 ) ENGINE = InnoDB;
81 CREATE UNIQUE INDEX FTS_DOC_ID_INDEX on t1(FTS_DOC_ID);
82 "Loading data using LOAD DATA Command , File <MYSQLTEST_VARDIR>/tmp/fts_input_data2.txt"
83 CREATE FULLTEXT INDEX idx on t1 (a,b);
84 SELECT COUNT(*) FROM t1;
85 COUNT(*)
86 100
87 SELECT FTS_DOC_ID from t1 WHERE b like '%row300col2word30%';
88 FTS_DOC_ID
89 SELECT FTS_DOC_ID FROM t1 WHERE MATCH (a,b)
90 AGAINST ('row35col2word49' IN NATURAL LANGUAGE MODE);
91 FTS_DOC_ID
92 35
93 SELECT COUNT(*) from t1
94 WHERE MATCH(a,b) AGAINST("+row5col2word49 +row5col1word49" IN BOOLEAN MODE);
95 COUNT(*)
96 1
97 SELECT COUNT(*) from t1
98 WHERE MATCH(a,b) AGAINST("+row5col2word49" IN BOOLEAN MODE);
99 COUNT(*)
100 1
101 SELECT COUNT(*) from t1
102 WHERE MATCH(a,b) AGAINST("+row35col2word49 +(row35col1word49 row35col2word40)" IN BOOLEAN MODE);
103 COUNT(*)
104 1
105 SELECT COUNT(*) from t1
106 WHERE MATCH(a,b) AGAINST("+row35col2word49 -(row45col2word49)" IN BOOLEAN MODE);
107 COUNT(*)
108 1
109 SELECT COUNT(*) from t1
110 WHERE MATCH(a,b) AGAINST("row5col2word49 row5col2word40" IN BOOLEAN MODE);
111 COUNT(*)
112 1
113 SELECT COUNT(*) from t1
114 WHERE MATCH a,b AGAINST ("+row5col2word* +row5col1word49*" IN BOOLEAN MODE);
115 COUNT(*)
116 1
117 SELECT COUNT(*) from t1
118 WHERE MATCH a,b AGAINST ('"row35col2word49"' IN BOOLEAN MODE);
119 COUNT(*)
120 1
121 SELECT COUNT(*) from t1
122 WHERE MATCH a,b AGAINST ('"ROW35col2WORD49"' IN BOOLEAN MODE);
123 COUNT(*)
124 1
125 SELECT COUNT(*) from t1 WHERE MATCH(a,b) AGAINST ("row5col2word49" WITH QUERY EXPANSION);
126 COUNT(*)
127 1
128 SELECT FTS_DOC_ID FROM t1
129 WHERE MATCH (a,b)
130 AGAINST ('"row5col2word48 row5col2word49"@2' IN BOOLEAN MODE);
131 FTS_DOC_ID
132 5
133 SELECT * FROM t1
134 WHERE MATCH (a,b)
135 AGAINST ('"row5col2word48 row5col2word49"@1' IN BOOLEAN MODE);
136 FTS_DOC_ID a b
137 UPDATE t1 SET a = "using update" , b = "changing fulltext index record", FTS_DOC_ID = FTS_DOC_ID + 10000
138 WHERE MATCH(a,b) AGAINST("+row5col2word49 +row5col1word49" IN BOOLEAN MODE);
139 SELECT a,b FROM t1
140 WHERE MATCH(a,b) AGAINST("+row5col2word49 +row5col1word49" IN BOOLEAN MODE);
141 a b
142 SELECT a,b FROM t1
143 WHERE MATCH(a,b) AGAINST("changing fulltext" IN BOOLEAN MODE);
144 a b
145 using update changing fulltext index record
146 SELECT a,b FROM t1
147 WHERE MATCH(a,b) AGAINST("+chang* +fulltext" IN BOOLEAN MODE);
148 a b
149 using update changing fulltext index record
150 DELETE FROM t1 WHERE MATCH(a,b) AGAINST("+chang* +fulltext" IN BOOLEAN MODE);
151 SELECT a,b FROM t1 WHERE MATCH(a,b) AGAINST("+chang* +fulltext" IN BOOLEAN MODE);
152 a b
153 ALTER TABLE t1 DROP INDEX idx;
154 CREATE FULLTEXT INDEX idx on t1 (a,b);
155 UPDATE t1 SET a = NULL , b = NULL, FTS_DOC_ID= 6000 + FTS_DOC_ID;
156 SELECT COUNT(*) FROM t1 WHERE a IS NULL AND b IS NULL;
157 COUNT(*)
158 99
159 ALTER TABLE t1 DROP INDEX idx;
160 SELECT COUNT(*) FROM t1 WHERE a IS NULL AND b IS NULL;
161 COUNT(*)
162 99
163 DROP TABLE t1;
164 CREATE TABLE t1 (
165 FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
166 a TEXT,
167 b TEXT
168 ) ENGINE = InnoDB;
169 CREATE UNIQUE INDEX FTS_DOC_ID_INDEX on t1(FTS_DOC_ID);
170 "Loading data using LOAD DATA Command , File <MYSQLTEST_VARDIR>/tmp/fts_input_data3.txt"
171 CREATE FULLTEXT INDEX idx on t1 (a,b);
172 SELECT COUNT(*) FROM t1;
173 COUNT(*)
174 100
175 SELECT COUNT(*) from t1 WHERE b like '%samerowword%';
176 COUNT(*)
177 100
178 SELECT COUNT(*) FROM t1 WHERE MATCH (a,b)
179 AGAINST ('samerowword' IN NATURAL LANGUAGE MODE);
180 COUNT(*)
181 100
182 SELECT COUNT(*) from t1
183 WHERE MATCH(a,b) AGAINST("+samerowword +samerowword" IN BOOLEAN MODE);
184 COUNT(*)
185 100
186 SELECT COUNT(*) from t1
187 WHERE MATCH(a,b) AGAINST("+samerowword" IN BOOLEAN MODE);
188 COUNT(*)
189 100
190 SELECT COUNT(*) from t1
191 WHERE MATCH(a,b) AGAINST("+samerowword -(row45col2word49)" IN BOOLEAN MODE);
192 COUNT(*)
193 100
194 SELECT COUNT(*) from t1
195 WHERE MATCH a,b AGAINST ("+sameroww" IN BOOLEAN MODE);
196 COUNT(*)
197 0
198 SELECT COUNT(*) from t1
199 WHERE MATCH(a,b) AGAINST ("samerowword" WITH QUERY EXPANSION);
200 COUNT(*)
201 100
202 UPDATE t1 SET a = "using update" , b = "changing fulltext index record",
203 FTS_DOC_ID = FTS_DOC_ID + 10000
204 WHERE MATCH(a,b) AGAINST("+samerowword +samerowword" IN BOOLEAN MODE);
205 SELECT COUNT(*) from t1
206 WHERE MATCH(a,b) AGAINST("+samerowword +samerowword" IN BOOLEAN MODE);
207 COUNT(*)
208 0
209 SELECT COUNT(*) from t1
210 WHERE MATCH(a,b) AGAINST("+samerowword" IN BOOLEAN MODE);
211 COUNT(*)
212 0
213 SELECT COUNT(*) from t1
214 WHERE MATCH(a,b) AGAINST("changing fulltext" IN BOOLEAN MODE);
215 COUNT(*)
216 100
217 SELECT COUNT(*) from t1
218 WHERE MATCH(a,b) AGAINST("+chang* +fulltext" IN BOOLEAN MODE);
219 COUNT(*)
220 100
221 DELETE FROM t1 WHERE MATCH(a,b) AGAINST("+chang* +fulltext" IN BOOLEAN MODE);
222 SELECT COUNT(*) from t1
223 WHERE MATCH(a,b) AGAINST("+chang* +fulltext" IN BOOLEAN MODE);
224 COUNT(*)
225 0
226 ALTER TABLE t1 DROP INDEX idx;
227 CREATE FULLTEXT INDEX idx on t1 (a,b);
228 UPDATE t1 SET a = NULL , b = NULL ;
229 SELECT COUNT(*) FROM t1 WHERE a IS NULL AND b IS NULL;
230 COUNT(*)
231 0
232 ALTER TABLE t1 DROP INDEX idx;
233 SELECT COUNT(*) FROM t1 WHERE a IS NULL AND b IS NULL;
234 COUNT(*)
235 0
236 DROP TABLE t1;
237 CREATE TABLE t1 (
238 FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
239 a TEXT,
240 b TEXT
241 ) ENGINE = InnoDB;
242 CREATE UNIQUE INDEX FTS_DOC_ID_INDEX on t1(FTS_DOC_ID);
243 "Loading data using LOAD DATA Command , File <MYSQLTEST_VARDIR>/tmp/fts_input_data4.txt"
244 CREATE FULLTEXT INDEX idx on t1 (a,b);
245 SELECT COUNT(*) FROM t1;
246 COUNT(*)
247 100
248 SELECT COUNT(*) from t1 WHERE a like '%samerowword%';
249 COUNT(*)
250 100
251 SELECT COUNT(*) FROM t1 WHERE MATCH (a,b)
252 AGAINST ('samerowword' IN NATURAL LANGUAGE MODE);
253 COUNT(*)
254 100
255 SELECT COUNT(*) from t1 WHERE MATCH(a,b) AGAINST("+samerowword +1050" IN BOOLEAN MODE);
256 COUNT(*)
257 100
258 SELECT COUNT(*) from t1 WHERE MATCH(a,b) AGAINST("+samerowword" IN BOOLEAN MODE);
259 COUNT(*)
260 100
261 SELECT COUNT(*) from t1 WHERE MATCH(a,b) AGAINST("+samerowword -(1050)" IN BOOLEAN MODE);
262 COUNT(*)
263 0
264 SELECT COUNT(*) from t1 WHERE MATCH a,b AGAINST ("+2001" IN BOOLEAN MODE);
265 COUNT(*)
266 0
267 SELECT COUNT(*) from t1 WHERE MATCH(a,b) AGAINST ("samerowword" WITH QUERY EXPANSION);
268 COUNT(*)
269 100
270 UPDATE t1 SET a = "using update" , b = "changing fulltext index record",
271 FTS_DOC_ID = FTS_DOC_ID + 10000
272 WHERE MATCH(a,b) AGAINST("+samerowword +1050" IN BOOLEAN MODE);
273 SELECT COUNT(*) from t1
274 WHERE MATCH(a,b) AGAINST("+samerowword +1050" IN BOOLEAN MODE);
275 COUNT(*)
276 0
277 SELECT COUNT(*) from t1
278 WHERE MATCH(a,b) AGAINST("+samerowword" IN BOOLEAN MODE);
279 COUNT(*)
280 0
281 SELECT COUNT(*) from t1
282 WHERE MATCH(a,b) AGAINST("changing fulltext" IN BOOLEAN MODE);
283 COUNT(*)
284 100
285 SELECT COUNT(*) from t1
286 WHERE MATCH(a,b) AGAINST("+chang* +fulltext" IN BOOLEAN MODE);
287 COUNT(*)
288 100
289 DELETE FROM t1
290 WHERE MATCH(a,b) AGAINST("+chang* +fulltext" IN BOOLEAN MODE);
291 SELECT COUNT(*) from t1
292 WHERE MATCH(a,b) AGAINST("+chang* +fulltext" IN BOOLEAN MODE);
293 COUNT(*)
294 0
295 ALTER TABLE t1 DROP INDEX idx;
296 CREATE FULLTEXT INDEX idx on t1 (a,b);
297 UPDATE t1 SET a = NULL , b = NULL ;
298 SELECT COUNT(*) FROM t1 WHERE a IS NULL AND b IS NULL;
299 COUNT(*)
300 0
301 ALTER TABLE t1 DROP INDEX idx;
302 SELECT COUNT(*) FROM t1 WHERE a IS NULL AND b IS NULL;
303 COUNT(*)
304 0
305 DROP TABLE t1;