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)