v.21.11Improvements
Avoid "Division by zero" Errors in Nullable Denominators for Functions Divide, IntDiv, and Modulo
Avoid error "Division by zero" when denominator is Nullable in functionsdivide,intDivandmodulo. Closes #22621. #28352 (Kruglov Pavel).
Why it matters
This feature prevents runtime errors caused by dividing or taking the modulo by a Nullable denominator that might be zero, improving query stability and reliability when working with Nullable types.How to use it
Users do not need to change their queries; the fix automatically handles Nullable denominators safely individe, intDiv, and modulo functions to avoid division-by-zero errors.