Improve scale support for binary decimal operations #19621
Description
Is your feature request related to a problem or challenge?
A helper calculate_binary_math and UDFs relying on it could behave strangely if the scales of inputs and outputs are different. Original logic didn't fully handle it.
Describe the solution you'd like
Improve helpers to rescale decimal literals and arrays if they have different scales. I have an experimental implementation to tackle this problem transparently for UDFs.
Describe alternatives you've considered
No response
Additional context
No response