[jira] [Assigned] (FLINK-28893) Add conv function supported in SQL & Table API

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

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

Leonard Xu reassigned FLINK-28893:
----------------------------------

    Assignee: jackylau

> Add conv function supported in SQL & Table API
> ----------------------------------------------
>
>                 Key: FLINK-28893
>                 URL: https://issues.apache.org/jira/browse/FLINK-28893
>             Project: Flink
>          Issue Type: Improvement
>          Components: Table SQL / API
>    Affects Versions: 1.17.0
>            Reporter: jackylau
>            Assignee: jackylau
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 1.17.0
>
>
> Returns true if {{array}} contains {{{}value{}}}.
> Syntax:
> {code:java}
> conv(number, fromBase, toBase) {code}
> Arguments:
>  * number: INTEGER_NUMERIC or CHARACTER_STRING family.
>  * fromBase: INTEGER_NUMERIC family.
>  * toBase: INTEGER_NUMERIC family.
> Returns:
> Converts numbers between different number bases. Returns a string representation of the number {_}{{N}}{_}, converted from base _{{from_base}}_ to base {_}{{to_base}}{_}. Returns {{NULL}} if any argument is {{{}NULL{}}}. The argument _{{N}}_ is interpreted as an integer, but may be specified as an integer or a string. The minimum base is {{2}} and the maximum base is {{{}36{}}}. If _{{from_base}}_ is a negative number, _{{N}}_ is regarded as a signed number. Otherwise, _{{N}}_ is treated as unsigned. [{{CONV()}}|https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html#function_conv] works with 64-bit precision.
> Examples:
> {code:java}
> > SELECT CONV(100, 10, -8);
>  "144"
> > SELECT CONV(1111, 2, 10);
>  "15"
> > SELECT CONV(100, 2, NULL);
>  NULL {code}
> See more:
>  * pg: [https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html#function_conv]
>  * mariadb: [https://mariadb.com/kb/en/conv/]



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