Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1949

locate function documentation should clarify behavior when first parameter is empty string

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.1.3.1, 10.2.1.6
    • 10.3.1.4
    • Documentation, SQL
    • None
    • N/A

    Description

      Documentation for the locate function does not clearly explain the behavior when first parameter is empty string, e.g.

      values locate('','A')

      results in 1, and

      values locate('', 'ABC', 5)

      returns 5, but the documentation does not clearly explain why this is so.

      Attachments

        1. docs.diff
          4 kB
          Bryan Pendleton
        2. rrefsqlj61998.html
          5 kB
          Bryan Pendleton
        3. docs_v2.diff
          4 kB
          Bryan Pendleton
        4. rrefsqlj61998.html
          5 kB
          Bryan Pendleton

        Issue Links

          Activity

            People

              bryanpendleton Bryan Pendleton
              al0 Oleksandr Alesinskyy
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: