[
https://issues.apache.org/jira/browse/CALCITE-3717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hank Miller updated CALCITE-3717:
---------------------------------
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.
{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?
was:
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?
> 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
> Priority: Major
>
> 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.
> {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)
