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

     1  select log(ln(10)),ln(log(2));
     2  log(ln(10))	ln(log(2))
     3  0.834032445247956	-0.36651292058166435
     4  SELECT ln(2);
     5  ln(2)
     6  0.6931471805599453
     7  SELECT ln(-2);
     8  invalid argument ln, bad value -2
     9  SELECT ln(0);
    10  invalid argument ln, bad value 0
    11  select ln(0.00000000000000001);
    12  ln(0.00000000000000001)
    13  -39.14394658089878
    14  select ln(2e2);
    15  ln(2e2)
    16  5.298317366548036
    17  select ln(0.141241241241313);
    18  ln(0.141241241241313)
    19  -1.9572859197892771
    20  select ln(-124314124124.12412341);
    21  invalid argument ln, bad value -1.2431412412412413e+11
    22  select ln(null);
    23  ln(null)
    24  null
    25  CREATE TABLE t1(a DOUBLE);
    26  INSERT INTO t1 select (ln(56));
    27  INSERT INTO t1 select (ln(100));
    28  SELECT * FROM t1 ORDER BY a;
    29  a
    30  4.02535169073515
    31  4.605170185988092
    32  drop table t1;
    33  create table t1(a tinyint, b SMALLINT, c bigint, d INT, e BIGINT, f FLOAT, g DOUBLE, h decimal(38,19));
    34  insert into t1 values(1, 1, 2, 4, 5, 5.5, 31.13, 14.314);
    35  select ln(a),ln(b),ln(c),ln(d),ln(e),ln(f),ln(g),ln(h) from t1;
    36  ln(a)	ln(b)	ln(c)	ln(d)	ln(e)	ln(f)	ln(g)	ln(h)
    37  0.0	0.0	0.6931471805599453	1.3862943611198906	1.6094379124341003	1.7047480922384253	3.4381719844535166	2.661238079316406
    38  drop table t1;
    39  select ln(123.54-123.03);
    40  ln(123.54-123.03)
    41  -0.6733445532637656
    42  select ln(123.54*0.34);
    43  ln(123.54*0.34)
    44  3.737755328895823
    45  select ln(134)-ln(194);
    46  ln(134)-ln(194)
    47  -0.3700183591124171
    48  drop table if exists t1;
    49  create table t1(a int);
    50  insert into t1 values(10), (100);
    51  select distinct * from t1 where ln(a)>0;
    52  a
    53  10
    54  100
    55  drop table t1;
    56  create table t1(a INT, b int);
    57  create table t2(a INT, b int);
    58  insert into t1 values(2,4), (100,23);
    59  insert into t2 values(10,100), (4,41);
    60  SELECT t1.a, t2.a FROM t1 JOIN t2 ON (ln(t1.a) <> ln(t2.a));
    61  a	a
    62  100	10
    63  2	10
    64  100	4
    65  2	4
    66  drop table t1;
    67  drop table t2;
    68  drop table if exists t1;
    69  create table t1(a float,  b float);
    70  insert into t1 values(14.413, 43.413), (8.123, 0.409);
    71  select b from t1 group by b having ln(b)>0;
    72  b
    73  43.413
    74  drop table t1;