[jira] [Created] (CALCITE-3717) Query fails with "division by zero" exception

["Hank Miller (Jira)" <ji...@apache.org>]

Hank Miller created CALCITE-3717:
------------------------------------

             Summary: Query fails with "division by zero" exception
                 Key: CALCITE-3717
                 URL: https://issues.apache.org/jira/browse/CALCITE-3717
             Project: Calcite
          Issue Type: Bug
            Reporter: Hank Miller


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.

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 make further data processing in Calcite.
{code:java}
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{code}
However, the query throws "java.lang.ArithmeticException: Division by zero".

Anything goes wrong?



--
This message was sent by Atlassian Jira
(v8.3.4#803005)