Repository navigation
power(decimal, float) should return float #22472
Description
Describe the bug
At present, power(decimal, float) returns a decimal , which leads to problematic behavior:
> SELECT power(cast(2.5 as decimal(2,1)), 4.0);
+--------------------------------+
| power(Float64(2.5),Float64(4)) |
+--------------------------------+
| 3.9 |
+--------------------------------+
1 row(s) fetched.
Elapsed 0.004 seconds.
> SELECT power(cast(2.5 as decimal), 4.0);
Arrow error: Arithmetic overflow: Cannot raise base 25000000000 to exp 4
To Reproduce
No response
Expected behavior
Both queries should return 39.0625, and probably of type Float64.
Additional context
No response
Activity
neilconway commentedon May 23, 2026
take