github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/function/func_math.sql (about)

     1  -- @suite
     2  -- @setup
     3  drop table if exists t1;
     4  create table t1 (id int,d int,fl float,de decimal);
     5  insert into t1 values(1,1,123.0213,1.001);
     6  insert into t1 values(2,2,1.0213,1.001);
     7  insert into t1 values(3,null,null,null);
     8  insert into t1 values(4,0,0,0);
     9  
    10  -- @case
    11  -- @desc:test for sinh,atan,acos,cot,tan,sin
    12  -- @label:bvt
    13  select sinh(d),sinh(fl)from t1;
    14  select atan(d),atan(fl)from t1;
    15  select acos(d),acos(fl)from t1;
    16  
    17  select cot(d),cot(fl) from t1;
    18  select cot(d),cot(fl) from t1 where d <> 0;
    19  
    20  select tan(d),tan(fl) from t1;
    21  select sin(d),sin(fl) from t1;
    22  
    23  
    24  -- @suite
    25  -- @setup
    26  drop table if exists abs;
    27  create table abs(id int,d int,dl double,fl float,de decimal);
    28  insert into abs values(1,-10,-10,-10.0321,-10.312);
    29  insert into abs values(2,-2,-2,-2.0321,-2.3765);
    30  insert into abs values(3,-10,-18446744073709551614,-10.0321,-10.312);
    31  insert into abs values(4,-31232,-9223372036854775808,-1312.0321,-973.3072);
    32  insert into abs values(1,-6,-432432.43,-8756.4321,-356.421);
    33  insert into abs values(1,null,null,null,null);
    34  
    35  -- @case
    36  -- @desc:test for abs
    37  -- @label:bvt
    38  select abs(d),abs(dl),abs(fl) from abs;
    39  select abs(d)-2 from t1;
    40  select abs(d)*2 from t1;
    41  select abs(tan(d))*2 from t1;
    42  
    43  
    44  -- @suite
    45  -- @setup
    46  drop table if exists ceil;
    47  create table ceil(id int,d int,dl double,fl float,de decimal);
    48  insert into ceil values(1,5,5,-5.5,-5.5);
    49  insert into ceil values(2,-2,18446744073709551614,-2.5,-5.2);
    50  insert into ceil values(2,-1,18446744073709551614,1.23,-1.23);
    51  insert into ceil values(2,-1,1844674407370955161,1.23,-1.23);
    52  insert into ceil values(2,-1,-9223372036854775808,1.23,-1.23);
    53  insert into ceil values(2,-1,-184467440737095516,1.23,-1.23);
    54  insert into ceil values(2,-1,-922337203685477580,1.23,-1.23);
    55  insert into ceil values(2,-1,-922337203685477580,1.23,-1.23);
    56  insert into ceil values(2,-1,-99999999999999999.9,1.23,-1.23);
    57  insert into ceil values(2,-1,-99999999999999999.9,1.23,-1.23);
    58  
    59  -- @case
    60  -- @desc:test for abs
    61  -- @label:bvt
    62  select ceil(d),ceil(dl),ceil(fl) from ceil;
    63  
    64  drop table t1;
    65  drop table ceil;
    66  drop table abs;