[
https://issues.apache.org/jira/browse/CALCITE-7295?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18038919#comment-18038919
]
Mihai Budiu commented on CALCITE-7295:
--------------------------------------
I think CALCITE-7270 should be solved first, it is independent on this issue,
and it will make it easier to solve this problem. I started work on it.
> 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)
