github.com/matrixorigin/matrixone@v0.7.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  acos(d)	acos(fl)
    21  0.0	null
    22  null	null
    23  null	null
    24  1.5707963267948966	1.5707963267948966
    25  select cot(d),cot(fl) from t1;
    26  invalid argument cot, bad value cot(0)
    27  select cot(d),cot(fl) from t1 where d <> 0;
    28  cot(d)	cot(fl)
    29  0.6420926159343306	1.8340266997618755
    30  -0.4576575543602858	0.6124124816462909
    31  select tan(d),tan(fl) from t1;
    32  tan(d)	tan(fl)
    33  1.557407724654902	0.5452483326059671
    34  -2.185039863261519	1.632886379637126
    35  null	null
    36  0.0	0.0
    37  select sin(d),sin(fl) from t1;
    38  sin(d)	sin(fl)
    39  0.8414709848078965	-0.47871259002208294
    40  0.9092974268256817	0.8527876556479776
    41  null	null
    42  0.0	0.0
    43  drop table if exists abs;
    44  create table abs(id int,d int,dl double,fl float,de decimal);
    45  insert into abs values(1,-10,-10,-10.0321,-10.312);
    46  insert into abs values(2,-2,-2,-2.0321,-2.3765);
    47  insert into abs values(3,-10,-18446744073709551614,-10.0321,-10.312);
    48  insert into abs values(4,-31232,-9223372036854775808,-1312.0321,-973.3072);
    49  insert into abs values(1,-6,-432432.43,-8756.4321,-356.421);
    50  insert into abs values(1,null,null,null,null);
    51  select abs(d),abs(dl),abs(fl) from abs;
    52  abs(d)	abs(dl)	abs(fl)
    53  10	10.0	10.032099723815918
    54  2	2.0	2.032099962234497
    55  10	1.8446744073709552E19	10.032099723815918
    56  31232	9.223372036854776E18	1312.0321044921875
    57  6	432432.43	8756.431640625
    58  null	null	null
    59  select abs(d)-2 from t1;
    60  abs(d)-2
    61  -1
    62  0
    63  null
    64  -2
    65  select abs(d)*2 from t1;
    66  abs(d)*2
    67  2
    68  4
    69  null
    70  0
    71  select abs(tan(d))*2 from t1;
    72  abs(tan(d))*2
    73  3.114815449309804
    74  4.370079726523038
    75  null
    76  0.0
    77  drop table if exists ceil;
    78  create table ceil(id int,d int,dl double,fl float,de decimal);
    79  insert into ceil values(1,5,5,-5.5,-5.5);
    80  insert into ceil values(2,-2,18446744073709551614,-2.5,-5.2);
    81  insert into ceil values(2,-1,18446744073709551614,1.23,-1.23);
    82  insert into ceil values(2,-1,1844674407370955161,1.23,-1.23);
    83  insert into ceil values(2,-1,-9223372036854775808,1.23,-1.23);
    84  insert into ceil values(2,-1,-184467440737095516,1.23,-1.23);
    85  insert into ceil values(2,-1,-922337203685477580,1.23,-1.23);
    86  insert into ceil values(2,-1,-922337203685477580,1.23,-1.23);
    87  insert into ceil values(2,-1,-99999999999999999.9,1.23,-1.23);
    88  insert into ceil values(2,-1,-99999999999999999.9,1.23,-1.23);
    89  select ceil(d),ceil(dl),ceil(fl) from ceil;
    90  ceil(d)	ceil(dl)	ceil(fl)
    91  5	5.0	-5.0
    92  -2	1.8446744073709552E19	-2.0
    93  -1	1.8446744073709552E19	2.0
    94  -1	1.84467440737095526E18	2.0
    95  -1	-9.223372036854776E18	2.0
    96  -1	-1.8446744073709552E17	2.0
    97  -1	-9.2233720368547763E17	2.0
    98  -1	-9.2233720368547763E17	2.0
    99  -1	-1.0E17	2.0
   100  -1	-1.0E17	2.0
   101  drop table t1;
   102  drop table ceil;
   103  drop table abs;