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

     1  select power(exp(10), log(100)),exp(power(2,2)),power(-1,1),power(NULL,0),power(1,1),power(3,9),power(-1,2),power(NULL,2);
     2  power(exp(10), log(100))	exp(power(2,2))	power(-1,1)	power(NULL,0)	power(1,1)	power(3,9)	power(-1,2)	power(NULL,2)
     3  1.0000000000000046E20	54.598150033144236	-1.0	null	1.0	19683.0	1.0	null
     4  SELECT power(2,13);
     5  power(2,13)
     6  8192.0
     7  SELECT power(-2,-3);
     8  power(-2,-3)
     9  -0.125
    10  SELECT power(2,100);
    11  power(2,100)
    12  1.2676506002282294E30
    13  SELECT power(10,100);
    14  power(10, 100)
    15  1.0000000000000002E100
    16  SELECT power(1,100);
    17  power(1,100)
    18  1.0
    19  select power(2,-1);
    20  power(2,-1)
    21  0.5
    22  select power(-2,1);
    23  power(-2,1)
    24  -2.0
    25  select power(0.00000000000000001,123413);
    26  power(0.00000000000000001,123413)
    27  0.0
    28  select power(10e100,-39413312);
    29  power(10e100,-39413312)
    30  0.0
    31  select power(0.141241241241313, 124314124124.12412341);
    32  power(0.141241241241313, 124314124124.12412341)
    33  0.0
    34  select power(null,2);
    35  power(null,2)
    36  null
    37  select power(2, null);
    38  power(2, null)
    39  null
    40  select power(null,null);
    41  power(null,null)
    42  null
    43  CREATE TABLE t1(a DOUBLE);
    44  INSERT INTO t1 select (power(56,124));
    45  INSERT INTO t1 select (power(10,100));
    46  INSERT INTO t1 select (power(2,234));
    47  SELECT * FROM t1 ORDER BY a;
    48  a
    49  2.7606985387162255E70
    50  1.0E100
    51  5.96094821228998E216
    52  drop table t1;
    53  create table t1(a tinyint, b SMALLINT, c bigint, d INT, e BIGINT, f FLOAT, g DOUBLE, h decimal(38,19));
    54  insert into t1 values(1, 1, 2, 4, 5, 5.5, 31.13, 14.314);
    55  select power(a,b),power(b,c),power(c,d),power(d,e),power(e,f),power(f,g),power(g,h) from t1;
    56  power(a,b)	power(b,c)	power(c,d)	power(d,e)	power(e,f)	power(f,g)	power(g,h)
    57  1.0	1.0	16.0	1024.0	6987.712429686842	1.1155538103726188E23	2.362467993555655E21
    58  drop table t1;
    59  select power(123.54-123.03, 12-34);
    60  power(123.54-123.03, 12-34)
    61  2713039.5562672606
    62  select power(123.54*0.34, 1203-1200);
    63  power(123.54*0.34, 1203-1200)
    64  74107.05283300664
    65  select power(134,34)-power(194,44);
    66  power(134,34)-power(194,44)
    67  -4.605492898028417E100
    68  drop table if exists t1;
    69  create table t1(a float,  b float);
    70  insert into t1 values(10, 100), (2, 5);
    71  select distinct * from t1 where power(a, b)>0;
    72  a	b
    73  10.0	100.0
    74  2.0	5.0
    75  drop table t1;
    76  create table t1(a INT, b int);
    77  create table t2(a INT, b int);
    78  insert into t1 values(2,4), (100,23);
    79  insert into t2 values(10,100), (4,41);
    80  SELECT t1.a, t2.a FROM t1 JOIN t2 ON (power(t1.a, t1.b) <> power(t2.a, t2.b));
    81  a	a
    82  100	10
    83  2	10
    84  100	4
    85  2	4
    86  drop table t1;
    87  drop table t2;
    88  drop table if exists t1;
    89  create table t1(a float,  b float);
    90  insert into t1 values(14.3, 4.413), (9.123, 9.409);
    91  select b from t1 group by b having power(1,b)>0;
    92  b
    93  4.413
    94  9.409
    95  drop table t1;