Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10764 PL/SQL parser - Phase 2
  3. MDEV-12090

Make INSTR understand optional parameters for position and occurence

    XMLWordPrintable

    Details

    • Type: Technical task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      Currently the built-in function INSTR understands two parameters:

      INSTR(string, substring)
      

      We'll extend INSTR to understand two extra optional parameters:

      INSTR(string, substring [,position [,occurence])
      

      where:

      • position is an nonzero integer indicating the character of string where to begin the search. If position is negative, then INSTR counts backward from the end of string and then searches backward from the resulting position.
      • occurrence is a positive integer indicating which occurrence of string to search for.

        Attachments

          Activity

            People

            Assignee:
            bar Alexander Barkov
            Reporter:
            bar Alexander Barkov
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: