[jira] [Resolved] (CALCITE-6730) Add CONVERT function(enabled in Oracle library)

["ZheHu (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-6730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

ZheHu resolved CALCITE-6730.
----------------------------
    Fix Version/s: 1.39.0
       Resolution: Fixed

Fixed in [901aadb|https://github.com/apache/calcite/commit/901aadbe8bd55e2da791d9d827185a8c803b1b76].
Thank you guys for the review. [~duanzhengqiang] [~nobigo] [~mbudiu]

> Add CONVERT function(enabled in Oracle library)
> -----------------------------------------------
>
>                 Key: CALCITE-6730
>                 URL: https://issues.apache.org/jira/browse/CALCITE-6730
>             Project: Calcite
>          Issue Type: Improvement
>          Components: core
>    Affects Versions: 1.38.0
>            Reporter: ZheHu
>            Assignee: ZheHu
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 1.39.0
>
>
> Unlike standard CONVERT function implemented in Calcite:
> {code:java}
> convert(string bytea, src_encoding name, dest_encoding name)
> {code}
> Oracle's [CONVERT |https://docs.oracle.com/en/database/oracle/oracle-database/19/nlspg/sql-and-plsql-programming-in-global-environment.html#GUID-7E4AA2C5-8CD7-4836-AA69-6C8E02594FAC] works like:
> {code:java}
> convert(string bytea, dest_encoding name[, src_encoding name])
> {code}
> If the 'src_encoding' parameter is not specified, then it uses the default character set.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)