Debian Codegraph @

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

raw
1 CREATE TABLE articles (
2 id INT UNSIGNED NOT NULL PRIMARY KEY,
3 title VARCHAR(200),
4 FULLTEXT (title)
5 ) ENGINE= InnoDB;
6 TRUNCATE TABLE articles;
7 INSERT INTO articles(id, title) VALUES(1, 'mysql');
8 BEGIN;
9 INSERT INTO articles(id, title) VALUES(2, 'mysql');
10 SAVEPOINT sp1;
11 INSERT INTO articles(id, title) VALUES(3, 'mysql');
12 ROLLBACK TO SAVEPOINT sp1;
13 INSERT INTO articles(id, title) VALUES(4, 'mysql');
14 COMMIT;
15 INSERT INTO articles(id, title) VALUES(5, 'mysql');
16 SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');
17 id title
18 1 mysql
19 2 mysql
20 4 mysql
21 5 mysql
22 TRUNCATE TABLE articles;
23 INSERT INTO articles(id, title) VALUES(1, 'mysql');
24 BEGIN;
25 INSERT INTO articles(id, title) VALUES(2, 'mysql');
26 SAVEPOINT sp1;
27 INSERT INTO articles(id, title) VALUES(3, 'mysql');
28 ROLLBACK TO SAVEPOINT sp1;
29 INSERT INTO articles(id, title) VALUES(4, 'mysql');
30 SAVEPOINT sp2;
31 INSERT INTO articles(id, title) VALUES(5, 'mysql');
32 ROLLBACK TO SAVEPOINT sp2;
33 INSERT INTO articles(id, title) VALUES(6, 'mysql');
34 COMMIT;
35 INSERT INTO articles(id, title) VALUES(7, 'mysql');
36 SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');
37 id title
38 1 mysql
39 2 mysql
40 4 mysql
41 6 mysql
42 7 mysql
43 TRUNCATE TABLE articles;
44 INSERT INTO articles(id, title) VALUES(1, 'mysql');
45 BEGIN;
46 INSERT INTO articles(id, title) VALUES(2, 'mysql');
47 SAVEPOINT sp1;
48 INSERT INTO articles(id, title) VALUES(3, 'mysql');
49 SAVEPOINT sp2;
50 INSERT INTO articles(id, title) VALUES(4, 'mysql');
51 ROLLBACK TO SAVEPOINT sp1;
52 INSERT INTO articles(id, title) VALUES(5, 'mysql');
53 COMMIT;
54 INSERT INTO articles(id, title) VALUES(6, 'mysql');
55 SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');
56 id title
57 1 mysql
58 2 mysql
59 5 mysql
60 6 mysql
61 TRUNCATE TABLE articles;
62 INSERT INTO articles(id, title) VALUES(1, 'mysql');
63 BEGIN;
64 INSERT INTO articles(id, title) VALUES(2, 'mysql');
65 SAVEPOINT sp1;
66 INSERT INTO articles(id, title) VALUES(3, 'mysql');
67 SAVEPOINT sp2;
68 INSERT INTO articles(id, title) VALUES(4, 'mysql');
69 ROLLBACK TO SAVEPOINT sp2;
70 INSERT INTO articles(id, title) VALUES(5, 'mysql');
71 ROLLBACK TO SAVEPOINT sp1;
72 INSERT INTO articles(id, title) VALUES(6, 'mysql');
73 COMMIT;
74 INSERT INTO articles(id, title) VALUES(7, 'mysql');
75 SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');
76 id title
77 1 mysql
78 2 mysql
79 6 mysql
80 7 mysql
81 TRUNCATE TABLE articles;
82 INSERT INTO articles(id, title) VALUES(1, 'mysql');
83 BEGIN;
84 INSERT INTO articles(id, title) VALUES(2, 'mysql');
85 SAVEPOINT sp1;
86 INSERT INTO articles(id, title) VALUES(3, 'mysql');
87 RELEASE SAVEPOINT sp1;
88 INSERT INTO articles(id, title) VALUES(4, 'mysql');
89 COMMIT;
90 INSERT INTO articles(id, title) VALUES(5, 'mysql');
91 SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');
92 id title
93 1 mysql
94 2 mysql
95 3 mysql
96 4 mysql
97 5 mysql
98 TRUNCATE TABLE articles;
99 INSERT INTO articles(id, title) VALUES(1, 'mysql');
100 BEGIN;
101 INSERT INTO articles(id, title) VALUES(2, 'mysql');
102 SAVEPOINT sp1;
103 INSERT INTO articles(id, title) VALUES(3, 'mysql');
104 RELEASE SAVEPOINT sp1;
105 INSERT INTO articles(id, title) VALUES(4, 'mysql');
106 SAVEPOINT sp2;
107 INSERT INTO articles(id, title) VALUES(5, 'mysql');
108 RELEASE SAVEPOINT sp2;
109 INSERT INTO articles(id, title) VALUES(6, 'mysql');
110 COMMIT;
111 INSERT INTO articles(id, title) VALUES(7, 'mysql');
112 SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');
113 id title
114 1 mysql
115 2 mysql
116 3 mysql
117 4 mysql
118 5 mysql
119 6 mysql
120 7 mysql
121 TRUNCATE TABLE articles;
122 INSERT INTO articles(id, title) VALUES(1, 'mysql');
123 BEGIN;
124 INSERT INTO articles(id, title) VALUES(2, 'mysql');
125 SAVEPOINT sp1;
126 INSERT INTO articles(id, title) VALUES(3, 'mysql');
127 SAVEPOINT sp2;
128 INSERT INTO articles(id, title) VALUES(4, 'mysql');
129 RELEASE SAVEPOINT sp1;
130 INSERT INTO articles(id, title) VALUES(5, 'mysql');
131 COMMIT;
132 INSERT INTO articles(id, title) VALUES(6, 'mysql');
133 SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');
134 id title
135 1 mysql
136 2 mysql
137 3 mysql
138 4 mysql
139 5 mysql
140 6 mysql
141 TRUNCATE TABLE articles;
142 INSERT INTO articles(id, title) VALUES(1, 'mysql');
143 BEGIN;
144 INSERT INTO articles(id, title) VALUES(2, 'mysql');
145 SAVEPOINT sp1;
146 INSERT INTO articles(id, title) VALUES(3, 'mysql');
147 SAVEPOINT sp2;
148 INSERT INTO articles(id, title) VALUES(4, 'mysql');
149 RELEASE SAVEPOINT sp2;
150 INSERT INTO articles(id, title) VALUES(5, 'mysql');
151 RELEASE SAVEPOINT sp1;
152 INSERT INTO articles(id, title) VALUES(6, 'mysql');
153 COMMIT;
154 INSERT INTO articles(id, title) VALUES(7, 'mysql');
155 SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');
156 id title
157 1 mysql
158 2 mysql
159 3 mysql
160 4 mysql
161 5 mysql
162 6 mysql
163 7 mysql
164 TRUNCATE TABLE articles;
165 INSERT INTO articles(id, title) VALUES(1, 'mysql');
166 BEGIN;
167 INSERT INTO articles(id, title) VALUES(2, 'mysql');
168 SAVEPOINT sp1;
169 INSERT INTO articles(id, title) VALUES(3, 'mysql');
170 ROLLBACK TO SAVEPOINT sp1;
171 INSERT INTO articles(id, title) VALUES(4, 'mysql');
172 SAVEPOINT sp2;
173 INSERT INTO articles(id, title) VALUES(5, 'mysql');
174 RELEASE SAVEPOINT sp2;
175 INSERT INTO articles(id, title) VALUES(6, 'mysql');
176 COMMIT;
177 INSERT INTO articles(id, title) VALUES(7, 'mysql');
178 SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');
179 id title
180 1 mysql
181 2 mysql
182 4 mysql
183 5 mysql
184 6 mysql
185 7 mysql
186 TRUNCATE TABLE articles;
187 INSERT INTO articles(id, title) VALUES(1, 'mysql');
188 BEGIN;
189 INSERT INTO articles(id, title) VALUES(2, 'mysql');
190 SAVEPOINT sp1;
191 INSERT INTO articles(id, title) VALUES(3, 'mysql');
192 RELEASE SAVEPOINT sp1;
193 INSERT INTO articles(id, title) VALUES(4, 'mysql');
194 SAVEPOINT sp2;
195 INSERT INTO articles(id, title) VALUES(5, 'mysql');
196 ROLLBACK TO SAVEPOINT sp2;
197 INSERT INTO articles(id, title) VALUES(6, 'mysql');
198 COMMIT;
199 INSERT INTO articles(id, title) VALUES(7, 'mysql');
200 SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');
201 id title
202 1 mysql
203 2 mysql
204 3 mysql
205 4 mysql
206 6 mysql
207 7 mysql
208 TRUNCATE TABLE articles;
209 INSERT INTO articles(id, title) VALUES(1, 'mysql');
210 BEGIN;
211 INSERT INTO articles(id, title) VALUES(2, 'mysql');
212 SAVEPOINT sp1;
213 INSERT INTO articles(id, title) VALUES(3, 'mysql');
214 SAVEPOINT sp2;
215 INSERT INTO articles(id, title) VALUES(4, 'mysql');
216 RELEASE SAVEPOINT sp2;
217 INSERT INTO articles(id, title) VALUES(5, 'mysql');
218 ROLLBACK TO SAVEPOINT sp1;
219 INSERT INTO articles(id, title) VALUES(6, 'mysql');
220 COMMIT;
221 INSERT INTO articles(id, title) VALUES(7, 'mysql');
222 SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');
223 id title
224 1 mysql
225 2 mysql
226 6 mysql
227 7 mysql
228 TRUNCATE TABLE articles;
229 INSERT INTO articles(id, title) VALUES(1, 'mysql');
230 BEGIN;
231 INSERT INTO articles(id, title) VALUES(2, 'mysql');
232 SAVEPOINT sp1;
233 INSERT INTO articles(id, title) VALUES(3, 'mysql');
234 SAVEPOINT sp2;
235 INSERT INTO articles(id, title) VALUES(4, 'mysql');
236 ROLLBACK TO SAVEPOINT sp2;
237 INSERT INTO articles(id, title) VALUES(5, 'mysql');
238 RELEASE SAVEPOINT sp1;
239 INSERT INTO articles(id, title) VALUES(6, 'mysql');
240 COMMIT;
241 INSERT INTO articles(id, title) VALUES(7, 'mysql');
242 SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');
243 id title
244 1 mysql
245 2 mysql
246 3 mysql
247 5 mysql
248 6 mysql
249 7 mysql
250 TRUNCATE TABLE articles;
251 INSERT INTO articles(id, title) VALUES(1, 'mysql');
252 BEGIN;
253 INSERT INTO articles(id, title) VALUES(2, 'mysql');
254 ROLLBACK;
255 INSERT INTO articles(id, title) VALUES(3, 'mysql');
256 SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');
257 id title
258 1 mysql
259 3 mysql
260 TRUNCATE TABLE articles;
261 INSERT INTO articles(id, title) VALUES(1, 'mysql');
262 BEGIN;
263 INSERT INTO articles(id, title) VALUES(2, 'mysql');
264 SAVEPOINT sp1;
265 INSERT INTO articles(id, title) VALUES(3, 'mysql');
266 ROLLBACK;
267 INSERT INTO articles(id, title) VALUES(4, 'mysql');
268 SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');
269 id title
270 1 mysql
271 4 mysql
272 TRUNCATE TABLE articles;
273 INSERT INTO articles(id, title) VALUES(1, 'mysql');
274 BEGIN;
275 INSERT INTO articles(id, title) VALUES(2, 'mysql');
276 SAVEPOINT sp1;
277 INSERT INTO articles(id, title) VALUES(3, 'mysql');
278 RELEASE SAVEPOINT sp1;
279 INSERT INTO articles(id, title) VALUES(4, 'mysql');
280 ROLLBACK;
281 INSERT INTO articles(id, title) VALUES(5, 'mysql');
282 SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');
283 id title
284 1 mysql
285 5 mysql
286 TRUNCATE TABLE articles;
287 INSERT INTO articles(id, title) VALUES(1, 'mysql');
288 BEGIN;
289 INSERT INTO articles(id, title) VALUES(2, 'mysql');
290 SAVEPOINT sp1;
291 INSERT INTO articles(id, title) VALUES(3, 'mysql');
292 ROLLBACK TO SAVEPOINT sp1;
293 INSERT INTO articles(id, title) VALUES(4, 'mysql');
294 ROLLBACK;
295 INSERT INTO articles(id, title) VALUES(5, 'mysql');
296 SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');
297 id title
298 1 mysql
299 5 mysql
300 TRUNCATE TABLE articles;
301 INSERT INTO articles(id, title) VALUES(1, 'mysql');
302 BEGIN;
303 INSERT INTO articles(id, title) VALUES(2, 'mysql');
304 SAVEPOINT sp1;
305 INSERT INTO articles(id, title) VALUES(3, 'mysql');
306 SAVEPOINT sp2;
307 INSERT INTO articles(id, title) VALUES(4, 'mysql');
308 ROLLBACK TO SAVEPOINT sp2;
309 INSERT INTO articles(id, title) VALUES(5, 'mysql');
310 RELEASE SAVEPOINT sp1;
311 INSERT INTO articles(id, title) VALUES(6, 'mysql');
312 ROLLBACK;
313 INSERT INTO articles(id, title) VALUES(7, 'mysql');
314 SELECT * FROM articles WHERE MATCH(title) AGAINST('mysql');
315 id title
316 1 mysql
317 7 mysql
318 DROP TABLE articles;