github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/function/func_upper_lower.result (about)

     1  select to_upper('abc'), upper('abc');
     2  to_upper(abc)    upper(abc)
     3  ABC    ABC
     4  select to_upper('abc 123'), upper('abc 123');
     5  to_upper(abc 123)    upper(abc 123)
     6  ABC 123    ABC 123
     7  select to_upper(null);
     8  to_upper(null)
     9  null
    10  create table up_t(a varchar(10), b char(10));
    11  insert into up_t values('abc', 'abc');
    12  insert into up_t values(null, null);
    13  insert into up_t values('abc 123', 'abc 123');
    14  select to_upper(a), upper(a) from up_t;
    15  to_upper(a)    upper(a)
    16  ABC    ABC
    17  null    null
    18  ABC 123    ABC 123
    19  select to_upper(b), upper(b) from up_t;
    20  to_upper(b)    upper(b)
    21  ABC    ABC
    22  null    null
    23  ABC 123    ABC 123
    24  select to_lower('ABC'), lower('ABC');
    25  to_lower(ABC)    lower(ABC)
    26  abc    abc
    27  select to_lower('AbC 123'), lower('AbC 123');
    28  to_lower(AbC 123)    lower(AbC 123)
    29  abc 123    abc 123
    30  select to_lower(null);
    31  to_lower(null)
    32  null
    33  create table low_t(a varchar(10), b char(10));
    34  insert into low_t values('ABC', 'ABC');
    35  insert into low_t values(null, null);
    36  insert into low_t values('AbC 123', 'AbC 123');
    37  select to_lower(a), lower(a) from low_t;
    38  to_lower(a)    lower(a)
    39  abc    abc
    40  null    null
    41  abc 123    abc 123
    42  select to_lower(b), lower(b) from low_t;
    43  to_lower(b)    lower(b)
    44  abc    abc
    45  null    null
    46  abc 123    abc 123
    47  select to_upper(ltrim('   ueenjfwabc123'));
    48  to_upper(ltrim(   ueenjfwabc123))
    49  UEENJFWABC123
    50  select upper(rtrim('  3782dfw23123123123   '));
    51  upper(rtrim(  3782dfw23123123123   ))
    52    3782DFW23123123123
    53  select to_upper(trim('  32431 %^ 3829  3huicn2432g23   '));
    54  to_upper(trim(  32431 %^ 3829  3huicn2432g23   ))
    55  32431 %^ 3829  3HUICN2432G23
    56  select upper(substring('21214avewwe12',3,20));
    57  upper(substring(21214avewwe12, 3, 20))
    58  214AVEWWE12
    59  select upper(reverse('sjkdakjevenjwvev')) as result;
    60  result
    61  VEVWJNEVEJKADKJS
    62  select lower(ltrim('   uEENjfwabc123'));
    63  lower(ltrim(   uEENjfwabc123))
    64  ueenjfwabc123
    65  select to_lower(rtrim('  3782dfWWWW23123123123   '));
    66  to_lower(rtrim(  3782dfWWWW23123123123   ))
    67    3782dfwwww23123123123
    68  select lower(trim('  32431 %^ 3829  3huICN2432g23   '));
    69  lower(trim(  32431 %^ 3829  3huICN2432g23   ))
    70  32431 %^ 3829  3huicn2432g23
    71  select to_lower(substring('21214AewWE12',3,20));
    72  to_lower(substring(21214AewWE12, 3, 20))
    73  214aewwe12
    74  select lower(reverse('sjkDAKjeveBJwvev')) as result;
    75  result
    76  vevwjbevejkadkjs