[ https://issues.apache.org/jira/browse/CALCITE-3717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Hyde updated CALCITE-3717: --------------------------------- Summary: Dividing by nullable numeric throws "ArithmeticException: Division by zero" (was: Query fails with "division by zero" exception) > Dividing by nullable numeric throws "ArithmeticException: Division by zero" > --------------------------------------------------------------------------- > > Key: CALCITE-3717 > URL: https://issues.apache.org/jira/browse/CALCITE-3717 > Project: Calcite > Issue Type: Bug > Affects Versions: 1.21.0 > Reporter: Hank Miller > Assignee: Feng Zhu > 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)