Issue Details (XML | Word | Printable)

Key: CORE-3244
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Adriano dos Santos Fernandes
Reporter: Paul Vinkenoog
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

POSITION: Wrong result with '' if third argument present

Created: 18/Nov/10 02:19 AM   Updated: 28/Apr/11 04:16 PM
Component/s: Engine
Affects Version/s: 2.1.3, 2.5.0
Fix Version/s: 2.1.4, 2.5.1, 3.0 Alpha 1

Time Tracking:
Not Specified

Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
select position ('', 'Broehaha') from rdb$database

returns 1 - correct: see standard, and we can suppose that an empty string (or even multiple) is present before every character in the string

select position ('', 'Broehaha', 4) from rdb$database

returns 1 - this should be 4, because we ask for occurences starting at position 4.

select position ('', 'Broehaha', 20) from rdb$database

returns 1 - this should be 0, because here we are past the end of the string, in the great Nothing.


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Philippe Makowski added a comment - 28/Apr/11 04:16 PM
QA test made