[ASTERIXDB-2657] Add 1-based string functions and 0-based aliases for existing string functions

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.4.1
• Fix Version/s: 0.9.5
• Component/s: FUN - Functions
• Assignee: Hussain Towaileb
• Reporter: Hussain Towaileb
• Created: 11/Oct/19 10:41
• Updated: 21/Oct/19 18:26
• Resolved: 21/Oct/19 18:26

Description

String functions are currently 0-based (POSITION, etc).  We need to create 1-based string functions (POSITION1, etc), and 0-based aliases (POSITION0, etc)

Here's the list of functions/aliases the need to be implemented:

POS (= POSITION)

POSITION0 (=POSITION)

POS0 (=POSITION)

POSITION1 

POS1 (=POSITION1)

SUBSTR0 (=SUBSTR)

SUBSTR1

CONTAINS_REGEX (=REGEXP_CONTAINS)

CONTAINS_REGEXP (=REGEXP_CONTAINS)

REGEX_CONTAINS (=REGEXP_CONTAINS)

REGEX_LIKE (=REGEXP_LIKE)

REGEX_POSITION0 (=REGEXP_POSITION0)

REGEX_POS0 (=REGEXP_POSITION0)

REGEXP_POSITION0

REGEXP_POS0 (=REGEXP_POSITION0)

REGEX_POSITION1 (=REGEXP_POSITION1)

REGEX_POS1 (=REGEXP_POSITION1)

REGEXP_POSITION1 

REGEXP_POS1 (=REGEXP_POSITION1)

REGEX_POSITION (=REGEXP_POSITION0)

REGEX_POS (=REGEXP_POSITION0)

REGEX_REPLACE (=REGEXP_REPLACE)

REGEXP_POSITION (=REGEXP_POSITION0)

REGEXP_POS (=REGEXP_POSITION0)