[DERBY-1949] locate function documentation should clarify behavior when first parameter is empty string

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.1.3.1, 10.2.1.6
• Fix Version/s: 10.3.1.4
• Component/s: Documentation, SQL
• Environment: N/A
• Assignee: Bryan Pendleton
• Reporter: Oleksandr Alesinskyy
• Created: 10/Oct/06 10:30
• Updated: 21/Jan/11 17:49
• Resolved: 30/Mar/07 05:28

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.

Issue Links

• is part of: DERBY-2034 Tracking of bugs that lead to incorrect results being stored or returned to the client