[
https://issues.apache.org/jira/browse/FLINK-28893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
jackylau updated FLINK-28893:
-----------------------------
Description:
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/]
was:
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/
> 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.16.0
> Reporter: jackylau
> Priority: Major
> Fix For: 1.16.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)
