[IMPALA-6103] Error on Integer and Double modulo or divide by zero

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Backend
• Epic Link: Numeric Datatype Conversions
• Epic Color: ghx-label-1
• Assignee: Unassigned
• Reporter: Taras Bobrovytsky
• Created: 24/Oct/17 00:00
• Updated: 24/Oct/17 20:14

Description

In IMPALA-5018, we error on Decimal division by zero. It becomes inconsistent that we return a NULL on Integer divide by zero (instead of returning an error).

We should also consider returning an error if there is an overflow as a result of mathematical operations on Integers (and maybe Doubles).

In case of a double division by zero, Impala returns Infinity. We can consider returning an error in this case as well, because this is what Postgres does. In Postgres, modulo does not seem to be even defined for the double type, but we can consider returning an error in case of modulo double zero.

Issue Links

• is related to: IMPALA-5018 DECIMAL V2: Error on decimal divide by 0