Debian Codegraph @

mysql-test/suite/vcol/t/vcol_supported_sql_funcs_main.inc

raw
1 ################################################################################
2 # inc/vcol_supported_sql_funcs_main.inc #
3 # #
4 # Purpose: #
5 # Tests frame for allowed sql functions #
6 # #
7 # #
8 #------------------------------------------------------------------------------#
9 # Original Author: Andrey Zhakov #
10 # Original Date: 2008-08-31 #
11 # Change Author: Oleksandr Byelkin (Monty program Ab)
12 # Date: 2009-03-24
13 # Change: Syntax changed
14 ################################################################################
15
16 --echo #
17 --echo # NUMERIC FUNCTIONS
18 --echo #
19
20 --echo # ABS()
21 let $cols = a int, b int as (abs(a));
22 let $values1 = -1, default;
23 let $rows = 1;
24 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
25
26 --echo # ACOS()
27 let $cols = a double, b double as (format(acos(a),6));
28 let $values1 = 1, default;
29 let $values2 = 1.0001,default;
30 let $values3 = 0,default;
31 let $rows = 3;
32 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
33
34 --echo # ASIN()
35 let $cols = a double, b double as (format(asin(a),6));
36 let $values1 = 0.2, default;
37 let $values2 = 1.0001,default;
38 let $rows = 2;
39 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
40
41 --echo #ATAN
42 let $cols = a double, b double, c double as (format(atan(a,b),6));
43 let $values1 = -2,2,default;
44 let $values2 = format(PI(),6),0,default;
45 let $rows = 2;
46 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
47
48 let $cols = a double, c double as (format(atan(a),6));
49 let $values1 = -2,default;
50 let $values2 = format(PI(),6),default;
51 let $rows = 2;
52 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
53
54 --echo # ATAN2
55 let $cols = a double, b double, c double as (format(atan2(a,b),6));
56 let $values1 = -2,2,default;
57 let $values2 = format(PI(),6),0,default;
58 let $rows = 2;
59 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
60
61 --echo # CEIL()
62 let $cols = a double, b int as (ceil(a));
63 let $values1 = 1.23,default;
64 let $values2 = -1.23,default;
65 let $rows = 2;
66 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
67
68 --echo # CONV()
69 let $cols = a varchar(10), b int, c int, d varchar(10) as (conv(a,b,c));
70 let $values1 = 'a',16,2,default;
71 let $values2 = '6e',18,8,default;
72 let $values3 = -17,10,-18,default;
73 let $values4 = 10+'10'+'10'+0xa,10,10,default;
74 let $rows = 4;
75 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
76
77 --echo # COS()
78 let $cols = a double, b double as (format(cos(a),6));
79 let $values1 = format(PI(),6),default;
80 let $rows = 1;
81 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
82
83 --echo # COT()
84 let $cols = a double, b double as (format(cot(a),6));
85 let $values1 = 12,default;
86 let $values2 = 1,default;
87 let $rows = 2;
88 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
89
90 --echo # CRC32()
91 let $cols = a varchar(10), b long as (crc32(a));
92 let $values1 = 'MySQL',default;
93 let $values2 = 'mysql',default;
94 let $rows = 2;
95 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
96
97 --echo # DEGREES()
98 let $cols = a double, b double as (format(degrees(a),6));
99 let $values1 = format(PI(),6),default;
100 let $values2 = format(PI()/2,6),default;
101 let $rows = 2;
102 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
103
104 --echo # /
105 let $cols = a double, b double as (a/2);
106 let $values1 = 2,default;
107 let $rows = 1;
108 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
109
110 --echo # EXP()
111 let $cols = a double, b double as (format(exp(a),6));
112 let $values1 = 2,default;
113 let $values2 = -2,default;
114 let $values3 = 0,default;
115 let $rows = 3;
116 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
117
118 --echo # FLOOR()
119 let $cols = a double, b long as (floor(a));
120 let $values1 = 1.23,default;
121 let $values2 = -1.23,default;
122 let $rows = 2;
123 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
124
125 --echo # LN()
126 let $cols = a double, b double as (format(ln(a),6));
127 let $values1 = 2,default;
128 let $values2 = -2,default;
129 let $rows = 2;
130 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
131
132 --echo # LOG()
133 let $cols = a double, b double, c double as (format(log(a,b),6));
134 let $values1 = 2,65536,default;
135 let $values2 = 10,100,default;
136 let $values3 = 1,100,default;
137 let $rows = 3;
138 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
139
140 let $cols = a double, b double as (format(log(a),6));
141 let $values1 = 2,default;
142 let $values2 = -2,default;
143 let $rows = 2;
144 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
145
146 --echo # LOG2()
147 let $cols = a double, b double as (format(log2(a),6));
148 let $values1 = 65536,default;
149 let $values2 = -100,default;
150 let $rows = 2;
151 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
152
153 --echo # LOG10()
154 let $cols = a double, b double as (format(log10(a),6));
155 let $values1 = 2,default;
156 let $values2 = 100,default;
157 let $values3 = -100,default;
158 let $rows = 3;
159 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
160
161 --echo # -
162 let $cols = a double, b double as (a-1);
163 let $values1 = 2,default;
164 let $rows = 1;
165 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
166
167 --echo # MOD()
168 let $cols = a int, b int as (mod(a,10));
169 let $values1 = 1,default;
170 let $values2 = 11,default;
171 let $rows = 2;
172 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
173
174 --echo # %
175 let $cols = a int, b int as (a % 10);
176 let $values1 = 1,default;
177 let $values2 = 11,default;
178 let $rows = 2;
179 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
180
181 --echo # OCT()
182 let $cols = a double, b varchar(10) as (oct(a));
183 let $values1 = 12,default;
184 let $rows = 1;
185 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
186
187 --echo # PI()
188 let $cols = a double, b double as (format(PI()*a*a,6));
189 let $values1 = 1,default;
190 let $rows = 1;
191 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
192
193 --echo # +
194 let $cols = a int, b int as (a+1);
195 let $values1 = 1,default;
196 let $rows = 1;
197 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
198
199 --echo # POW, POWER
200 let $cols = a int, b int as (pow(a,2)), c int as (power(a,2));
201 let $values1 = 1,default,default;
202 let $values2 = 2,default,default;
203 let $rows = 2;
204 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
205
206 --echo # RADIANS()
207 let $cols = a double, b double as (format(radians(a),6));
208 let $values1 = 90,default;
209 let $rows = 1;
210 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
211
212 --echo # ROUND()
213 let $cols = a double, b int as (round(a));
214 let $values1 = -1.23,default;
215 let $values2 = -1.58,default;
216 let $values3 = 1.58,default;
217 let $rows = 3;
218 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
219
220 let $cols = a double, b double, c int as (round(a,b));
221 let $values1 = 1.298,1,default;
222 let $values2 = 1.298,0,default;
223 let $values3 = 23.298,-1,default;
224 let $rows = 3;
225 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
226
227 --echo # SIGN()
228 let $cols = a double, b int as (sign(a));
229 let $values1 = -32,default;
230 let $values2 = 0,default;
231 let $values3 = 234,default;
232 let $rows = 3;
233 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
234
235 --echo # SIN()
236 let $cols = a double, b double as (format(sin(a),6));
237 let $values1 = format(PI()/2,6),default;
238 let $rows = 1;
239 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
240
241 --echo # SQRT()
242 let $cols = a double, b double as (format(sqrt(a),6));
243 let $values1 = 4,default;
244 let $values2 = 20,default;
245 let $values3 = -16,default;
246 let $rows = 3;
247 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
248
249 --echo # TAN()
250 let $cols = a double, b double as (format(tan(a),6));
251 let $values1 = format(PI(),6),default;
252 let $values2 = format(PI()+1,6),default;
253 let $rows = 2;
254 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
255
256 --echo # *
257 let $cols = a double, b double as (a*3);
258 let $values1 = 0,default;
259 let $values2 = 1,default;
260 let $values3 = 2,default;
261 let $rows = 3;
262 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
263
264 --echo # TRUNCATE()
265 let $cols = a double, b double as (truncate(a,4));
266 let $values1 = 1.223,default;
267 let $values2 = 1.999,default;
268 let $values3 = 1.999,default;
269 let $values4 = 122,default;
270 let $rows = 4;
271 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
272
273 --echo # Unary -
274 let $cols = a double, b double as (-a);
275 let $values1 = 1,default;
276 let $values2 = -1,default;
277 let $rows = 2;
278 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
279
280 --echo #
281 --echo # STRING FUNCTIONS
282 --echo #
283
284 --echo # ASCII()
285 let $cols = a char(2), b int as (ascii(a));
286 let $values1 = '2',default;
287 let $values2 = 2,default;
288 let $values3 = 'dx',default;
289 let $rows = 3;
290 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
291
292 --echo # BIN()
293 let $cols = a int, b varchar(10) as (bin(a));
294 let $values1 = 12,default;
295 let $rows = 1;
296 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
297
298 --echo # BIT_LENGTH()
299 let $cols = a varchar(10), b long as (bit_length(a));
300 let $values1 = 'text',default;
301 let $rows = 1;
302 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
303
304 --echo # CHAR_LENGTH()
305 let $cols = a varchar(10), b long as (char_length(a));
306 let $values1 = 'text',default;
307 let $rows = 1;
308 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
309
310 --echo # CHAR()
311 let $cols = a int, b int, c varbinary(10) as (char(a,b));
312 let $values1 = 77,121,default;
313 let $rows = 1;
314 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
315
316 --echo # CHARACTER_LENGTH()
317 let $cols = a varchar(10), b long as (character_length(a));
318 let $values1 = 'text',default;
319 let $rows = 1;
320 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
321
322 --echo # CONCAT_WS()
323 let $cols = a varchar(10), b varchar(10), c varchar(20) as (concat_ws(',',a,b));
324 let $values1 = 'value1','value2',default;
325 let $rows = 1;
326 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
327
328 --echo # CONCAT()
329 let $cols = a varchar(10), b varchar(10), c varchar(20) as (concat(a,',',b));
330 let $values1 = 'value1','value2',default;
331 let $rows = 1;
332 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
333
334 --echo # ELT()
335 let $cols = a varchar(10), b varchar(10), c int, d varchar(10) as (elt(c,a,b));
336 let $values1 = 'value1','value2',1,default;
337 let $values2 = 'value1','value2',2,default;
338 let $rows = 2;
339 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
340
341 --echo # EXPORT_SET()
342 let $cols = a int, b varchar(10) as (export_set(a,'1','0','',10));
343 let $values1 = 6,default;
344 let $rows = 1;
345 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
346
347 --echo # FIELD()
348 let $cols = a varchar(10), b varchar(10), c int as (field('aa',a,b));
349 let $values1 = 'aa','bb',default;
350 let $values2 = 'bb','aa',default;
351 let $rows = 2;
352 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
353
354 --echo # FIND_IN_SET()
355 let $cols = a varchar(10), b varchar(10), c int as (find_in_set(a,b));
356 let $values1 = 'aa','aa,bb,cc',default;
357 let $values2 = 'aa','bb,aa,cc',default;
358 let $rows = 2;
359 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
360
361 --echo # FORMAT()
362 let $cols = a double, b varchar(20) as (format(a,2));
363 let $values1 = 12332.123456,default;
364 let $rows = 1;
365 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
366
367 --echo # HEX()
368 let $cols = a int, b varchar(10) as (hex(a));
369 let $values1 = 17,default;
370 let $rows = 1;
371 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
372
373 let $cols = a varchar(10), b varchar(10) as (hex(a));
374 let $values1 = 'abc',default;
375 let $rows = 1;
376 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
377
378 --echo # INSERT()
379 let $cols = a varchar(10), b varchar(10), c varchar(20) as (insert(a,length(a),length(b),b));
380 let $values1 = 'start,','end',default;
381 let $rows = 1;
382 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
383
384 --echo # INSTR()
385 let $cols = a varchar(10), b varchar(10), c int as (instr(a,b));
386 let $values1 = 'foobarbar,','bar',default;
387 let $values2 = 'xbar,','foobar',default;
388 let $rows = 2;
389 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
390
391 --echo # LCASE()
392 let $cols = a varchar(10), b varchar(10) as (lcase(a));
393 let $values1 = 'MySQL',default;
394 let $rows = 1;
395 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
396
397 --echo # LEFT()
398 let $cols = a varchar(10), b varchar(5) as (left(a,5));
399 let $values1 = 'foobarbar',default;
400 let $rows = 1;
401 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
402
403 --echo # LENGTH()
404 let $cols = a varchar(10), b int as (length(a));
405 let $values1 = 'text',default;
406 let $rows = 1;
407 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
408
409 --echo # LIKE
410 let $cols = a varchar(10), b bool as (a like 'H%!o' escape '!');
411 let $values1 = 'Hello',default;
412 let $values2 = 'MySQL',default;
413 let $rows = 2;
414 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
415
416 --echo # LOCATE()
417 let $cols = a varchar(10), b varchar(10) as (locate('bar',a));
418 let $values1 = 'foobarbar',default;
419 let $rows = 1;
420 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
421
422 --echo # LOWER()
423 let $cols = a varchar(10), b varchar(10) as (lower(a));
424 let $values1 = 'MySQL',default;
425 let $rows = 1;
426 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
427
428 --echo # LPAD()
429 let $cols = a varchar(10), b varchar(10) as (lpad(a,4,' '));
430 let $values1 = 'MySQL',default;
431 let $values2 = 'M',default;
432 let $rows = 2;
433 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
434
435 --echo # LTRIM()
436 let $cols = a varchar(10), b varchar(10) as (ltrim(a));
437 let $values1 = ' MySQL',default;
438 let $values2 = 'MySQL',default;
439 let $rows = 2;
440 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
441
442 --echo # MAKE_SET()
443 let $cols = a varchar(10), b varchar(10), c int, d varchar(30) as (make_set(c,a,b));
444 let $values1 = 'a','b',1,default;
445 let $values2 = 'a','b',3,default;
446 let $rows = 2;
447 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
448
449 --echo # MID()
450 let $cols = a varchar(10), b varchar(10) as (mid(a,1,2));
451 let $values1 = 'foobarbar',default;
452 let $rows = 1;
453 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
454
455 --echo # NOT LIKE
456 let $cols = a varchar(10), b bool as (a not like 'H%o');
457 let $values1 = 'Hello',default;
458 let $values2 = 'MySQL',default;
459 let $rows = 2;
460 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
461
462 --echo # NOT REGEXP
463 let $cols = a varchar(10), b bool as (a not regexp 'H.+o');
464 let $values1 = 'Hello',default;
465 let $values2 = 'hello',default;
466 let $rows = 2;
467 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
468
469 --echo # OCTET_LENGTH()
470 let $cols = a varchar(10), b int as (octet_length(a));
471 let $values1 = 'text',default;
472 let $rows = 1;
473 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
474
475 --echo # ORD()
476 let $cols = a varchar(10), b long as (ord(a));
477 let $values1 = '2',default;
478 let $rows = 1;
479 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
480
481 --echo # POSITION()
482 let $cols = a varchar(10), b varchar(10) as (position('bar' in a));
483 let $values1 = 'foobarbar',default;
484 let $rows = 1;
485 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
486
487 --echo # QUOTE()
488 let $cols = a varchar(10), b varchar(10) as (quote(a));
489 let $values1 = 'Don\'t',default;
490 let $rows = 1;
491 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
492
493 --echo # REGEXP()
494 let $cols = a varchar(10), b bool as (a regexp 'H.+o');
495 let $values1 = 'Hello',default;
496 let $values2 = 'hello',default;
497 let $rows = 2;
498 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
499
500 --echo # REPEAT()
501 let $cols = a varchar(10), b varchar(30) as (repeat(a,3));
502 let $values1 = 'MySQL',default;
503 let $rows = 1;
504 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
505
506 --echo # REPLACE()
507 let $cols = a varchar(10), b varchar(30) as (replace(a,'aa','bb'));
508 let $values1 = 'maa',default;
509 let $rows = 1;
510 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
511
512 --echo # REVERSE()
513 let $cols = a varchar(10), b varchar(30) as (reverse(a));
514 let $values1 = 'maa',default;
515 let $rows = 1;
516 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
517
518 --echo # RIGHT()
519 let $cols = a varchar(10), b varchar(10) as (right(a,4));
520 let $values1 = 'foobarbar',default;
521 let $rows = 1;
522 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
523
524 --echo # RLIKE()
525 let $cols = a varchar(10), b bool as (a rlike 'H.+o');
526 let $values1 = 'Hello',default;
527 let $values2 = 'MySQL',default;
528 let $rows = 2;
529 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
530
531 --echo # RPAD()
532 let $cols = a varchar(10), b varchar(10) as (rpad(a,4,'??'));
533 let $values1 = 'He',default;
534 let $rows = 1;
535 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
536
537 --echo # RTRIM();
538 let $cols = a varchar(10), b varchar(10) as (rtrim(a));
539 let $values1 = 'Hello ',default;
540 let $rows = 1;
541 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
542
543 --echo # SOUNDEX()
544 let $cols = a varchar(10), b varchar(20) as (soundex(a));
545 let $values1 = 'Hello',default;
546 let $rows = 1;
547 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
548
549 --echo # SOUNDS LIKE
550 let $cols = a varchar(10), b varchar(10), c bool as (a sounds like b);
551 let $values1 = 'Hello','Hello',default;
552 let $values2 = 'Hello','MySQL',default;
553 let $values3 = 'Hello','hello',default;
554 let $rows = 3;
555 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
556
557 --echo # SPACE()
558 let $cols = a varchar(5), b varchar(10) as (concat(a,space(5)));
559 let $values1 = 'Hello', default;
560 let $rows = 1;
561 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
562
563 --echo # STRCMP()
564 let $cols = a varchar(9), b varchar(9), c tinyint(1) as (strcmp(a,b));
565 let $values1 = 'Hello','Hello', default;
566 let $values2 = 'Hello','Hello1', default;
567 let $rows = 2;
568 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
569
570 --echo # SUBSTR()
571 let $cols = a varchar(5), b varchar(10) as (substr(a,2));
572 let $values1 = 'Hello',default;
573 let $rows = 1;
574 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
575
576 --echo # SUBSTRING_INDEX()
577 let $cols = a varchar(15), b varchar(10) as (substring_index(a,'.',2));
578 let $values1 = 'www.mysql.com',default;
579 let $rows = 1;
580 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
581
582 --echo # SUBSTRING()
583 let $cols = a varchar(5), b varchar(10) as (substring(a from 2 for 2));
584 let $values1 = 'Hello',default;
585 let $rows = 1;
586 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
587
588 --echo # TRIM()
589 let $cols = a varchar(15), b varchar(10) as (trim(a));
590 let $values1 = ' aa ',default;
591 let $rows = 1;
592 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
593
594 --echo # UCASE()
595 let $cols = a varchar(5), b varchar(10) as (ucase(a));
596 let $values1 = 'MySQL',default;
597 let $rows = 1;
598 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
599
600 --echo # UNHEX()
601 let $cols = a varchar(15), b varchar(10) as (unhex(a));
602 let $values1 = '4D7953514C',default;
603 let $rows = 1;
604 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
605
606 --echo # UPPER()
607 let $cols = a varchar(5), b varchar(10) as (upper(a));
608 let $values1 = 'MySQL',default;
609 let $rows = 1;
610 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
611
612 --echo #
613 --echo # CONTROL FLOW FUNCTIONS
614 --echo #
615
616 --echo # CASE
617 let $cols = a varchar(10), b varchar(16) as (case a when NULL then 'asd' when 'b' then 'B' else a end);
618 let $values1 = NULL,default;
619 let $values2 = 'b',default;
620 let $values3 = 'c',default;
621 let $rows = 3;
622 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
623
624 --echo # IF
625 let $cols = a int, b int, c int as (if(a=1,a,b));
626 let $values1 = 1,2,default;
627 let $values2 = 3,4,default;
628 let $rows = 2;
629 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
630
631 --echo # IFNULL
632 let $cols = a varchar(10), b varchar(10), c varchar(10) as (ifnull(a,'DEFAULT'));
633 let $values1 = NULL,'adf',default;
634 let $values2 = 'a','adf',default;
635 let $rows = 2;
636 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
637
638 --echo # NULLIF
639 let $cols = a varchar(10), b varchar(10) as (nullif(a,'DEFAULT'));
640 let $values1 = 'DEFAULT',default;
641 let $values2 = 'a',default;
642 let $rows = 2;
643 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
644
645 --echo #
646 --echo # OPERATORS
647 --echo #
648
649 --echo # AND, &&
650 let $cols = a int, b bool as (a>0 && a<2);
651 let $values1 = -1,default;
652 let $values2 = 1,default;
653 let $rows = 2;
654 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
655
656 --echo # BETWEEN ... AND ...
657 let $cols = a int, b bool as (a between 0 and 2);
658 let $values1 = -1,default;
659 let $values2 = 1,default;
660 let $rows = 2;
661 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
662
663 --echo # BINARY
664 let $cols = a varchar(10), b varbinary(10) as (binary a);
665 let $values1 = '11',default;
666 let $values2 = 1,default;
667 let $rows = 2;
668 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
669
670 --echo # &
671 let $cols = a int, b int as (a & 5);
672 let $values1 = 1,default;
673 let $values2 = 0,default;
674 let $rows = 2;
675 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
676
677 --echo # ~
678 let $cols = a int, b int as (~a);
679 let $values1 = 1,default;
680 let $rows = 1;
681 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
682
683 --echo # |
684 let $cols = a int, b int as (a | 5);
685 let $values1 = 1,default;
686 let $values2 = 0,default;
687 let $values3 = 2,default;
688 let $rows = 3;
689 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
690
691 --echo # ^
692 let $cols = a int, b int as (a ^ 5);
693 let $values1 = 1,default;
694 let $values2 = 0,default;
695 let $values3 = 2,default;
696 let $rows = 3;
697 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
698
699 --echo # DIV
700 let $cols = a int, b int as (a div 5);
701 let $values1 = 1,default;
702 let $values2 = 7,default;
703 let $rows = 2;
704 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
705
706 --echo # <=>
707 let $cols = a int, b int, c bool as (a <=> b);
708 let $values1 = 1,1,default;
709 let $values2 = NULL,NULL,default;
710 let $values3 = 1,NULL,default;
711 let $rows = 3;
712 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
713
714 --echo # =
715 let $cols = a varchar(10), b varchar(10), c bool as (a=b);
716 let $values1 = 'a','b',default;
717 let $values2 = 'a','a',default;
718 let $rows = 2;
719 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
720
721 --echo # >=
722 let $cols = a varchar(10), b varchar(10), c bool as (a >= b);
723 let $values1 = 'a','b',default;
724 let $values2 = 'a','a',default;
725 let $rows = 2;
726 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
727
728 --echo # >
729 let $cols = a varchar(10), b varchar(10), c bool as (a > b);
730 let $values1 = 'a','b',default;
731 let $values2 = 'a','a',default;
732 let $rows = 2;
733 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
734
735 --echo # IS NOT NULL
736 let $cols = a int, b bool as (a is not null);
737 let $values1 = 1,default;
738 let $values2 = NULL,default;
739 let $rows = 2;
740 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
741
742 --echo # IS NULL
743 let $cols = a int, b bool as (a is null);
744 let $values1 = 1,default;
745 let $values2 = NULL,default;
746 let $rows = 2;
747 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
748
749 --echo # <<
750 let $cols = a int, b int as (a << 2);
751 let $values1 = 1,default;
752 let $values2 = 3,default;
753 let $rows = 2;
754 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
755
756 --echo # <=
757 let $cols = a varchar(10), b varchar(10), c bool as (a <= b);
758 let $values1 = 'b','a',default;
759 let $values2 = 'b','b',default;
760 let $values3 = 'b','c',default;
761 let $rows = 3;
762 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
763
764 --echo # <
765 let $cols = a varchar(10), b varchar(10), c bool as (a < b);
766 let $values1 = 'b','a',default;
767 let $values2 = 'b','b',default;
768 let $values3 = 'b','c',default;
769 let $rows = 3;
770 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
771
772 --echo # NOT BETWEEN ... AND ...
773 let $cols = a int, b bool as (a not between 0 and 2);
774 let $values1 = -1,default;
775 let $values2 = 1,default;
776 let $rows = 2;
777 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
778
779 --echo # <>
780 let $cols = a varchar(10), b varchar(10), c bool as (a <> b);
781 let $values1 = 'b','a',default;
782 let $values2 = 'b','b',default;
783 let $values3 = 'b','c',default;
784 let $rows = 3;
785 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
786
787 --echo # !=
788 let $cols = a varchar(10), b varchar(10), c bool as (a != b);
789 let $values1 = 'b','a',default;
790 let $values2 = 'b','b',default;
791 let $values3 = 'b','c',default;
792 let $rows = 3;
793 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
794
795 --echo # ||, OR
796 let $cols = a int, b int as (a>5 || a<3);
797 let $values1 = 1,default;
798 let $values2 = 4,default;
799 let $rows = 2;
800 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
801
802 --echo # >>
803 let $cols = a int, b int as (a >> 2);
804 let $values1 = 8,default;
805 let $values2 = 3,default;
806 let $rows = 2;
807 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
808
809 --echo # XOR
810 let $cols = a int, b int as (a xor 5);
811 let $values1 = 0,default;
812 let $values2 = 1,default;
813 let $values3 = 2,default;
814 let $rows = 3;
815 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
816
817 --echo #
818 --echo # DATE AND TIME FUNCTIONS
819 --echo #
820
821 --echo # ADDDATE()
822 let $cols = a datetime, b datetime as (adddate(a,interval 1 month));
823 let $values1 = '2008-08-31',default;
824 let $rows = 1;
825 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
826
827 --echo # ADDTIME()
828 let $cols = a datetime, b datetime as (addtime(a,'02:00:00'));
829 let $values1 = '2008-08-31',default;
830 let $rows = 1;
831 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
832
833 --echo # CONVERT_TZ()
834 let $cols = a datetime, b datetime as (convert_tz(a,'MET','UTC'));
835 let $values1 = '2008-08-31',default;
836 let $rows = 1;
837 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
838
839 --echo # DATE_ADD()
840 let $cols = a datetime, b datetime as (date_add(a,interval 1 month));
841 let $values1 = '2008-08-31',default;
842 let $rows = 1;
843 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
844
845 --echo # DATE_SUB()
846 let $cols = a datetime, b datetime as (date_sub(a,interval 1 month));
847 let $values1 = '2008-08-31',default;
848 let $rows = 1;
849 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
850
851 --echo # DATE()
852 let $cols = a datetime, b datetime as (date(a));
853 let $values1 = '2008-08-31 02:00:00',default;
854 let $rows = 1;
855 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
856
857 --echo # DATEDIFF()
858 let $cols = a datetime, b long as (datediff(a,'2000-01-01'));
859 let $values1 = '2008-08-31',default;
860 let $rows = 1;
861 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
862
863 --echo # DAY()
864 let $cols = a datetime, b int as (day(a));
865 let $values1 = '2008-08-31',default;
866 let $rows = 1;
867 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
868
869 --echo # DAYOFMONTH()
870 let $cols = a datetime, b int as (dayofmonth(a));
871 let $values1 = '2008-08-31',default;
872 let $rows = 1;
873 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
874
875 --echo # DAYOFWEEK()
876 let $cols = a datetime, b int as (dayofweek(a));
877 let $values1 = '2008-08-31',default;
878 let $rows = 1;
879 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
880
881 --echo # DAYOFYEAR()
882 let $cols = a datetime, b int as (dayofyear(a));
883 let $values1 = '2008-08-31',default;
884 let $rows = 1;
885 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
886
887 --echo # EXTRACT
888 let $cols = a datetime, b int as (extract(year from a));
889 let $values1 = '2008-08-31',default;
890 let $rows = 1;
891 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
892
893 --echo # FROM_DAYS()
894 let $cols = a long, b datetime as (from_days(a));
895 let $values1 = 730669,default;
896 let $rows = 1;
897 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
898
899 --echo # FROM_UNIXTIME()
900 let $cols = a long, b datetime as (from_unixtime(a));
901 let $values1 = 1196440219,default;
902 let $rows = 1;
903 set time_zone='UTC';
904 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
905
906 --echo # HOUR()
907 let $cols = a time, b long as (hour(a));
908 let $values1 = '10:05:03',default;
909 let $rows = 1;
910 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
911
912 --echo # LAST_DAY()
913 let $cols = a datetime, b datetime as (last_day(a));
914 let $values1 = '2003-02-05',default;
915 let $values2 = '2003-02-32',default;
916 let $rows = 2;
917 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
918
919 --echo # MAKEDATE()
920 let $cols = a int, b datetime as (makedate(a,1));
921 let $values1 = 2001,default;
922 let $rows = 1;
923 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
924
925 --echo # MAKETIME()
926 let $cols = a int, b time as (maketime(a,1,3));
927 let $values1 = 12,default;
928 let $rows = 1;
929 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
930
931 --echo # MICROSECOND()
932 let $cols = a datetime, b long as (microsecond(a));
933 let $values1 = '2009-12-31 12:00:00.123456',default;
934 let $values2 = '2009-12-31 23:59:59.000010',default;
935 let $rows = 2;
936 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
937
938 --echo # MINUTE()
939 let $cols = a datetime, b int as (minute(a));
940 let $values1 = '2009-12-31 23:59:59.000010',default;
941 let $rows = 1;
942 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
943
944 --echo # MONTH()
945 let $cols = a datetime, b int as (month(a));
946 let $values1 = '2009-12-31 23:59:59.000010',default;
947 let $rows = 1;
948 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
949
950 --echo # PERIOD_ADD()
951 let $cols = a int, b int as (period_add(a,2));
952 let $values1 = 200801,default;
953 let $rows = 1;
954 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
955
956 --echo # PERIOD_DIFF()
957 let $cols = a int, b int, c int as (period_diff(a,b));
958 let $values1 = 200802,200703,default;
959 let $rows = 1;
960 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
961
962 --echo # QUARTER()
963 let $cols = a datetime, b int as (quarter(a));
964 let $values1 = '2008-08-31',default;
965 let $rows = 1;
966 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
967
968 --echo # SEC_TO_TIME()
969 let $cols = a long, b time as (sec_to_time(a));
970 let $values1 = 2378,default;
971 let $rows = 1;
972 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
973
974 --echo # SECOND()
975 let $cols = a datetime, b int as (second(a));
976 let $values1 = '10:05:03',default;
977 let $rows = 1;
978 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
979
980 --echo # STR_TO_DATE()
981 let $cols = a varchar(64), b datetime as (str_to_date(a,'%m/%d/%Y'));
982 let $values1 = '04/30/2004',default;
983 let $rows = 1;
984 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
985
986 --echo # SUBDATE()
987 let $cols = a datetime, b datetime as (subdate(a,interval 1 month));
988 let $values1 = '2008-08-31',default;
989 let $rows = 1;
990 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
991
992 --echo # SUBTIME()
993 let $cols = a datetime, b datetime as (subtime(a,'02:00:00'));
994 let $values1 = '2008-08-31',default;
995 let $rows = 1;
996 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
997
998 --echo # TIME_TO_SEC()
999 let $cols = a time, b long as (time_to_sec(a));
1000 let $values1 = '22:23:00',default;
1001 let $rows = 1;
1002 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1003
1004 --echo # TIME()
1005 let $cols = a datetime, b time as (time(a));
1006 let $values1 = '2008-08-31 02:03:04',default;
1007 let $rows = 1;
1008 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1009
1010 --echo # TIMEDIFF()
1011 let $cols = a datetime, b datetime, c long as (timediff(a,b));
1012 let $values1 = '2008-12-31 23:59:59.000001','2008-12-30 01:01:01.000002',default;
1013 let $rows = 1;
1014 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1015
1016 --echo # TIMESTAMP()
1017 let $cols = a datetime, b timestamp as (timestamp(a));
1018 let $values1 = '2008-12-31',default;
1019 let $rows = 1;
1020 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1021
1022 --echo # TIMESTAMPADD()
1023 let $cols = a datetime, b timestamp as (timestampadd(minute,1,a));
1024 let $values1 = '2003-01-02',default;
1025 let $rows = 1;
1026 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1027
1028 --echo # TIMESTAMPDIFF()
1029 let $cols = a timestamp, b timestamp, c long as (timestampdiff(MONTH, a,b));
1030 let $values1 = '2003-02-01','2003-05-01',default;
1031 let $rows = 1;
1032 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1033
1034 --echo # TO_DAYS()
1035 let $cols = a datetime, b long as (to_days(a));
1036 let $values1 = '2007-10-07',default;
1037 let $rows = 1;
1038 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1039
1040 --echo # WEEK()
1041 let $cols = a datetime, b int as (week(a,0));
1042 let $values1 = '2008-09-01',default;
1043 let $rows = 1;
1044 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1045
1046 --echo # WEEKDAY()
1047 let $cols = a datetime, b int as (weekday(a));
1048 let $values1 = '2008-09-01',default;
1049 let $rows = 1;
1050 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1051
1052 --echo # WEEKOFYEAR()
1053 let $cols = a datetime, b int as (weekofyear(a));
1054 let $values1 = '2008-09-01',default;
1055 let $rows = 1;
1056 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1057
1058 --echo # YEAR()
1059 let $cols = a datetime, b int as (year(a));
1060 let $values1 = '2008-09-01',default;
1061 let $rows = 1;
1062 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1063
1064 --echo # YEARWEEK()
1065 let $cols = a datetime, b int as (yearweek(a));
1066 let $values1 = '2008-09-01',default;
1067 let $rows = 1;
1068 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1069
1070 --echo #
1071 --echo # FULL TEXT SEARCH FUNCTIONS
1072 --echo #
1073 --echo # None.
1074
1075 --echo #
1076 --echo # CAST FUNCTIONS AND OPERATORS
1077 --echo #
1078
1079 --echo # CAST()
1080 let $cols = a int, b long as (cast(a as unsigned));
1081 let $values1 = 1,default;
1082 let $values2 = -1,default;
1083 let $rows = 2;
1084 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1085
1086 --echo # Convert()
1087 let $cols = a int, b long as (convert(a,unsigned));
1088 let $values1 = 1,default;
1089 let $values2 = -1,default;
1090 let $rows = 2;
1091 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1092
1093 --echo #
1094 --echo # XML FUNCTIONS
1095 --echo #
1096 --echo # None.
1097
1098
1099 --echo #
1100 --echo # OTHER FUNCTIONS
1101 --echo #
1102
1103 --echo # AES_DECRYPT(), AES_ENCRYPT()
1104 let $cols = a varchar(1024), b varchar(1024) as (aes_encrypt(aes_decrypt(a,'adf'),'adf'));
1105 let $values1 = 'MySQL',default;
1106 let $rows = 1;
1107 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1108
1109 --echo # BIT_COUNT()
1110 let $cols = a int, b int as (bit_count(a));
1111 let $values1 = 5,default;
1112 let $rows = 1;
1113 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1114
1115 --echo # COMPRESS(), UNCOMPRESS()
1116 let $cols = a varchar(1024), b varchar(1024) as (uncompress(compress(a)));
1117 let $values1 = 'MySQL',default;
1118 let $rows = 1;
1119 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1120
1121 --echo # ENCODE(), DECODE()
1122 let $cols = a varchar(1024), b varchar(1024) as (decode(encode(a,'abc'),'abc'));
1123 let $values1 = 'MySQL',default;
1124 let $rows = 1;
1125 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1126
1127 --echo # DEFAULT()
1128 let $cols = a varchar(1024) default 'aaa', b varchar(1024) as (ifnull(a,default(a)));
1129 let $values1 = 'any value',default;
1130 let $rows = 1;
1131 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1132
1133 #--echo # DES_ENCRYPT(), DES_DECRYPT()
1134 #--source include/have_ssl_communication.inc
1135 #let $cols = a varchar(1024), b varchar(1024) as (des_encrypt(des_decrypt(a,'adf'),'adf'));
1136 #let $values1 = 'MySQL',default;
1137 #let $rows = 1;
1138 #--source suite/vcol/inc/vcol_supported_sql_funcs.inc
1139
1140 --echo # INET_ATON(), INET_NTOA()
1141 let $cols = a varchar(1024), b varchar(1024) as (inet_ntoa(inet_aton(a)));
1142 let $values1 = '127.0.0.1',default;
1143 let $rows = 1;
1144 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1145
1146 --echo # MD5()
1147 let $cols = a varchar(1024), b varbinary(32) as (md5(a));
1148 let $values1 = 'testing',default;
1149 let $rows = 1;
1150 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1151
1152 --echo # OLD_PASSWORD()
1153 let $cols = a varchar(1024), b varchar(1024) as (old_password(a));
1154 let $values1 = 'badpwd',default;
1155 let $rows = 1;
1156 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1157
1158 --echo # PASSWORD()
1159 let $cols = a varchar(1024), b varchar(1024) as (password(a));
1160 let $values1 = 'badpwd',default;
1161 let $rows = 1;
1162 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1163
1164 --echo # SHA1()
1165 let $cols = a varchar(1024), b varchar(1024) as (sha1(a));
1166 let $values1 = 'abc',default;
1167 let $rows = 1;
1168 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1169
1170 --echo # SHA()
1171 let $cols = a varchar(1024), b varchar(1024) as (sha(a));
1172 let $values1 = 'abc',default;
1173 let $rows = 1;
1174 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1175
1176 --echo # UNCOMPRESSED_LENGTH()
1177 let $cols = a char, b varchar(1024) as (uncompressed_length(compress(repeat(a,30))));
1178 let $values1 = 'a',default;
1179 let $rows = 1;
1180 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1181
1182 --echo # MONTHNAME()
1183 let $cols = a date, b varchar(100) as (monthname(a));
1184 let $values1 = '2010-10-10',default;
1185 let $rows = 1;
1186 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1187
1188 --echo # DAYNAME()
1189 let $cols = a date, b varchar(100) as (dayname(a));
1190 let $values1 = '2011-11-11',default;
1191 let $rows = 1;
1192 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1193
1194 --echo # DATE_FORMAT()
1195 let $cols = a date, b varchar(100) as (date_format(a, '%W %a %M %b'));
1196 let $values1 = '2012-12-12',default;
1197 let $rows = 1;
1198 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1199
1200 --echo # DATE_FORMAT() STORED
1201 let $cols = a date, b varchar(100) as (date_format(a, '%W %a %M %b', 'de_DE')) STORED;
1202 let $values1 = '2012-12-12',default;
1203 let $rows = 1;
1204 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1205
1206 --echo # CURRENT_USER()
1207 let $cols = a char, b varchar(32) as (current_user());
1208 let $values1 = 'a', default;
1209 let $rows = 1;
1210 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1211
1212 --echo # TIME_FORMAT()
1213 let $cols = a datetime, b varchar(10) as (time_format(a,"%H.%i.%S"));
1214 let $values1 = '2001-01-01 02:03:04',default;
1215 let $rows = 1;
1216 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1217
1218 --echo # TIME_FORMAT() STORED
1219 let $cols = a datetime, b varchar(10) as (time_format(a,"%H.%i.%S")) STORED;
1220 let $values1 = '2001-01-01 02:03:04',default;
1221 let $rows = 1;
1222 --source suite/vcol/inc/vcol_supported_sql_funcs.inc
1223