Issue Details (XML | Word | Printable)

Key: CORE-3761
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Trivial Trivial
Assignee: Dmitry Yemanov
Reporter: Maxim Kuzmin
Votes: 0
Watchers: 1
Operations

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

Conversion error when using a blob as an argument for the EXCEPTION statement

Created: 15/Feb/12 03:22 AM   Updated: 16/May/12 03:26 PM
Component/s: None
Affects Version/s: 2.1.0, 2.1.1, 2.1.2, 2.1.3, 2.5.0, 2.1.4, 2.5.1
Fix Version/s: 2.1.5, 2.5.2

Time Tracking:
Not Specified

Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
CREATE EXCEPTION CHECK_EXCEPTION 'Check exception';

EXECUTE BLOCK
AS
BEGIN
    EXCEPTION CHECK_EXCEPTION
        (SELECT LIST('WORD') FROM RDB$DATABASE);
END


Executing this block throws exception:
Overflow occurred during data type conversion.
conversion error from string "BLOB".

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 15/Feb/12 03:42 AM
A bit simplier test case:

    EXCEPTION CHECK_EXCEPTION
        CAST ('WORD' AS BLOB SUB_TYPE TEXT);

Dmitry Yemanov added a comment - 15/Feb/12 08:35 AM
Fixed in the v2.1 and v2.5 branches. v3.0 is not affected.