[CALCITE-3717] Dividing by nullable numeric throws "ArithmeticException: Division by zero"

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.21.0
• Fix Version/s: 1.24.0
• Assignee: Feng Zhu
• Reporter: Hank Miller
• Created: 08/Jan/20 11:18
• Updated: 28/May/21 10:12
• Resolved: 26/Jun/20 17:20

Description

Hi, community. We use Calcite-1.21 to connect and compute data resident in PostgreSQL and MySQL. It works pretty well. But we encountered a problem yesterday.

Firstly, we combine data from different datasources.

Assume the combined table is T(...., c1, c2, c3), in which c1, c2, c3 are integer columns. Then according to our business logic, we need to perform further data processing in Calcite.

select case when c1=0 then ..
            when c2=0 then 1.0/c1 + ...
            when c3=0 then 1.0/c1 + 1.0/c2 + ...
       else -99.99 end 
from T

However, the query throws "java.lang.ArithmeticException: Division by zero".

Anything goes wrong?

Issue Links

• duplicates: CALCITE-3224 New RexNode-to-Expression CodeGen Implementation