You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "hailong wang (Jira)" <ji...@apache.org> on 2020/10/21 16:13:00 UTC
[jira] [Updated] (FLINK-19753) Introduce 'STRCMP' function to
compare between two string fields
[ https://issues.apache.org/jira/browse/FLINK-19753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
hailong wang updated FLINK-19753:
---------------------------------
Description:
'STRCMP' function have be supported by mysql[1] and calcite[2] which is useful to compare two string fields.
'STRCMP' function result type is Integer type, and arguments are two string fields.
1. 0 if both of the strings are same and returns.
2. -1 when the first argument is smaller than the second according to the defined order.
3. 1 when the second one is smaller the first one.
[1] [https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html#function_strcmp]
[2] https://issues.apache.org/jira/browse/CALCITE-3704
was:
'STRCMP' function have be supported by mysql[1] and calcite[2] which is useful to compare two string field.
'STRCMP' function result type is Integer type, and arguments are two string fields.
1. 0 if both of the strings are same and returns.
2. -1 when the first argument is smaller than the second according to the defined order.
3. 1 when the second one is smaller the first one.
[1] [https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html#function_strcmp]
[2] https://issues.apache.org/jira/browse/CALCITE-3704
> Introduce 'STRCMP' function to compare between two string fields
> ----------------------------------------------------------------
>
> Key: FLINK-19753
> URL: https://issues.apache.org/jira/browse/FLINK-19753
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / Planner
> Affects Versions: 1.11.0
> Reporter: hailong wang
> Priority: Major
>
> 'STRCMP' function have be supported by mysql[1] and calcite[2] which is useful to compare two string fields.
> 'STRCMP' function result type is Integer type, and arguments are two string fields.
> 1. 0 if both of the strings are same and returns.
> 2. -1 when the first argument is smaller than the second according to the defined order.
> 3. 1 when the second one is smaller the first one.
> [1] [https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html#function_strcmp]
> [2] https://issues.apache.org/jira/browse/CALCITE-3704
--
This message was sent by Atlassian Jira
(v8.3.4#803005)