| blob | 969eea2da406c89dd27b2f700c837306817e557d |
1 -- source include/have_innodb.inc
3 let $engine_type=InnoDb;
5 #
6 # Bug#21114 (Foreign key creation fails to table with name format)
7 #
9 # Testing with the full log for only a few functions,
10 # including FORMAT for witch the bug was reported.
12 let $verbose=1;
14 let $FCT=abs;
15 -- source include/parser_bug21114.inc
16 let $FCT=field;
17 -- source include/parser_bug21114.inc
18 let $FCT=format;
19 -- source include/parser_bug21114.inc
21 # Ignoring the result of SHOW CREATE (this generates too much noise)
22 # Tests will fail if the create table statement can not be parsed
24 let verbose=0;
26 let $FCT=acos;
27 -- source include/parser_bug21114.inc
28 let $FCT=adddate;
29 -- source include/parser_bug21114.inc
30 let $FCT=addtime;
31 -- source include/parser_bug21114.inc
32 let $FCT=aes_decrypt;
33 -- source include/parser_bug21114.inc
34 let $FCT=aes_encrypt;
35 -- source include/parser_bug21114.inc
36 let $FCT=area;
37 -- source include/parser_bug21114.inc
38 let $FCT=asbinary;
39 -- source include/parser_bug21114.inc
40 let $FCT=asin;
41 -- source include/parser_bug21114.inc
42 let $FCT=astext;
43 -- source include/parser_bug21114.inc
44 let $FCT=aswkb;
45 -- source include/parser_bug21114.inc
46 let $FCT=aswkt;
47 -- source include/parser_bug21114.inc
48 let $FCT=atan;
49 -- source include/parser_bug21114.inc
50 let $FCT=atan2;
51 -- source include/parser_bug21114.inc
52 let $FCT=benchmark;
53 -- source include/parser_bug21114.inc
54 let $FCT=bin;
55 -- source include/parser_bug21114.inc
56 let $FCT=bit_count;
57 -- source include/parser_bug21114.inc
58 let $FCT=bit_length;
59 -- source include/parser_bug21114.inc
60 let $FCT=ceil;
61 -- source include/parser_bug21114.inc
62 let $FCT=ceiling;
63 -- source include/parser_bug21114.inc
64 let $FCT=centroid;
65 -- source include/parser_bug21114.inc
66 let $FCT=character_length;
67 -- source include/parser_bug21114.inc
68 let $FCT=char_length;
69 -- source include/parser_bug21114.inc
70 let $FCT=coercibility;
71 -- source include/parser_bug21114.inc
72 let $FCT=compress;
73 -- source include/parser_bug21114.inc
74 let $FCT=concat;
75 -- source include/parser_bug21114.inc
76 let $FCT=concat_ws;
77 -- source include/parser_bug21114.inc
78 let $FCT=connection_id;
79 -- source include/parser_bug21114.inc
80 let $FCT=conv;
81 -- source include/parser_bug21114.inc
82 let $FCT=convert_tz;
83 -- source include/parser_bug21114.inc
84 let $FCT=cos;
85 -- source include/parser_bug21114.inc
86 let $FCT=cot;
87 -- source include/parser_bug21114.inc
88 let $FCT=crc32;
89 -- source include/parser_bug21114.inc
90 let $FCT=crosses;
91 -- source include/parser_bug21114.inc
92 let $FCT=datediff;
93 -- source include/parser_bug21114.inc
94 let $FCT=date_format;
95 -- source include/parser_bug21114.inc
96 let $FCT=dayname;
97 -- source include/parser_bug21114.inc
98 let $FCT=dayofmonth;
99 -- source include/parser_bug21114.inc
100 let $FCT=dayofweek;
101 -- source include/parser_bug21114.inc
102 let $FCT=dayofyear;
103 -- source include/parser_bug21114.inc
104 let $FCT=decode;
105 -- source include/parser_bug21114.inc
106 let $FCT=degrees;
107 -- source include/parser_bug21114.inc
108 let $FCT=des_decrypt;
109 -- source include/parser_bug21114.inc
110 let $FCT=des_encrypt;
111 -- source include/parser_bug21114.inc
112 let $FCT=dimension;
113 -- source include/parser_bug21114.inc
114 let $FCT=disjoint;
115 -- source include/parser_bug21114.inc
116 let $FCT=elt;
117 -- source include/parser_bug21114.inc
118 let $FCT=encode;
119 -- source include/parser_bug21114.inc
120 let $FCT=encrypt;
121 -- source include/parser_bug21114.inc
122 let $FCT=endpoint;
123 -- source include/parser_bug21114.inc
124 let $FCT=envelope;
125 -- source include/parser_bug21114.inc
126 let $FCT=equals;
127 -- source include/parser_bug21114.inc
128 let $FCT=exp;
129 -- source include/parser_bug21114.inc
130 let $FCT=export_set;
131 -- source include/parser_bug21114.inc
132 let $FCT=exteriorring;
133 -- source include/parser_bug21114.inc
134 let $FCT=extractvalue;
135 -- source include/parser_bug21114.inc
136 let $FCT=find_in_set;
137 -- source include/parser_bug21114.inc
138 let $FCT=floor;
139 -- source include/parser_bug21114.inc
140 let $FCT=found_rows;
141 -- source include/parser_bug21114.inc
142 let $FCT=from_days;
143 -- source include/parser_bug21114.inc
144 let $FCT=from_unixtime;
145 -- source include/parser_bug21114.inc
146 let $FCT=geomcollfromtext;
147 -- source include/parser_bug21114.inc
148 let $FCT=geomcollfromwkb;
149 -- source include/parser_bug21114.inc
150 let $FCT=geometrycollectionfromtext;
151 -- source include/parser_bug21114.inc
152 let $FCT=geometrycollectionfromwkb;
153 -- source include/parser_bug21114.inc
154 let $FCT=geometryfromtext;
155 -- source include/parser_bug21114.inc
156 let $FCT=geometryfromwkb;
157 -- source include/parser_bug21114.inc
158 let $FCT=geometryn;
159 -- source include/parser_bug21114.inc
160 let $FCT=geometrytype;
161 -- source include/parser_bug21114.inc
162 let $FCT=geomfromtext;
163 -- source include/parser_bug21114.inc
164 let $FCT=geomfromwkb;
165 -- source include/parser_bug21114.inc
166 let $FCT=get_lock;
167 -- source include/parser_bug21114.inc
168 let $FCT=glength;
169 -- source include/parser_bug21114.inc
170 let $FCT=greatest;
171 -- source include/parser_bug21114.inc
172 let $FCT=hex;
173 -- source include/parser_bug21114.inc
174 let $FCT=ifnull;
175 -- source include/parser_bug21114.inc
176 let $FCT=inet_aton;
177 -- source include/parser_bug21114.inc
178 let $FCT=inet_ntoa;
179 -- source include/parser_bug21114.inc
180 let $FCT=instr;
181 -- source include/parser_bug21114.inc
182 let $FCT=interiorringn;
183 -- source include/parser_bug21114.inc
184 let $FCT=intersects;
185 -- source include/parser_bug21114.inc
186 let $FCT=isclosed;
187 -- source include/parser_bug21114.inc
188 let $FCT=isempty;
189 -- source include/parser_bug21114.inc
190 let $FCT=isnull;
191 -- source include/parser_bug21114.inc
192 let $FCT=issimple;
193 -- source include/parser_bug21114.inc
194 let $FCT=is_free_lock;
195 -- source include/parser_bug21114.inc
196 let $FCT=is_used_lock;
197 -- source include/parser_bug21114.inc
198 let $FCT=last_day;
199 -- source include/parser_bug21114.inc
200 let $FCT=last_insert_id;
201 -- source include/parser_bug21114.inc
202 let $FCT=lcase;
203 -- source include/parser_bug21114.inc
204 let $FCT=least;
205 -- source include/parser_bug21114.inc
206 let $FCT=length;
207 -- source include/parser_bug21114.inc
208 let $FCT=linefromtext;
209 -- source include/parser_bug21114.inc
210 let $FCT=linefromwkb;
211 -- source include/parser_bug21114.inc
212 let $FCT=linestringfromtext;
213 -- source include/parser_bug21114.inc
214 let $FCT=linestringfromwkb;
215 -- source include/parser_bug21114.inc
216 let $FCT=ln;
217 -- source include/parser_bug21114.inc
218 let $FCT=load_file;
219 -- source include/parser_bug21114.inc
220 let $FCT=locate;
221 -- source include/parser_bug21114.inc
222 let $FCT=log;
223 -- source include/parser_bug21114.inc
224 let $FCT=log10;
225 -- source include/parser_bug21114.inc
226 let $FCT=log2;
227 -- source include/parser_bug21114.inc
228 let $FCT=lower;
229 -- source include/parser_bug21114.inc
230 let $FCT=lpad;
231 -- source include/parser_bug21114.inc
232 let $FCT=ltrim;
233 -- source include/parser_bug21114.inc
234 let $FCT=makedate;
235 -- source include/parser_bug21114.inc
236 let $FCT=maketime;
237 -- source include/parser_bug21114.inc
238 let $FCT=make_set;
239 -- source include/parser_bug21114.inc
240 let $FCT=master_pos_wait;
241 -- source include/parser_bug21114.inc
242 let $FCT=mbrcontains;
243 -- source include/parser_bug21114.inc
244 let $FCT=mbrdisjoint;
245 -- source include/parser_bug21114.inc
246 let $FCT=mbrequal;
247 -- source include/parser_bug21114.inc
248 let $FCT=mbrintersects;
249 -- source include/parser_bug21114.inc
250 let $FCT=mbroverlaps;
251 -- source include/parser_bug21114.inc
252 let $FCT=mbrtouches;
253 -- source include/parser_bug21114.inc
254 let $FCT=mbrwithin;
255 -- source include/parser_bug21114.inc
256 let $FCT=md5;
257 -- source include/parser_bug21114.inc
258 let $FCT=mlinefromtext;
259 -- source include/parser_bug21114.inc
260 let $FCT=mlinefromwkb;
261 -- source include/parser_bug21114.inc
262 let $FCT=monthname;
263 -- source include/parser_bug21114.inc
264 let $FCT=mpointfromtext;
265 -- source include/parser_bug21114.inc
266 let $FCT=mpointfromwkb;
267 -- source include/parser_bug21114.inc
268 let $FCT=mpolyfromtext;
269 -- source include/parser_bug21114.inc
270 let $FCT=mpolyfromwkb;
271 -- source include/parser_bug21114.inc
272 let $FCT=multilinestringfromtext;
273 -- source include/parser_bug21114.inc
274 let $FCT=multilinestringfromwkb;
275 -- source include/parser_bug21114.inc
276 let $FCT=multipointfromtext;
277 -- source include/parser_bug21114.inc
278 let $FCT=multipointfromwkb;
279 -- source include/parser_bug21114.inc
280 let $FCT=multipolygonfromtext;
281 -- source include/parser_bug21114.inc
282 let $FCT=multipolygonfromwkb;
283 -- source include/parser_bug21114.inc
284 let $FCT=name_const;
285 -- source include/parser_bug21114.inc
286 let $FCT=nullif;
287 -- source include/parser_bug21114.inc
288 let $FCT=numgeometries;
289 -- source include/parser_bug21114.inc
290 let $FCT=numinteriorrings;
291 -- source include/parser_bug21114.inc
292 let $FCT=numpoints;
293 -- source include/parser_bug21114.inc
294 let $FCT=oct;
295 -- source include/parser_bug21114.inc
296 let $FCT=octet_length;
297 -- source include/parser_bug21114.inc
298 let $FCT=ord;
299 -- source include/parser_bug21114.inc
300 let $FCT=overlaps;
301 -- source include/parser_bug21114.inc
302 let $FCT=period_add;
303 -- source include/parser_bug21114.inc
304 let $FCT=period_diff;
305 -- source include/parser_bug21114.inc
306 let $FCT=pi;
307 -- source include/parser_bug21114.inc
308 let $FCT=pointfromtext;
309 -- source include/parser_bug21114.inc
310 let $FCT=pointfromwkb;
311 -- source include/parser_bug21114.inc
312 let $FCT=pointn;
313 -- source include/parser_bug21114.inc
314 let $FCT=polyfromtext;
315 -- source include/parser_bug21114.inc
316 let $FCT=polyfromwkb;
317 -- source include/parser_bug21114.inc
318 let $FCT=polygonfromtext;
319 -- source include/parser_bug21114.inc
320 let $FCT=polygonfromwkb;
321 -- source include/parser_bug21114.inc
322 let $FCT=pow;
323 -- source include/parser_bug21114.inc
324 let $FCT=power;
325 -- source include/parser_bug21114.inc
326 let $FCT=quote;
327 -- source include/parser_bug21114.inc
328 let $FCT=radians;
329 -- source include/parser_bug21114.inc
330 let $FCT=rand;
331 -- source include/parser_bug21114.inc
332 let $FCT=release_lock;
333 -- source include/parser_bug21114.inc
334 let $FCT=reverse;
335 -- source include/parser_bug21114.inc
336 let $FCT=round;
337 -- source include/parser_bug21114.inc
338 let $FCT=row_count;
339 -- source include/parser_bug21114.inc
340 let $FCT=rpad;
341 -- source include/parser_bug21114.inc
342 let $FCT=rtrim;
343 -- source include/parser_bug21114.inc
344 let $FCT=sec_to_time;
345 -- source include/parser_bug21114.inc
346 let $FCT=session_user;
347 -- source include/parser_bug21114.inc
348 let $FCT=sha;
349 -- source include/parser_bug21114.inc
350 let $FCT=sha1;
351 -- source include/parser_bug21114.inc
352 let $FCT=sign;
353 -- source include/parser_bug21114.inc
354 let $FCT=sin;
355 -- source include/parser_bug21114.inc
356 let $FCT=sleep;
357 -- source include/parser_bug21114.inc
358 let $FCT=soundex;
359 -- source include/parser_bug21114.inc
360 let $FCT=space;
361 -- source include/parser_bug21114.inc
362 let $FCT=sqrt;
363 -- source include/parser_bug21114.inc
364 let $FCT=srid;
365 -- source include/parser_bug21114.inc
366 let $FCT=startpoint;
367 -- source include/parser_bug21114.inc
368 let $FCT=strcmp;
369 -- source include/parser_bug21114.inc
370 let $FCT=str_to_date;
371 -- source include/parser_bug21114.inc
372 let $FCT=subdate;
373 -- source include/parser_bug21114.inc
374 let $FCT=substring_index;
375 -- source include/parser_bug21114.inc
376 let $FCT=subtime;
377 -- source include/parser_bug21114.inc
378 let $FCT=system_user;
379 -- source include/parser_bug21114.inc
380 let $FCT=tan;
381 -- source include/parser_bug21114.inc
382 let $FCT=timediff;
383 -- source include/parser_bug21114.inc
384 let $FCT=time_format;
385 -- source include/parser_bug21114.inc
386 let $FCT=time_to_sec;
387 -- source include/parser_bug21114.inc
388 let $FCT=touches;
389 -- source include/parser_bug21114.inc
390 let $FCT=to_days;
391 -- source include/parser_bug21114.inc
392 let $FCT=ucase;
393 -- source include/parser_bug21114.inc
394 let $FCT=uncompress;
395 -- source include/parser_bug21114.inc
396 let $FCT=uncompressed_length;
397 -- source include/parser_bug21114.inc
398 let $FCT=unhex;
399 -- source include/parser_bug21114.inc
400 let $FCT=unix_timestamp;
401 -- source include/parser_bug21114.inc
402 let $FCT=updatexml;
403 -- source include/parser_bug21114.inc
404 let $FCT=upper;
405 -- source include/parser_bug21114.inc
406 let $FCT=uuid;
407 -- source include/parser_bug21114.inc
408 let $FCT=version;
409 -- source include/parser_bug21114.inc
410 let $FCT=weekday;
411 -- source include/parser_bug21114.inc
412 let $FCT=weekofyear;
413 -- source include/parser_bug21114.inc
414 let $FCT=within;
415 -- source include/parser_bug21114.inc
416 let $FCT=x;
417 -- source include/parser_bug21114.inc
418 let $FCT=y;
419 -- source include/parser_bug21114.inc
420 let $FCT=yearweek;
421 -- source include/parser_bug21114.inc