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

     1  select log(exp(10));
     2  log(exp(10))
     3  10.0
     4  select exp(log(sqrt(10))*2);
     5  exp(log(sqrt(10))*2)
     6  10.000000000000002
     7  SELECT EXP(2);
     8  EXP(2)
     9  7.38905609893065
    10  SELECT EXP(-2);
    11  EXP(-2)
    12  0.1353352832366127
    13  SELECT EXP(0);
    14  EXP(0)
    15  1.0
    16  select EXP(0.00000000000000001);
    17  EXP(0.00000000000000001)
    18  1.0
    19  select EXP(2e2);
    20  EXP(2e2)
    21  7.225973768125749E86
    22  select EXP(0.141241241241313);
    23  EXP(0.141241241241313)
    24  1.1517024526037207
    25  select EXP(-124314124124.12412341);
    26  EXP(-124314124124.12412341)
    27  0.0
    28  select exp(null);
    29  exp(null)
    30  null
    31  CREATE TABLE t1(a DOUBLE);
    32  INSERT INTO t1 select (exp(56));
    33  INSERT INTO t1 select (exp(100));
    34  SELECT * FROM t1 ORDER BY a;
    35  a
    36  2.091659496012996E24
    37  2.6881171418161356E43
    38  drop table t1;
    39  create table t1(a tinyint, b SMALLINT, c bigint, d INT, e BIGINT, f FLOAT, g DOUBLE, h decimal(38,19));
    40  insert into t1 values(1, 1, 2, 4, 5, 5.5, 31.13, 14.314);
    41  select EXP(a),EXP(b),EXP(c),EXP(d),EXP(e),EXP(f),EXP(g),EXP(h) from t1;
    42  EXP(a)	EXP(b)	EXP(c)	EXP(d)	EXP(e)	EXP(f)	EXP(g)	EXP(h)
    43  2.718281828459045	2.718281828459045	7.38905609893065	54.598150033144236	148.4131591025766	244.69193226422038	3.3081654501713676E13	1646232.6617210666
    44  drop table t1;
    45  select EXP(123.54-123.03);
    46  EXP(123.54-123.03)
    47  1.6652911949458864
    48  select EXP(123.54*0.34);
    49  EXP(123.54*0.34)
    50  1.74554761534837658E18
    51  select EXP(134)-EXP(194);
    52  EXP(134)-EXP(194)
    53  -1.7911398206275708E84
    54  drop table if exists t1;
    55  create table t1(a int);
    56  insert into t1 values(10), (100);
    57  select distinct * from t1 where exp(a)>0;
    58  a
    59  10
    60  100
    61  drop table t1;
    62  create table t1(a INT, b int);
    63  create table t2(a INT, b int);
    64  insert into t1 values(2,4), (100,23);
    65  insert into t2 values(10,100), (4,41);
    66  SELECT t1.a, t2.a FROM t1 JOIN t2 ON (exp(t1.a) <> exp(t2.a));
    67  a	a
    68  100	10
    69  2	10
    70  100	4
    71  2	4
    72  drop table t1;
    73  drop table t2;
    74  drop table if exists t1;
    75  create table t1(a float,  b float);
    76  insert into t1 values(14.413, 43.413), (8.123, 0.409);
    77  select b from t1 group by b having exp(b)>0;
    78  b
    79  43.413
    80  0.409
    81  drop table t1;