Issue Details (XML | Word | Printable)

Key: CORE-1466
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Adriano dos Santos Fernandes
Votes: 0
Watchers: 0

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

Substring of multi-byte BLOBs can fail

Created: 16/Sep/07 11:40 AM   Updated: 16/Nov/09 05:14 PM
Component/s: Charsets/Collation, Engine
Affects Version/s: 2.1 Beta 1
Fix Version/s: 2.1 Beta 2

Time Tracking:
Not Specified

File Attachments: 1. File SEARCH.FDB.bz2 (144 kB)

Issue Links:

 Description  « Hide
SUBSTRING function tries to convert MBCS BLOB to UTF16, and depending on BLOB content, the value passed by the engine to SUBSTRING may be a multi-byte truncated string.

Database attached. Test case:
select substring(document from 4 for 1) from t_documents where id = 1;

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.