[CALCITE-3435] Enable decimal modulus operation to allow numeric with non-zero scale

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.16.0, 1.21.0
• Fix Version/s: 1.22.0
• Labels: pull-request-available
• Assignee: Feng Zhu
• Reporter: jiezouSH
• Created: 21/Oct/19 07:30
• Updated: 28/May/21 10:09
• Resolved: 08/Nov/19 01:39

Description

mod's return type is

chain(DECIMAL_MOD_NULLABLE, ARG1_NULLABLE),

but mod(33.5,7)'s result is 5.5, not in line with ARG1_NULLABLE.

This causes floor(mod(33.5,7)) wrongly returns 5.5

Issue Links

• links to: GitHub Pull Request #1563