Uploaded image for project: 'Apache AsterixDB'
  1. Apache AsterixDB
  2. ASTERIXDB-2657

Add 1-based string functions and 0-based aliases for existing string functions

    XMLWordPrintableJSON

    Details

    • 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
    • Labels:
      None

      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)

        Attachments

          Activity

            People

            • Assignee:
              HussainHT Hussain Towaileb
              Reporter:
              HussainHT Hussain Towaileb
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: