Debian Codegraph @

mysql-test/suite/gcol/inc/gcol_supported_sql_funcs_main.inc

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