[CALCITE-3704] Implement STRCMP function

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.23.0
• Labels: pull-request-available
• Assignee: Forward Xu
• Reporter: Forward Xu
• Created: 05/Jan/20 07:45
• Updated: 06/Dec/22 21:49
• Resolved: 13/Mar/20 08:46

Description

IMPLEMENT STRCMP FUNCTION

MySQL strcmp() function is used to compare two strings. It returns 0 if both of the strings are same and returns -1 when the first argument is smaller than the second according to the defined order and 1 when the second one is smaller the first one.

Syntax:
STRCMP (expr1, expr2)

Issue Links

• is duplicated by: CALCITE-3293 Add strcmp function
• links to: GitHub Pull Request #1768