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

     1  drop table if exists t1;
     2  create table t1 (id int,d int,fl float,de decimal);
     3  insert into t1 values(1,1,123.0213,1.001);
     4  insert into t1 values(2,2,1.0213,1.001);
     5  insert into t1 values(3,null,null,null);
     6  insert into t1 values(4,0,0,0);
     7  select sinh(d),sinh(fl)from t1;
     8  sinh(d)	sinh(fl)
     9  1.1752	1.3379574503777456E53
    10  3.6269	1.2083
    11  null	null
    12  0.0	0.0
    13  select atan(d),atan(fl)from t1;
    14  atan(d)	atan(fl)
    15  0.7853981633974483	1.5626678322541754
    16  1.1071487177940906	0.7959355256441749
    17  null	null
    18  0.0	0.0
    19  select acos(d),acos(fl)from t1;
    20  invalid argument acos, bad value 2
    21  select cot(d),cot(fl) from t1;
    22  invalid argument cot, bad value 0
    23  select cot(d),cot(fl) from t1 where d <> 0;
    24  cot(d)	cot(fl)
    25  0.6420926159343306	1.8340266997618755
    26  -0.4576575543602858	0.6124124816462909
    27  select tan(d),tan(fl) from t1;
    28  tan(d)	tan(fl)
    29  1.557407724654902	0.5452483326059671
    30  -2.185039863261519	1.632886379637126
    31  null	null
    32  0.0	0.0
    33  select sin(d),sin(fl) from t1;
    34  sin(d)	sin(fl)
    35  0.8414709848078965	-0.47871259002208294
    36  0.9092974268256817	0.8527876556479776
    37  null	null
    38  0.0	0.0
    39  drop table if exists abs;
    40  create table abs(id int,d int,dl double,fl float,de decimal);
    41  insert into abs values(1,-10,-10,-10.0321,-10.312);
    42  insert into abs values(2,-2,-2,-2.0321,-2.3765);
    43  insert into abs values(3,-10,-18446744073709551614,-10.0321,-10.312);
    44  insert into abs values(4,-31232,-9223372036854775808,-1312.0321,-973.3072);
    45  insert into abs values(1,-6,-432432.43,-8756.4321,-356.421);
    46  insert into abs values(1,null,null,null,null);
    47  select abs(d),abs(dl),abs(fl) from abs;
    48  abs(d)	abs(dl)	abs(fl)
    49  10	10.0	10.032099723815918
    50  2	2.0	2.032099962234497
    51  10	1.8446744073709552E19	10.032099723815918
    52  31232	9.223372036854776E18	1312.0321044921875
    53  6	432432.43	8756.431640625
    54  null	null	null
    55  select abs(d)-2 from t1;
    56  abs(d)-2
    57  -1
    58  0
    59  null
    60  -2
    61  select abs(d)*2 from t1;
    62  abs(d)*2
    63  2
    64  4
    65  null
    66  0
    67  select abs(tan(d))*2 from t1;
    68  abs(tan(d))*2
    69  3.114815449309804
    70  4.370079726523038
    71  null
    72  0.0
    73  drop table if exists ceil;
    74  create table ceil(id int,d int,dl double,fl float,de decimal);
    75  insert into ceil values(1,5,5,-5.5,-5.5);
    76  insert into ceil values(2,-2,18446744073709551614,-2.5,-5.2);
    77  insert into ceil values(2,-1,18446744073709551614,1.23,-1.23);
    78  insert into ceil values(2,-1,1844674407370955161,1.23,-1.23);
    79  insert into ceil values(2,-1,-9223372036854775808,1.23,-1.23);
    80  insert into ceil values(2,-1,-184467440737095516,1.23,-1.23);
    81  insert into ceil values(2,-1,-922337203685477580,1.23,-1.23);
    82  insert into ceil values(2,-1,-922337203685477580,1.23,-1.23);
    83  insert into ceil values(2,-1,-99999999999999999.9,1.23,-1.23);
    84  insert into ceil values(2,-1,-99999999999999999.9,1.23,-1.23);
    85  select ceil(d),ceil(dl),ceil(fl) from ceil;
    86  ceil(d)	ceil(dl)	ceil(fl)
    87  5    5.0    -5.0
    88  -2    1.8446744073709552E19    -2.0
    89  -1    1.8446744073709552E19    2.0
    90  -1    1.8446744073709553E18    2.0
    91  -1    -9.223372036854776E18    2.0
    92  -1    -1.8446744073709552E17    2.0
    93  -1    -9.223372036854776E17    2.0
    94  -1    -9.223372036854776E17    2.0
    95  -1    -1.0E17    2.0
    96  -1    -1.0E17    2.0
    97  drop table t1;
    98  drop table ceil;
    99  drop table abs;