[CALCITE-6259] The implementation of the Log library operator does not match the actual dialect behavior.

• Type: Improvement
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.36.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Caican Cai
• Reporter: Caican Cai
• Created: 11/Feb/24 13:16
• Updated: 18/Sep/24 11:07

Description

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

postgres=# select log10(0);
ERROR:  cannot take logarithm of zero
postgres=# select log(2,0);
ERROR:  cannot take logarithm of zero

 

Issue Links

• links to: GitHub Pull Request #3710
• links to: GitHub Pull Request #3711

Sub-Tasks

• Add LOG function (enabled in Mysql and Spark library): Closed
• Add LOG10 and LN function (enabled in Mysql, Spark library): Open