[
https://issues.apache.org/jira/browse/CALCITE-6279?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17820260#comment-17820260
]
Caican Cai commented on CALCITE-6279:
-------------------------------------
It seems that my understanding of sql was wrong before. I used to think that
sql was a sql protocol similar to mysql and postgres. We need to follow one of
them. Now it seems that is not the case. sql rules are a similar programming
language. , it follows relational algebra, not which dialect.
> Use Null to replace the results of some Math functions that return NaN.
> -----------------------------------------------------------------------
>
> Key: CALCITE-6279
> URL: https://issues.apache.org/jira/browse/CALCITE-6279
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.36.0
> Reporter: Caican Cai
> Priority: Minor
> Fix For: 1.37.0
>
>
> Among Calcite's Math functions, there are some functions that return double
> types. They are calculated using Java's Math method in SqlFunctions, so when
> the result is empty, NaN will be returned, but according to SQL rules, NULL
> should be returned.
> e.g
> {code:java}
> f.checkScalarApprox("sqrt(-1)", "DOUBLE NOT NULL",
> "NaN"); {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
