[PHOENIX-1663] Implement missing string built-in functions

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: Java SQL gsoc2015 mentor
• Assignee: Unassigned
• Reporter: James R. Taylor
• Created: 14/Feb/15 06:20
• Updated: 01/Apr/15 02:09

Description

Take a look at the typical string functions that are implemented in relational database systems (http://www.postgresql.org/docs/8.1/static/functions-string.html) and implement the same for Phoenix in Java following this guide: http://phoenix-hbase.blogspot.com/2013/04/how-to-add-your-own-built-in-function.html

Examples of missing functions include POSITION, OVERLAY, REPEAT, etc.

Issue Links

• is a clone of: PHOENIX-1660 Implement missing math built-in functions

Sub-Tasks

• Implementing INSTR function: Closed
• Implementing INSTR function: Resolved
• Implement REPEAT Function: Open
• Document INSTR built-in function: Resolved
• Return value of INSTR should be one-based instead of zero-based: Closed