Caican Cai created CALCITE-6232:
-----------------------------------
Summary: Using fractions and 0 in LOG function does not return
correct results
Key: CALCITE-6232
URL: https://issues.apache.org/jira/browse/CALCITE-6232
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.36.0
Reporter: Caican Cai
Fix For: 1.37.0
The correct result in mysql is as follows
{code:java}
mysql> SELECT LOG10(2/3) AS result;
+---------------------+
| result |
+---------------------+
| -0.1760912594899757 |
+---------------------+
1 row in set (0.00 sec)
mysql> SELECT LOG2(0) AS result;
+--------+
| result |
+--------+
| NULL |
+--------+
1 row in set, 1 warning (0.01 sec)
mysql> SELECT LOG2(2/3) AS result;
+---------------------+
| result |
+---------------------+
| -0.5849625021638512 |
+---------------------+
1 row in set (0.00 sec)
{code}
The log2 and log10 results of calcite are -Infinity
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
