Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1663 Implement missing string built-in functions
  3. PHOENIX-1984

Return value of INSTR should be one-based instead of zero-based

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.5.0, 4.4.1
    • Labels:
      None

      Description

      String functions in SQL are one-based, not zero-based. One should be added to the return value of the INSTR function as it's returning a zero-based return value current.

      We'll hold off on documenting this built-in until this is corrected.

        Attachments

          Activity

            People

            • Assignee:
              naveenmadhire Naveen Madhire
              Reporter:
              jamestaylor James Taylor
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: