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

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.5.0, 4.4.1
    • None
    • 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

        Issue Links

          Activity

            People

              naveenmadhire Naveen Madhire
              jamestaylor James R. Taylor
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: