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