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

     1  select log10(log10(10000)),log10(log10(10));
     2  log10(log10(10000))    log10(log10(10))
     3  0.6020599913279624    0.0
     4  SELECT log10(1000);
     5  log10(1000)
     6  3.0
     7  SELECT log10(-10);
     8  invalid argument log10, bad value -10
     9  SELECT log10(0);
    10  invalid argument log10, bad value 0
    11  select log10(0.00000000000000001);
    12  log10(0.00000000000000001)
    13  -17.0
    14  select log10(2e2);
    15  log10(2e2)
    16  2.301029995663981
    17  select log10(0.141241241241313);
    18  log10(0.141241241241313)
    19  -0.8500384744714139
    20  select log10(-124314124124.12412341);
    21  invalid argument log10, bad value -1.2431412412412413e+11
    22  select log10(null);
    23  log10(null)
    24  null
    25  CREATE TABLE t1(a DOUBLE);
    26  INSERT INTO t1 select (log10(56));
    27  INSERT INTO t1 select (log10(100));
    28  SELECT * FROM t1 ORDER BY a;
    29  a
    30  1.7481880270062005
    31  2.0
    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 log10(a),log10(b),log10(c),log10(d),log10(e),log10(f),log10(g),log10(h) from t1;
    36  log10(a)    log10(b)    log10(c)    log10(d)    log10(e)    log10(f)    log10(g)    log10(h)
    37  0.0    0.0    0.3010299956639812    0.6020599913279624    0.6989700043360187    0.7403626894942439    1.4931791206825151    1.1557610128779234
    38  drop table t1;
    39  select log10(123.54-123.03);
    40  log10(123.54 - 123.03)
    41  -0.2924298239020636
    42  select log10(123.54*0.34);
    43  log10(123.54 * 0.34)
    44  1.62328651404393
    45  select log10(134)-log10(194);
    46  log10(134) - log10(194)
    47  -0.16069693156541875
    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 log10(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 (log10(t1.a) <> log10(t2.a));
    61  a    a
    62  2    10
    63  2    4
    64  100    10
    65  100    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 log10(b)>0;
    72  b
    73  43.413
    74  drop table t1;