[CALCITE-6224] Add LOG2 function (enabled in Mysql, Spark library)

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.36.0
• Fix Version/s: 1.37.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Caican Cai
• Reporter: Caican Cai
• Created: 25/Jan/24 10:58
• Updated: 06/May/24 22:19
• Resolved: 05/Mar/24 15:40

Description

The log2 function is supported in many databases, such as spark, mysql, postgres, etc.

> SELECT log2(2);
 1.0 

links：

https://spark.apache.org/docs/3.4.0/api/sql/index.html#log2

https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html#function_log2

Issue Links

• links to: GitHub Pull Request #3648
• links to: GitHub Pull Request #3689
• links to: GitHub Pull Request #3707