[ https://issues.apache.org/jira/browse/CALCITE-6456?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867448#comment-17867448 ]
Caican Cai commented on CALCITE-6456: ------------------------------------- Fixed in https://github.com/apache/calcite/commit/82a3219e1bc8ffac9bbd20be3dc8c11f3882ba50 > The MySQL log function rule LOG(x, base) is equivalent to LOG(base)/LOG(x) > -------------------------------------------------------------------------- > > Key: CALCITE-6456 > URL: https://issues.apache.org/jira/browse/CALCITE-6456 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.37.0 > Reporter: Caican Cai > Priority: Major > Fix For: 1.38.0 > > > The fact should be that the log function in mysql should be equivalent to > LOG(x, base) is equivalent to LOG(x)/LOG(base), and the calculation is not > the same as bigquery > bigquery: > {code:java} > select log(8, 64) > 0.5{code} > postgres: > {code:java} > select log(8,64) > 2{code} > mysql: > {code:java} > select log(8, 64) > 2 {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)