You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Thomas Rebele (Jira)" <ji...@apache.org> on 2025/08/25 17:09:00 UTC

[jira] [Commented] (CALCITE-7145) RexSimplify should not simplify IS NULL(10/0)

    [ https://issues.apache.org/jira/browse/CALCITE-7145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18016038#comment-18016038 ] 

Thomas Rebele commented on CALCITE-7145:
----------------------------------------

Thank you for the confirmation. I think we can keep it simple and handle the divide-by-zero with the existing type system. If there are more cases where expressions do not terminate, it might make sense to add a termination property to the type system.

I had a quick search with keywords "IS NULL" and "division" before creating the ticket, but couldn't find any relevant tickets.

> RexSimplify should not simplify IS NULL(10/0)
> ---------------------------------------------
>
>                 Key: CALCITE-7145
>                 URL: https://issues.apache.org/jira/browse/CALCITE-7145
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Thomas Rebele
>            Assignee: Thomas Rebele
>            Priority: Major
>              Labels: pull-request-available
>
> RexSimplify incorrectly simplifies {{IS NULL(10/0)}} to false and {{IS NOT NULL(10,0)}} to true
> In other DBMS it's either the inverse (sqlite, MySQL, MariaDB), or they throw an exception in both cases (Oracle, Postgres). The behavior was also mentioned in a comment on CALCITE-3368.
> Is it right that throwing an exception during query execution is the expected behavior according to the SQL standard?



--
This message was sent by Atlassian Jira
(v8.20.10#820010)