v.20.3New Feature
Add moduloOrZero function
Why it matters
ThemoduloOrZero function provides a safer modulo operation that returns zero instead of error or undefined results when the divisor is zero. This prevents query failures and improves robustness when performing modulo calculations that might include zero divisors.How to use it
Use the function in your SQL queries asmoduloOrZero(dividend, divisor). It will return the modulo result when the divisor is non-zero and zero when the divisor is zero.