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 14:16:00 UTC

[jira] [Created] (CALCITE-7145) RexSimplify produces an incorrect result for IS NULL(10/0)

Thomas Rebele created CALCITE-7145:
--------------------------------------

             Summary: RexSimplify produces an incorrect result for IS NULL(10/0)
                 Key: CALCITE-7145
                 URL: https://issues.apache.org/jira/browse/CALCITE-7145
             Project: Calcite
          Issue Type: Bug
            Reporter: Thomas Rebele


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)