You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@asterixdb.apache.org by "Hussain Towaileb (Jira)" <ji...@apache.org> on 2019/10/11 10:42:00 UTC

[jira] [Created] (ASTERIXDB-2657) Add 1-based string functions and 0-based aliases for existing string functions

Hussain Towaileb created ASTERIXDB-2657:
-------------------------------------------

             Summary: Add 1-based string functions and 0-based aliases for existing string functions
                 Key: ASTERIXDB-2657
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2657
             Project: Apache AsterixDB
          Issue Type: Bug
          Components: FUN - Functions
    Affects Versions: 0.9.4.1
            Reporter: Hussain Towaileb
            Assignee: Hussain Towaileb
             Fix For: 0.9.5


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)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)