[
https://issues.apache.org/jira/browse/CALCITE-7295?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18038924#comment-18038924
]
Julian Hyde commented on CALCITE-7295:
--------------------------------------
Division by zero is the main thing, but it is a huge thing. There is also the
proposed “safe divide” behavior. It would be helpful of you could give a theory
of the circumstances in which “(x / y) is null” can and cannot be simplified.
> RexSimplify should simplify a division with a NULL argument
> -----------------------------------------------------------
>
> Key: CALCITE-7295
> URL: https://issues.apache.org/jira/browse/CALCITE-7295
> Project: Calcite
> Issue Type: Task
> Reporter: Thomas Rebele
> Assignee: Thomas Rebele
> Priority: Major
>
> Some expressions, such as
> * {{null + a/4}}
> * {{a/null}}
> * {{null/0}}, which gets simplified to {{null}} by PostgreSQL, Oracle,
> SQLite, MariaDB, and MySQL,
> are not simplified. This ticket aims to improve RexSimplify to support these
> kind of statements.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
