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
Describe the bug
At present,
power(decimal, float)returns a decimal , which leads to problematic behavior:To Reproduce
No response
Expected behavior
Both queries should return
39.0625, and probably of typeFloat64.Additional context
No response