Repository navigation
Type-coercion errors calling round function with two arguments #2420
Description
Describe the bug
I am trying to run query SELECT round(c1/3, 2) FROM aggregate_simple order by c1 where c1 is a decimal. The query fails with Coercion from [Decimal(29, 23), Int64] to the signature Uniform(1, [Float64, Float32]) failed..
To Reproduce
Run the query shown above.
Expected behavior
Query should work.
Additional context
None
Activity
WinkerDu commentedon May 3, 2022
It seems
roundin df is an unary function with signature:signature Uniform(1, [Float64, Float32])The possible approach to solve this issue is:
roundsignature toone_ofroundexpression implementation inmath_expressions.rsI can take this ticket as appropriate. @andygrove Can you assign this issue to me? Thank you.
andygrove commentedon May 10, 2022
Sorry @WinkerDu I just saw your request here, I am hitting this error in multiple places and I created this ticket using
roundas one example. I assigned this to you but I am also going to take a look because I am not very familiar with this type-coercion signature code and I will probably have some questions for you.[-]Type-coercion error with decimal type[/-][+]Type-coercion errors calling `round` function with two arguments[/+]andygrove commentedon May 10, 2022
@WinkerDu I created #2503 to address this at the logical plan level but perhaps you could fix this in the physical planner to close this issue?
viirya commentedon Mar 30, 2023
Unassigned this as it is more than 6 months ago.