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

     1  select log(exp(10)),log(-1),log(NULL),log(1,1),log(3,9),log(-1,2),log(NULL,2);
     2  invalid argument ln, bad value -1
     3  SELECT LOG(2);
     4  LOG(2)
     5  0.6931471805599453
     6  SELECT LOG(-2);
     7  invalid argument ln, bad value -2
     8  SELECT LOG(2,65536);
     9  LOG(2,65536)
    10  16.0
    11  SELECT LOG(10,100);
    12  LOG(10,100)
    13  2.0
    14  SELECT LOG(1,100);
    15  invalid argument log base, bad value 1
    16  select log(2,-1);
    17  invalid argument log input, bad value <= 0
    18  select log(-2,1);
    19  invalid argument log input, bad value <= 0
    20  select log(0.00000000000000001);
    21  log(0.00000000000000001)
    22  -39.14394658089878
    23  select log(10e100);
    24  log(10e100)
    25  232.56109439239862
    26  select log(0.141241241241313, 124314124124.12412341);
    27  log(0.141241241241313, 124314124124.12412341)
    28  -13.051786251584149
    29  select log(-0.141241241241313, -124314124124.12412341);
    30  invalid argument log input, bad value <= 0
    31  select log(null,2);
    32  log(null,2)
    33  null
    34  select log(2, null);
    35  log(2, null)
    36  null
    37  select log(null,null);
    38  log(null,null)
    39  null
    40  CREATE TABLE t1(a DOUBLE);
    41  INSERT INTO t1 select (log(56));
    42  INSERT INTO t1 select (log(10,100));
    43  INSERT INTO t1 select (log(2,4));
    44  SELECT * FROM t1 ORDER BY a;
    45  a
    46  2.0
    47  2.0
    48  4.02535169073515
    49  drop table t1;
    50  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));
    51  insert into t1 values(1, 1, 2, 4, 5, 5.5, 31.13, 14.314, "2012-03-12", "2012-03-12 10:03:12", "2012-03-12 13:03:12", "abc", "dcf");
    52  select log(a),log(b),log(c),log(d),log(e),log(f),log(g),log(h),log(i),log(k),log(l),log(m),log(n) from t1;
    53  invalid argument function log, bad value [DATE]
    54  select log(a,b), log(b,c),log(c,d),log(d,e),log(e,f),log(f,g),log(g,h), log(h,i), log(i,k),log(k,l),log(l,m),log(m,n) from t1;
    55  invalid argument function log, bad value [DECIMAL128 DATE]
    56  drop table t1;
    57  select log(123.54-123.03);
    58  log(123.54-123.03)
    59  -0.6733445532637656
    60  select log(123.54*0.34, 1203-1200);
    61  log(123.54*0.34, 1203-1200)
    62  0.29392300779426694
    63  select log(134)-log(194);
    64  log(134)-log(194)
    65  -0.3700183591124171
    66  drop table if exists t1;
    67  create table t1(a float,  b float);
    68  insert into t1 values(10, 100), (100, 1000);
    69  select distinct * from t1 where log(a, b)=2;
    70  a	b
    71  10.0	100.0
    72  drop table t1;
    73  create table t1(a INT, b int);
    74  create table t2(a INT, b int);
    75  insert into t1 values(2,4), (100,23);
    76  insert into t2 values(10,100), (4,41);
    77  SELECT t1.a, t2.a FROM t1 JOIN t2 ON (log(t1.a, t1.b) = log(t2.a, t2.b));
    78  a	a
    79  2	10
    80  drop table t1;
    81  drop table t2;
    82  drop table if exists t1;
    83  create table t1(a float,  b float);
    84  insert into t1 values(14124.413, 4213.413), (984798.123, 980.409);
    85  select b from t1 group by b having log(b)>0;
    86  b
    87  4213.41
    88  980.409
    89  drop table t1;