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

     1  select ascii(0);
     2  select ascii(-1);
     3  select ascii(1);
     4  select ascii(2);
     5  select ascii(127);
     6  select ascii(-128);
     7  select ascii(128);
     8  select ascii(32767);
     9  select ascii(-32768);
    10  select ascii(32768);
    11  select ascii(2147483647);
    12  select ascii(-2147483648);
    13  select ascii(2147483648);
    14  select ascii(9223372036854775807);
    15  select ascii(-9223372036854775808);
    16  select ascii(9223372036854775808);
    17  select ascii(18446744073709551615);
    18  select ascii(-18446744073709551616);
    19  select ascii(18446744073709551616);
    20  select ascii(null);
    21  select ascii('a');
    22  select ascii('ab');
    23  select ascii('qaq');
    24  select ascii('啊咋');
    25  select ascii('1.2121');
    26  select ascii('1.2121a');
    27  select ascii('');
    28  select ascii(' ');
    29  select ascii(1.1);
    30  select ascii(0.9);
    31  select ascii(-0.5);
    32  select ascii(34567876534567.4321);
    33  select ascii(-3.45678765345674321e-10);
    34  select ascii(3.402823466385288598117041834516925440e38);
    35  select ascii(1.401298464324817070923729583289916131280e-45);
    36  select ascii(1.797693134862315708145274237317043567981e308);
    37  select ascii(4.940656458412465441765687928682213723651e-324);
    38  create table t1 (c1 int);
    39  insert into t1 values (1), (2), (3),(null);
    40  select ascii(c1) from t1;
    41  select ascii(null) from t1;