Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-4884

INSTR function should work seamlessly with literal and non-literal arguments

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.15.0, 5.1.0
    • None
    • None

    Description

      INSTR's documentation reads as though it should support an expression or a literal for either argument. At least, it doesn't say that it only supports one or the other.

      However, the implementation only handles the case of INSTR(expr, literal). We can pretty easily make this better and work with any combination:

      e.g. INSTR(literal, expr), INSTR(expr, expr), INSTR(literal, literal)

      Attachments

        1. PHOENIX-4884.001.patch
          6 kB
          Josh Elser
        2. PHOENIX-4884.002.patch
          6 kB
          Josh Elser
        3. PHOENIX-4884.003.patch
          7 kB
          Josh Elser
        4. PHOENIX-4884.004.patch
          11 kB
          Josh Elser

        Activity

          People

            elserj Josh Elser
            elserj Josh Elser
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: