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