Debian Codegraph @

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

raw
1 # Upgrade test
2 DROP TABLE mysql.innodb_table_stats, mysql.innodb_index_stats;
3 SELECT * FROM articles WHERE MATCH (title,body)
4 AGAINST ('Database' IN NATURAL LANGUAGE MODE);
5 ERROR HY000: Index articles is corrupted
6 call mtr.add_suppression("test/articles.? contains 3 indexes inside InnoDB");
7 alter table articles force;
8 Warnings:
9 Warning 1082 InnoDB: Table test/articles contains 3 indexes inside InnoDB, which is different from the number of indexes 2 defined in the MariaDB
10 flush tables;
11 show create table articles;
12 Table Create Table
13 articles CREATE TABLE `articles` (
14 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
15 `title` varchar(200) DEFAULT NULL,
16 `body` text DEFAULT NULL,
17 PRIMARY KEY (`id`),
18 FULLTEXT KEY `title` (`title`,`body`)
19 ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci WITH SYSTEM VERSIONING
20 SELECT * FROM articles
21 WHERE MATCH (title,body)
22 AGAINST ('Database' IN NATURAL LANGUAGE MODE);
23 id title body
24 1 MySQL Tutorial DBMS stands for DataBase ...
25 5 MySQL vs. YourSQL In the following database comparison ...
26 7 test query expansion for database ...
27 SELECT COUNT(*) FROM articles
28 WHERE MATCH (title,body)
29 AGAINST ('database' IN NATURAL LANGUAGE MODE);
30 COUNT(*)
31 3
32 SELECT * FROM articles
33 WHERE MATCH (title, body)
34 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
35 id title body
36 1 MySQL Tutorial DBMS stands for DataBase ...
37 3 Optimizing MySQL In this tutorial we will show ...
38 SELECT COUNT(IF(MATCH (title,body)
39 AGAINST ('database' IN NATURAL LANGUAGE MODE), 1, NULL))
40 AS count FROM articles;
41 count
42 3
43 SELECT id, body, MATCH (title,body)
44 AGAINST ('Database' IN NATURAL LANGUAGE MODE) AS score
45 FROM articles;
46 id body score
47 1 DBMS stands for DataBase ... 0.2734021842479706
48 2 After you went through a ... 0
49 3 In this tutorial we will show ... 0
50 4 1. Never run mysqld as root. 2. ... 0
51 5 In the following database comparison ... 0.2734021842479706
52 6 When configured properly, MySQL ... 0
53 7 for database ... 0.2734021842479706
54 8 search, with proximity innodb 0
55 9 search, with proximity innodb 0
56 10 search, with proximity innodb 0
57 SELECT * FROM articles
58 WHERE MATCH (title,body)
59 AGAINST ('MySQL' IN NATURAL LANGUAGE MODE);
60 id title body
61 6 MySQL Security When configured properly, MySQL ...
62 1 MySQL Tutorial DBMS stands for DataBase ...
63 2 How To Use MySQL Well After you went through a ...
64 3 Optimizing MySQL In this tutorial we will show ...
65 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
66 5 MySQL vs. YourSQL In the following database comparison ...
67 SELECT * FROM articles WHERE MATCH (title,body)
68 AGAINST ('+MySQL -YourSQL' IN BOOLEAN MODE);
69 id title body
70 6 MySQL Security When configured properly, MySQL ...
71 1 MySQL Tutorial DBMS stands for DataBase ...
72 2 How To Use MySQL Well After you went through a ...
73 3 Optimizing MySQL In this tutorial we will show ...
74 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
75 SELECT * FROM articles WHERE MATCH (title,body)
76 AGAINST ('DBMS Security' IN BOOLEAN MODE);
77 id title body
78 1 MySQL Tutorial DBMS stands for DataBase ...
79 6 MySQL Security When configured properly, MySQL ...
80 SELECT * FROM articles WHERE MATCH (title,body)
81 AGAINST ('+MySQL +YourSQL' IN BOOLEAN MODE);
82 id title body
83 5 MySQL vs. YourSQL In the following database comparison ...
84 SELECT * FROM articles WHERE MATCH (title,body)
85 AGAINST ('+MySQL YourSQL' IN BOOLEAN MODE);
86 id title body
87 5 MySQL vs. YourSQL In the following database comparison ...
88 6 MySQL Security When configured properly, MySQL ...
89 1 MySQL Tutorial DBMS stands for DataBase ...
90 2 How To Use MySQL Well After you went through a ...
91 3 Optimizing MySQL In this tutorial we will show ...
92 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
93 SELECT * FROM articles WHERE MATCH (title,body)
94 AGAINST ('+MySQL ~YourSQL' IN BOOLEAN MODE);
95 id title body
96 6 MySQL Security When configured properly, MySQL ...
97 1 MySQL Tutorial DBMS stands for DataBase ...
98 2 How To Use MySQL Well After you went through a ...
99 3 Optimizing MySQL In this tutorial we will show ...
100 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
101 5 MySQL vs. YourSQL In the following database comparison ...
102 SELECT * FROM articles WHERE MATCH (title,body)
103 AGAINST ('t*' IN BOOLEAN MODE);
104 id title body
105 8 test proximity search, test, proximity and phrase search, with proximity innodb
106 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
107 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
108 1 MySQL Tutorial DBMS stands for DataBase ...
109 2 How To Use MySQL Well After you went through a ...
110 3 Optimizing MySQL In this tutorial we will show ...
111 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
112 7 test query expansion for database ...
113 SELECT * FROM articles WHERE MATCH (title,body)
114 AGAINST ('MY*' IN BOOLEAN MODE);
115 id title body
116 6 MySQL Security When configured properly, MySQL ...
117 1 MySQL Tutorial DBMS stands for DataBase ...
118 2 How To Use MySQL Well After you went through a ...
119 3 Optimizing MySQL In this tutorial we will show ...
120 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
121 5 MySQL vs. YourSQL In the following database comparison ...
122 SELECT * FROM articles WHERE MATCH (title,body)
123 AGAINST ('ru*' IN BOOLEAN MODE);
124 id title body
125 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
126 SELECT * FROM articles WHERE MATCH (title,body)
127 AGAINST ('+ MySQL >Well < stands' IN BOOLEAN MODE);
128 id title body
129 2 How To Use MySQL Well After you went through a ...
130 6 MySQL Security When configured properly, MySQL ...
131 1 MySQL Tutorial DBMS stands for DataBase ...
132 3 Optimizing MySQL In this tutorial we will show ...
133 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
134 5 MySQL vs. YourSQL In the following database comparison ...
135 SELECT * FROM articles WHERE MATCH (title,body)
136 AGAINST ('+ MySQL - (Well stands)' IN BOOLEAN MODE);
137 id title body
138 6 MySQL Security When configured properly, MySQL ...
139 3 Optimizing MySQL In this tutorial we will show ...
140 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
141 5 MySQL vs. YourSQL In the following database comparison ...
142 SELECT * FROM articles WHERE MATCH (title,body) AGAINST
143 ('(((((((((((((((((((((((((((((((((Security)))))))))))))))))))))))))))))))))'
144 IN BOOLEAN MODE);
145 ERROR HY000: Table handler out of memory
146 SELECT * FROM articles WHERE MATCH (title,body) AGAINST
147 ('((((((((((((((((((((((((((((((((Security))))))))))))))))))))))))))))))))'
148 IN BOOLEAN MODE);
149 id title body
150 6 MySQL Security When configured properly, MySQL ...
151 SELECT * FROM articles WHERE MATCH (title,body) AGAINST
152 ('(((((((((((((((((((((((((((((((vs))))))))))))))))))))))))))))))),(((to)))'
153 IN BOOLEAN MODE);
154 id title body
155 SELECT * FROM articles WHERE MATCH (title,body) AGAINST
156 ('((((((((((((((((((((((((((((((((Security)))))))))))))))))))))))))))))))'
157 IN BOOLEAN MODE);
158 ERROR 42000: syntax error, unexpected $end
159 SELECT * FROM articles WHERE MATCH (title,body) AGAINST
160 ('(((((((((((((((((((((((((((((((((Security))))))))))))))))))))))))))))))))'
161 IN BOOLEAN MODE);
162 ERROR 42000: syntax error, unexpected $end
163 SELECT * FROM articles WHERE MATCH (title,body)
164 AGAINST ('+ MySQL + (>Well < stands)' IN BOOLEAN MODE);
165 id title body
166 2 How To Use MySQL Well After you went through a ...
167 1 MySQL Tutorial DBMS stands for DataBase ...
168 SELECT * FROM articles WHERE MATCH (title,body)
169 AGAINST ('YourSQL + (+MySQL - (Tricks Security))' IN BOOLEAN MODE);
170 id title body
171 5 MySQL vs. YourSQL In the following database comparison ...
172 1 MySQL Tutorial DBMS stands for DataBase ...
173 2 How To Use MySQL Well After you went through a ...
174 3 Optimizing MySQL In this tutorial we will show ...
175 SELECT * FROM articles WHERE MATCH (title,body)
176 AGAINST ('(+MySQL - (Tricks Security)) - YourSQL' IN BOOLEAN MODE);
177 id title body
178 1 MySQL Tutorial DBMS stands for DataBase ...
179 2 How To Use MySQL Well After you went through a ...
180 3 Optimizing MySQL In this tutorial we will show ...
181 SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('mysql - Security&DBMS' IN BOOLEAN MODE);
182 id title body
183 2 How To Use MySQL Well After you went through a ...
184 3 Optimizing MySQL In this tutorial we will show ...
185 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
186 5 MySQL vs. YourSQL In the following database comparison ...
187 SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('mysql - (Security DBMS)' IN BOOLEAN MODE);
188 id title body
189 2 How To Use MySQL Well After you went through a ...
190 3 Optimizing MySQL In this tutorial we will show ...
191 4 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
192 5 MySQL vs. YourSQL In the following database comparison ...
193 SELECT * FROM articles WHERE MATCH (title,body) AGAINST (' - Security&DBMS + YourSQL' IN BOOLEAN MODE);
194 id title body
195 5 MySQL vs. YourSQL In the following database comparison ...
196 SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+YourSQL - Security&DBMS' IN BOOLEAN MODE);
197 id title body
198 5 MySQL vs. YourSQL In the following database comparison ...
199 SELECT COUNT(*) FROM articles
200 WHERE MATCH (title,body)
201 AGAINST ('database' WITH QUERY EXPANSION);
202 COUNT(*)
203 10
204 SELECT * FROM articles
205 WHERE MATCH (title,body)
206 AGAINST ('test' WITH QUERY EXPANSION);
207 id title body
208 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
209 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
210 8 test proximity search, test, proximity and phrase search, with proximity innodb
211 7 test query expansion for database ...
212 1 MySQL Tutorial DBMS stands for DataBase ...
213 5 MySQL vs. YourSQL In the following database comparison ...
214 SELECT * FROM articles
215 WHERE MATCH (title,body)
216 AGAINST ('"following comparison"@3' IN BOOLEAN MODE);
217 id title body
218 5 MySQL vs. YourSQL In the following database comparison ...
219 SELECT * FROM articles
220 WHERE MATCH (title,body)
221 AGAINST ('"following comparison"@2' IN BOOLEAN MODE);
222 id title body
223 SELECT * FROM articles
224 WHERE MATCH (title,body)
225 AGAINST ('"following database"' IN BOOLEAN MODE);
226 id title body
227 5 MySQL vs. YourSQL In the following database comparison ...
228 SELECT * FROM articles
229 WHERE MATCH (title,body)
230 AGAINST ('"proximity search"@3' IN BOOLEAN MODE);
231 id title body
232 8 test proximity search, test, proximity and phrase search, with proximity innodb
233 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
234 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
235 SELECT * FROM articles
236 WHERE MATCH (title,body)
237 AGAINST ('"proximity search"@2' IN BOOLEAN MODE);
238 id title body
239 8 test proximity search, test, proximity and phrase search, with proximity innodb
240 SELECT * FROM articles
241 WHERE MATCH (title,body)
242 AGAINST ('"proximity search"@5' IN BOOLEAN MODE);
243 id title body
244 8 test proximity search, test, proximity and phrase search, with proximity innodb
245 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
246 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
247 SELECT * FROM articles
248 WHERE MATCH (title,body)
249 AGAINST ('"test proximity"@5' IN BOOLEAN MODE);
250 id title body
251 8 test proximity search, test, proximity and phrase search, with proximity innodb
252 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
253 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
254 SELECT * FROM articles
255 WHERE MATCH (title,body)
256 AGAINST ('"test proximity"@1' IN BOOLEAN MODE);
257 id title body
258 SELECT * FROM articles
259 WHERE MATCH (title,body)
260 AGAINST ('"test proximity"@4' IN BOOLEAN MODE);
261 id title body
262 8 test proximity search, test, proximity and phrase search, with proximity innodb
263 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
264 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
265 SELECT * FROM articles
266 WHERE MATCH (title,body)
267 AGAINST ('"test proximity"@3' IN BOOLEAN MODE);
268 id title body
269 8 test proximity search, test, proximity and phrase search, with proximity innodb
270 9 test my proximity fts new search, test, proximity and phrase search, with proximity innodb
271 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
272 SELECT * FROM articles
273 WHERE MATCH (title,body)
274 AGAINST ('"more test proximity"@4' IN BOOLEAN MODE);
275 id title body
276 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
277 SELECT * FROM articles
278 WHERE MATCH (title,body)
279 AGAINST ('"more test proximity"@3' IN BOOLEAN MODE);
280 id title body
281 10 test more of proximity fts search, test, more proximity and phrase search, with proximity innodb
282 SELECT * FROM articles
283 WHERE MATCH (title,body)
284 AGAINST ('"more test proximity"' IN BOOLEAN MODE);
285 id title body
286 set global innodb_ft_server_stopword_table= "test/user_stopword";
287 SELECT * FROM articles2 WHERE MATCH (title,body)
288 AGAINST ('the' IN NATURAL LANGUAGE MODE);
289 SELECT * FROM articles2 WHERE MATCH (title,body)
290 AGAINST ('this' IN NATURAL LANGUAGE MODE);
291 drop index idx on articles2;
292 Warnings:
293 Warning 1082 InnoDB: Table test/articles2 contains 3 indexes inside InnoDB, which is different from the number of indexes 1 defined in the MariaDB
294 create fulltext index idx on articles2(title, body);
295 SELECT * FROM articles2 WHERE MATCH (title,body)
296 AGAINST ('the' IN NATURAL LANGUAGE MODE);
297 id title body
298 5 MySQL vs. YourSQL In the following database comparison ...
299 SELECT * FROM articles2 WHERE MATCH (title,body)
300 AGAINST ('this' IN NATURAL LANGUAGE MODE);
301 id title body
302 # Cleanup
303 drop tables articles, articles2, user_stopword;
304 set global innodb_ft_server_stopword_table= default;