[
https://issues.apache.org/jira/browse/CALCITE-6259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17820483#comment-17820483
]
Caican Cai edited comment on CALCITE-6259 at 2/25/24 2:47 PM:
--------------------------------------------------------------
I will output a document for calcite’s math function and analyze the results of
the math function’s negative test in mysql and postgres. At that time, you can
evaluate whether we need to modify this part based on this document.
was (Author: JIRAUSER302115):
I will output a document for the math function. At that time, you can evaluate
whether we need to modify this part based on this.
> The implementation of the Log library operator does not match the actual
> dialect behavior.
> ------------------------------------------------------------------------------------------
>
> Key: CALCITE-6259
> URL: https://issues.apache.org/jira/browse/CALCITE-6259
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.36.0
> Reporter: Caican Cai
> Priority: Major
> Fix For: 1.37.0
>
> Attachments: 302662660-27b21670-5364-463c-b6dc-d750c46d7cd1.png,
> 302663876-91173a60-695d-409e-b325-3f91655c6d0d.png
>
>
> The implementation of the Log library operator does not match the actual
> dialect behavior.
> For example, when log10(0) returns null in mysql and spark, but log10(0)
> returns error in postgres, neither is calcite's -Intity
> {code:java}
> postgres=# select log10(0);
> ERROR: cannot take logarithm of zero
> postgres=# select log(2,0);
> ERROR: cannot take logarithm of zero
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
