[CALCITE-3005] Implement string functions: LEFT, RIGHT

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.20.0
• Labels: pull-request-available
• Assignee: Forward Xu
• Reporter: Forward Xu
• Created: 16/Apr/19 07:55
• Updated: 24/Jun/19 15:02
• Resolved: 03/Jun/19 18:19

Description

Some string functions including LEFT, RIGHT are not implemented now. It would be great if these functions can be implemented.

LEFT(str,len)

Returns the leftmost len characters from the string str, or NULL if any argument is NULL.

RIGHT(str,len)

Returns the rightmost len characters from the string str, or NULL if any argument is NULL.

Issue Links

• links to: GitHub Pull Request #1168