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

     1  select ascii(0);
     2  ascii(0)
     3  48
     4  select ascii(-1);
     5  ascii(-1)
     6  45
     7  select ascii(1);
     8  ascii(1)
     9  49
    10  select ascii(2);
    11  ascii(2)
    12  50
    13  select ascii(127);
    14  ascii(127)
    15  49
    16  select ascii(-128);
    17  ascii(-128)
    18  45
    19  select ascii(128);
    20  ascii(128)
    21  49
    22  select ascii(32767);
    23  ascii(32767)
    24  51
    25  select ascii(-32768);
    26  ascii(-32768)
    27  45
    28  select ascii(32768);
    29  ascii(32768)
    30  51
    31  select ascii(2147483647);
    32  ascii(2147483647)
    33  50
    34  select ascii(-2147483648);
    35  ascii(-2147483648)
    36  45
    37  select ascii(2147483648);
    38  ascii(2147483648)
    39  50
    40  select ascii(9223372036854775807);
    41  ascii(9223372036854775807)
    42  57
    43  select ascii(-9223372036854775808);
    44  ascii(-9223372036854775808)
    45  45
    46  select ascii(9223372036854775808);
    47  ascii(9223372036854775808)
    48  57
    49  select ascii(18446744073709551615);
    50  ascii(18446744073709551615)
    51  49
    52  select ascii(-18446744073709551616);
    53  ascii(-18446744073709551616)
    54  45
    55  select ascii(18446744073709551616);
    56  ascii(18446744073709551616)
    57  49
    58  select ascii(null);
    59  ascii(null)
    60  null
    61  select ascii('a');
    62  ascii(a)
    63  97
    64  select ascii('ab');
    65  ascii(ab)
    66  97
    67  select ascii('qaq');
    68  ascii(qaq)
    69  113
    70  select ascii('啊咋');
    71  ascii(啊咋)
    72  229
    73  select ascii('1.2121');
    74  ascii(1.2121)
    75  49
    76  select ascii('1.2121a');
    77  ascii(1.2121a)
    78  49
    79  select ascii('');
    80  ascii()
    81  0
    82  select ascii(' ');
    83  ascii( )
    84  32
    85  select ascii(1.1);
    86  ascii(1.1)
    87  49
    88  select ascii(0.9);
    89  ascii(0.9)
    90  48
    91  select ascii(-0.5);
    92  ascii(-0.5)
    93  45
    94  select ascii(34567876534567.4321);
    95  ascii(34567876534567.4321)
    96  51
    97  select ascii(-3.45678765345674321e-10);
    98  ascii(-3.45678765345674321e-10)
    99  45
   100  select ascii(3.402823466385288598117041834516925440e38);
   101  ascii(3.402823466385288598117041834516925440e38)
   102  51
   103  select ascii(1.401298464324817070923729583289916131280e-45);
   104  ascii(1.401298464324817070923729583289916131280e-45)
   105  49
   106  select ascii(1.797693134862315708145274237317043567981e308);
   107  ascii(1.797693134862315708145274237317043567981e308)
   108  49
   109  select ascii(4.940656458412465441765687928682213723651e-324);
   110  ascii(4.940656458412465441765687928682213723651e-324)
   111  53
   112  create table t1 (c1 int);
   113  insert into t1 values (1), (2), (3),(null);
   114  select ascii(c1) from t1;
   115  ascii(c1)
   116  49
   117  50
   118  51
   119  null
   120  select ascii(null) from t1;
   121  ascii(null)
   122  null
   123  null
   124  null
   125  null