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