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

     1  SELECT SINH(PI());
     2  sinh(pi())
     3  11.5487
     4  SELECT ROUND(SINH(PI()));
     5  round(sinh(pi()))
     6  12.0
     7  SELECT SINH(PI());
     8  sinh(pi())
     9  11.5487
    10  SELECT SINH(12);
    11  sinh(12)
    12  81377.3957
    13  SELECT SINH(PI());
    14  sinh(pi())
    15  11.5487
    16  SELECT SINH(PI()+1);
    17  sinh(pi() + 1)
    18  31.4435
    19  SELECT SINH(1);
    20  sinh(1)
    21  1.1752
    22  SELECT SINH(1.0001);
    23  sinh(1.0001)
    24  1.1754
    25  SELECT SINH(0);
    26  sinh(0)
    27  0.0
    28  SELECT SINH(2);
    29  sinh(2)
    30  3.6269
    31  SELECT SINH(-2);
    32  sinh(-2)
    33  -3.6269
    34  SELECT SINH(13413);
    35  Data truncation: data out of range: data type float64, DOUBLE value is out of range in 'sinh(13413)'
    36  SELECT SINH(-3114);
    37  Data truncation: data out of range: data type float64, DOUBLE value is out of range in 'sinh(-3114)'
    38  SELECT SINH(1);
    39  sinh(1)
    40  1.1752
    41  SELECT SINH(-1);
    42  sinh(-1)
    43  -1.1752
    44  SELECT SINH(0);
    45  sinh(0)
    46  0.0
    47  SELECT SINH(0.001);
    48  sinh(0.001)
    49  0.001
    50  SELECT SINH(-0.001);
    51  sinh(-0.001)
    52  -0.001
    53  SELECT SINH("ABC");
    54  strconv.ParseFloat: parsing "ABC": invalid syntax
    55  SELECT SINH(NULL);
    56  sinh(null)
    57  null
    58  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));
    59  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");
    60  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");
    61  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");
    62  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");
    63  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;
    64  invalid argument function sinh, bad value [DATE]
    65  drop table t1;
    66  Create table t1(a float);
    67  insert into t1 select (SINH(1));
    68  insert into t1 select (SINH(0));
    69  insert into t1 select (SINH(1));
    70  insert into t1 select (SINH(0));
    71  insert into t1 select (acos(1));
    72  insert into t1 select (atan(1));
    73  select distinct a from t1;
    74  a
    75  1.1752012
    76  0.0
    77  0.7853982
    78  drop table t1;
    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 * from t1 where SINH(a)<>SINH(b);
    83  a	b
    84  1	0.0
    85  0	1.0
    86  drop table t1;
    87  create table t1(a INT,  b float);
    88  create table t2(a INT,  b float);
    89  insert into t1 values(1, 0),(0, 1),(1,1),(0,0);
    90  insert into t2 values(0, 1),(1, 0),(1,1),(0,0);
    91  SELECT t1.a, t2.a FROM t1 JOIN t2 ON (SINH(t1.a)=SINH(t2.b));
    92  a	a
    93  1	0
    94  1	1
    95  0	1
    96  0	0
    97  1	0
    98  1	1
    99  0	1
   100  0	0
   101  drop table t1;
   102  drop table t2;
   103  drop table if exists t1;
   104  create table t1(a INT,  b float);
   105  insert into t1 values(1, 0),(0, 1),(1,1),(0,0);
   106  SELECT a FROM t1 group by a having SINH(a)>0;
   107  a
   108  1
   109  drop table t1;
   110  SELECT SINH(0.745e5);
   111  Data truncation: data out of range: data type float64, DOUBLE value is out of range in 'sinh(74500)'