[CALCITE-2965] Implement string functions: REPEAT, SPACE, SOUNDEX, DIFFERENCE

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.19.0
• Fix Version/s: 1.20.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Chunwei Lei
• Reporter: Chunwei Lei
• Created: 31/Mar/19 02:02
• Updated: 28/Jul/23 18:29
• Resolved: 17/May/19 04:28

Description

Some string functions including REPEAT, SPACE, SOUNDEX, DIFFERENCE are not implemented now. It would be great if these functions can be implemented.

Issue Links

• is a parent of: CALCITE-3084 Implement JDBC string functions: ASCII, REPEAT, SPACE, SOUNDEX, DIFFERENCE
• is related to: CALCITE-2846 Document Oracle-specific functions, such as NVL and LTRIM, in the SQL reference
• relates to: CALCITE-5840 Incorrect SOUNDEX function semantics in MySQL library
• relates to: CALCITE-5831 Add SOUNDEX function(enabled in Spark library)
• supercedes: CALCITE-3064 [JDBC function escape] String not implemented REPEAT
• links to: GitHub Pull Request #1140
• links to: GitHub Pull Request #1224