You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@flink.apache.org by "hailong wang (Jira)" <ji...@apache.org> on 2020/10/21 16:04:00 UTC

[jira] [Created] (FLINK-19753) Introduce 'STRCMP' function to compare between two string fields

hailong wang created FLINK-19753:
------------------------------------

             Summary: 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


'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



--
This message was sent by Atlassian Jira
(v8.3.4#803005)