Type-coercion errors calling round function with two arguments

[andygrove]

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

[WinkerDu]

It seems round in df is an unary function with signature: signature Uniform(1, [Float64, Float32])
The possible approach to solve this issue is:

• Extends the round signature to one_of
• Introduces the new round expression implementation in math_expressions.rs

I can take this ticket as appropriate. @andygrove Can you assign this issue to me? Thank you.

[andygrove]

Sorry @WinkerDu I just saw your request here, I am hitting this error in multiple places and I created this ticket using round as 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.

[andygrove]

@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]

Unassigned this as it is more than 6 months ago.