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: 19/Jan/16 05:02 AM
Component/s: Charsets/Collation, Engine
Affects Version/s: 2.1 Beta 1
Fix Version/s: 2.1 Beta 2

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

Issue Links:

QA Status: No test

 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   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.