[TAJO-206] Implement SQL Standard String Functions

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: Function/UDF
• Assignee: Unassigned
• Reporter: Hyunsik Choi
• Created: 25/Sep/13 12:04
• Updated: 08/Feb/14 13:54
• Resolved: 08/Feb/14 13:54

Description

SQL standard provides various string operators and functions:

• String concatenation ('||')
• bit_length
• char_length or
• lower
• position
• substring
• trim
• upper

We also need to include these standard functions.

Sub-Tasks

• Implement UPPER(text), LOWER(text) function: Resolved
• Implement trim(text), ltrim(text), and rtrim(text) function: Resolved
• Implement bit_length(string) function: Resolved
• Implement char_length(string) function: Resolved
• Implement String concatenation operator (||): Resolved
• Implement hex function: Resolved
• Implement octet_length(text): Resolved
• Implement md5(text): Resolved
• Implement reverse(text): Resolved
• Implement right/left(text, size) function: Resolved
• Implement repeat(text,int) function: Resolved
• Implement sha1(text): Resolved
• Implement digest(text, text) function: Resolved