[ https://issues.apache.org/jira/browse/CALCITE-5685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated CALCITE-5685: ------------------------------------ Labels: pull-request-available (was: ) > Support MySQL CONVERT function that works on data types > ------------------------------------------------------- > > Key: CALCITE-5685 > URL: https://issues.apache.org/jira/browse/CALCITE-5685 > Project: Calcite > Issue Type: Improvement > Components: core > Affects Versions: 1.34.0 > Reporter: ZheHu > Assignee: ZheHu > Priority: Minor > Labels: pull-request-available > > CONVERT function in MySQL has two usage: > # convert(s USING transcodingName): as described in > [CALCITE-5664|https://issues.apache.org/jira/projects/CALCITE/issues/CALCITE-5664] > # convert(value, type): equivalent to CAST function that converts value to > specific type. > Here are some examples: > * convert(150, CHAR) > * convert(now(), DATE) > * convert('9.5', DECIMAL(10, 2)) > * convert(15, SIGNED) > * convert(-2, UNSIGNED) > Noted: for CONVERT or CAST function in MySQL, they only support converting to > some specific data > types(binary、char、date、time、datetime、decimal、signed、unsigned. Moreover, the > last two aren't JDBC sql Types). > -- This message was sent by Atlassian Jira (v8.20.10#820010)