[
https://issues.apache.org/jira/browse/CALCITE-2823?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17246240#comment-17246240
]
Julian Hyde commented on CALCITE-2823:
--------------------------------------
[~Aron.tao], Can you define 'deterministic', and give examples? What about
'dynamic'?
(I asked this question two years ago, and never got an answer, but it is
important that we establish the basic terminology.)
> Prevent optimization of non-deterministic functions
> ---------------------------------------------------
>
> Key: CALCITE-2823
> URL: https://issues.apache.org/jira/browse/CALCITE-2823
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: Siddharth Teotia
> Priority: Major
>
> RexSimplify and RexProgram optimize expressions like A() = A() to true, but
> if A() is a non-deterministic expression, this optimization is invalid.
> Change RexSimplify and RexProgram to check if expression is deterministic or
> not, in order to decide about the optimization.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
