[FLINK-6892] Add L/RPAD supported in SQL

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.4.0
• Fix Version/s: 1.5.0
• Component/s: Table SQL / API
• Assignee: sunjincheng
• Reporter: sunjincheng
• Created: 12/Jun/17 08:50
• Updated: 24/Jan/18 10:48
• Resolved: 24/Jan/18 10:48

Description

L/RPAD(str,len,padstr) Returns the string str, left/right-padded with the string padstr to a length of len characters. If str is longer than len, the return value is shortened to len characters.

• Syntax:
  LPAD(str,len,padstr)

• Arguments
  **str: -
  **len: -
  **padstr: -

• Return Types
  String

• Example:
  LPAD('hi',4,'??') -> '??hi'
  LPAD('hi',1,'??') -> 'h'
  RPAD('hi',4,'') -> 'hi'
  RPAD('hi',1,'??') -> 'h'

• See more:
  • MySQL

Issue Links

• blocks: FLINK-6973 Add L/RPAD supported in TableAPI
• links to: GitHub Pull Request #4127