modules/calcite/src/test/sql/function/numeric/test_pow.test

# name: test/sql/function/numeric/test_pow.test
# description: Power test
# group: [numeric]

statement ok
CREATE TABLE powerme(a DOUBLE, b INTEGER)

statement ok
INSERT INTO powerme VALUES (2.1, 3)

query R
select power(a, 0) from powerme
----
1.000000

query R
select power(b, -2)::REAL from powerme
----
0.11111111

query R
select power(a, b)::REAL from powerme
----
9.261000

query R
select power(b, a)::REAL from powerme
----
10.045109

query R
select power(b, a)::REAL from powerme
----
10.045109