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

     1  #SINH mysql不支持, 仅可在MO中测试
     2  
     3  SELECT SINH(PI());
     4  SELECT ROUND(SINH(PI()));
     5  SELECT SINH(PI());
     6  SELECT SINH(12);
     7  SELECT SINH(PI());
     8  SELECT SINH(PI()+1);
     9  #SELECT SINH(0.2);
    10  SELECT SINH(1);
    11  SELECT SINH(1.0001);
    12  SELECT SINH(0);
    13  SELECT SINH(2);
    14  SELECT SINH(-2);
    15  
    16  
    17  #EXTREME VALUES
    18  SELECT SINH(13413);
    19  SELECT SINH(-3114);
    20  
    21  SELECT SINH(1);
    22  SELECT SINH(-1);
    23  SELECT SINH(0);
    24  SELECT SINH(0.001);
    25  SELECT SINH(-0.001);
    26  SELECT SINH("ABC");
    27  
    28  #NULL
    29  SELECT SINH(NULL);
    30  
    31  
    32  #DATA TYPE
    33  create table t1(a tinyint, b SMALLINT, c bigint, d INT, e BIGINT, f FLOAT, g DOUBLE, h decimal(38,19), i DATE, k datetime, l TIMESTAMP, m char(255), n varchar(255));
    34  insert into t1 values(1, 1, 2, 43, 5, 35.5, 31.133, 14.314, "2012-03-10", "2012-03-12 10:03:12", "2022-03-12 13:03:12", "ab23c", "d5cf");
    35  insert into t1 values(71, 1, 2, 34, 5, 5.5, 341.13, 15.314, "2012-03-22", "2013-03-12 10:03:12", "2032-03-12 13:04:12", "abr23c", "3dcf");
    36  insert into t1 values(1, 1, 21, 4, 54, 53.5, 431.13, 14.394, "2011-03-12", "2015-03-12 10:03:12", "2002-03-12 13:03:12", "afbc", "dct5f");
    37  insert into t1 values(1, 71, 2, 34, 5, 5.5, 31.313, 124.314, "2012-01-12", "2019-03-12 10:03:12", "2013-03-12 13:03:12", "3abd1c", "dcvf");
    38  select SINH(a), SINH(b), SINH(c), SINH(d), SINH(e), SINH(f), SINH(g), SINH(h), SINH(i), SINH(j), SINH(k), SINH(l) from t1;
    39  drop table t1;
    40  
    41  
    42  #0.5暂不支持time类型
    43  #create table t1(a time)
    44  #insert into t1 values("10:03:12");
    45  #select sin(a), cos(a), tan(a),cot(a),asin(a),acos(a),atan(a),atan2(a,a) from t1;
    46  #drop table t1;
    47  
    48  
    49  #INSERT, DISTINCT
    50  Create table t1(a float);
    51  insert into t1 select (SINH(1));
    52  insert into t1 select (SINH(0));
    53  insert into t1 select (SINH(1));
    54  insert into t1 select (SINH(0));
    55  insert into t1 select (acos(1));
    56  insert into t1 select (atan(1));
    57  select distinct a from t1;
    58  drop table t1;
    59  
    60  
    61  #WHERE
    62  drop table if exists t1;
    63  create table t1(a INT,  b float);
    64  insert into t1 values(1, 0),(0, 1),(1,1),(0,0);
    65  select * from t1 where SINH(a)<>SINH(b);
    66  drop table t1;
    67  
    68  
    69  #ON CONDITION
    70  create table t1(a INT,  b float);
    71  create table t2(a INT,  b float);
    72  insert into t1 values(1, 0),(0, 1),(1,1),(0,0);
    73  insert into t2 values(0, 1),(1, 0),(1,1),(0,0);
    74  SELECT t1.a, t2.a FROM t1 JOIN t2 ON (SINH(t1.a)=SINH(t2.b));
    75  drop table t1;
    76  drop table t2;
    77  
    78  #HAVING
    79  drop table if exists t1;
    80  create table t1(a INT,  b float);
    81  insert into t1 values(1, 0),(0, 1),(1,1),(0,0);
    82  SELECT a FROM t1 group by a having SINH(a)>0;
    83  drop table t1;
    84  
    85  #科学计算
    86  SELECT SINH(0.745e5);
    87  
    88  
    89