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)
